SQL Server Performance

Slow To Add “New Role Assignment”

Discussion in 'SQL Server Reporting Services' started by JolyonSpencer, Oct 13, 2004.

  1. JolyonSpencer New Member

    I#%92m currently using Microsoft Reporting Services with Service Pack1.

    When defining role-based security for a folder, adding a user name to a folder together with a role takes approx. 2 minutes to action.

    I am performing the “New Role Assignment” via the Web Based SQL Server Reporting Services Report Manager to action my request. If the user already exists the system is quick to respond, telling me this i.e. “The group of user already has a role assignment on xxxxxxxxx.” Where xxxxxxxx is the name of my folder.

    Any ideas why Reporting Services is taking so long?


    Regards

    Jolyon
  2. satya Moderator

    No hint but can you see any error or warning messages in SQL server error log or event viewer log.
    Any issues while installing Reporting Services?

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. JolyonSpencer New Member

    quote:Originally posted by satya

    No hint but can you see any error or warning messages in SQL server error log or event viewer log.
    Any issues while installing Reporting Services?

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    Thanks for the tip. I did check the installation logs and database but nothing.

    A friend pointed out that it could simply be the time taken to resolve the NT Logon Id, large comapny with thousands of users.

    Its not entirely a show stopper for me, but a tad annoying when it takes so long, I guess I'll just have to be patient or if the users are doing this interactively show them someting interesting while they wait.

    Any other ideas? I'm open to suggestions.

    Regards

    Jolyon
  4. satya Moderator

    It depends on the authentication mode used to connect SQL Server, so how about the Authentication mode to connect to SQL server.

    And I believe in Report Services you cannot use SQL Server Security to access it. It relies on Integrated Windows Security.

    One of the MS Newsgroups thread refers If you wanted to avoid administering dual groups, you would have to switch from Standard to Windows in your other application and set up RS to use Windows Authentication in report data sources. But as Kent pointed out, there are some issues with forward delegation, a lot of people are having problems if all three components of RS (Report Manager IIS app, Report Server web service and RS SQL Server) are not on the same server.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page