Post reply

User does not have permissions to view reports

  • March 14, 2012 at 1:50 pm

    #258669

    Hi there. I am trying to setup SSMS and SSRS on my local computer so I can learn how to create reports and stuff using SSRS. I have both apps installed (SQL SErver 2008 & BIDS/VS 2008). I downloaded and attached the AdventureWorks sample DB and reports. I am able to deploy the reports and I then go to localhost/reports and I can see the list of reports, but when I try to open one I get:

    Cannot create a connection to data source 'AdventureWorks2008'.

    Cannot open database "AdventureWorks2008" requested by the login. The login failed. Login failed for user '<domain>\<username>'.

    Here are my settings:

    In BIDS -> Shared Data Source -> Creds -> Windows Auth

    In SQL Server -> Security -> Logins -> MyLogin Properties -> Server Roles -> public and sysadmin

    In Reporting Config -> Service Account -> Network Service

    In Reporting Config -> Database -> Databasename -> ReportServer

    In Reporting COnfig -> Database -> Credential -> Windows Account

    In Report Manager -> Assign Roles -> System Admin (Note: Content manager is not listed)

    I am the admin on my machine. My login is listed in the dbo user profile for the DB.

    I have been battling for this (honestly) 15 hours. Please help!

  • March 14, 2012 at 5:22 pm

    #1459563

    Are you using SQL Server Security or Integrated Security?

    What happens if you log into the computer as local admin? If that works, its most likely a security issue in SQL Server (well, if you're using integrated security).

  • March 14, 2012 at 8:44 pm

    #1459595

    its most likely a security issue in SQL Server

  • March 14, 2012 at 9:12 pm

    #1459604

    I am using integrated security. I am logged on as the admin. I just noticed that if I try to preview a report in BIDS, I get an error message saying it can't connect to the data source. What do I need to do to get it to be able to connect to the data source? Where is that set?

  • March 15, 2012 at 2:50 am

    #1459684

    when you attached the AW database what name did you give it? check the name of the db in SQL matches the name of the db the data source is trying to connect to

  • March 15, 2012 at 8:29 am

    #1459888

    Hi Anthony, very good question. The error message says it cant find '/AdventureWorks2008'. But the name of the data source in BIDS is AdventureWorks, which matches the name of the DB as shown in SSMS. So where can I do look to find where it has the name 'AdventureWorks2008' listed?

  • March 15, 2012 at 8:32 am

    #1459893

    go into the data source and what DB does it want to access? if it matches the name of the DB in SQL then there is something else at play, if they are different either change the DS or the DB

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

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