Post reply

Insufficient permissions

  • May 12, 2009 at 3:50 am

    #200379

    Hi there.

    I've just started using SSRS with SQL Server 2008. I've developed a report that I want to deploy to the report server but it says I have insufficient privileges.

    I CAN browse the URL

    http:///reports - even though there's nothing there yet

    But I CAN'T browse the URL

    http:///reportserver

    Where do I need to give myself privileges. I have owner permissions on the ReportServer databases as well as my datasource.

    Also, my reporting services configuration is as follows;

    Service Account - Local System

    Report Server Database - Service Account (Local Service)

    So where am I going wrong. Please help.

    Cheers,

    Dave

  • May 21, 2009 at 5:12 am

    #998171

    Have you tried creating a domain account (if using a domain). This account will need AD permission to browse the AD users/groups.

    To change the account details use the "Reporting Service Configuration Tool" within the Program Menu | Microsoft SQL Server 200x | Configuration Tools.

  • May 22, 2009 at 9:38 am

    #998945

    Hi

    i have the same problem. i cant browse to

    http:\\localhost\Reports

    neither can i manually launch report builder from the report server location because it is asking for some credentials. but i didnt set it to anything. probably i did something wrong with report configuration manager.

    any ideas how i can stop report builder from prompting for user name and password

    thanks

  • May 22, 2009 at 10:19 am

    #998983

    Report Builder is a Click once application and its possible that it is using your IIS settings (check your proxy settings)

    Also, check IIS Admin to see if you have anonymous access (see attached)

  • May 22, 2009 at 11:41 am

    #999049

    i was finally able to get in. i changed the user acounts and now im able to get it up but still i cant get to

    http:\\localhost\Reports.

    i had a problem and had to reinstall everything and i used named instance.

    so can i still get to the report manager using

    http:\\localhost\Reports or should i use soemthing else

    my named instance is mssairam

    please someone help

  • September 3, 2009 at 8:24 pm

    #1049192

    What worked for me was:

    Go to Site Setting

    Click on "Configure site-wide security"

    Click "New Role Assisgment" button in top bar

    Give the new role the following name "Everyone"

    Of teh available roles, grant it "System User" only

    Click "Apply"

    That should do it,

    Good luck!

Viewing 6 posts - 1 through 5 (of 5 total)

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