Search code examples
ssrs-2008access-denied

SSRS 2008 Permission Issue

I've spent almost whole day fixing permission issue on Reporting Server without any success. So would really appreciate any help.

Reporting services were already installed on the pc, but weren't ever used before. PC is running Win Server 2008 R2 Standard SP1 Pc is not in domain. SQL is 2008.

In Reporting Service Config Manager I setup account to 'Local System' and tried to access http://server/ReportServer (I tried any different accounts)

And here comes my problem. I keep getting error The permissions granted to user 'username' are insufficient for performing this operation. (rsAccessDenied)

I'm logged in as admin account. I understand that this is permission issue, but really not sure where can I fix this. Also user has db_owner + RSExecRole in ReportServer db

I can access http://server/Reports, but don't see site setting link.

Thanks for any suggestion.

Solution

  • OK, I found solution that worked for me. I had to edit RsReportServer.config file 

    <AuthenticationTypes>
   <RSWindowsNegotiate/>
   <RSWindowsNTLM/>
</AuthenticationTypes>

    I replaced code above with this 

    <AuthenticationTypes>
        <RSWindowsBasic/>
</AuthenticationTypes>

    Hope it helps someone else.