Post reply

SSRS Server Rights Issue

  • May 27, 2010 at 1:14 pm

    #235707

    I have a user that when they log into our SSRS server, they don't get the regular menu bar.

    Just a screen that says

    SQL Server Reporting Services

    Home

    in the upper left corner,

    Home, My Subscriptions, Help

    in the upper right corner,

    and a blue/yellow bar across the screen where the menu with New folder, New Data Source, etc should be.

    It's apparently a windows rights issue, because if I put that user in the administrators group of the SQL Server, the menu returns. (It doesn't seem to be related to a SQL role, because if I make the user SA, it doesn't give him the menu).

    What windows group do I have to put the user in, or what rights are explicitly necessary for the user to get the menu bar?


    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

  • May 27, 2010 at 1:33 pm

    #1173564

    Gah show my rust.

    Ok when I gave the new group rights to the SSRS server, I didn't click on Home as my admin account, then click properties, and put the new group onto the root folder (Home) with any rights.


    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply