"rsAccessDenied" error for SSRS 2008
- by JackLocke
Hi All,
I have been trying to access SSRS Web Service URL
hxxp://myServer:80/ReportServer (from Reporting Service Configuration Manager), but my IE always shows "rsAccessDenied" message saying that my account doesn't have privilage required to view.
Here are my system specs.
Its my laptop with
Windows 7 x64,
and SQL Server 2008 with SP1 and I am using Mixed Mode Authentication with My account as SysAdmin privilages
and this is what I have been trying / tried ... (ofcourse with restarting the service everytime I make any change in configuration), I changed service account from Reporting Service Configuration Manager to make it use My account but nothing happend. I tried running my IE as admin, by RUN AS ADMIN but still same message. Then I read somewhere I have to delete/recreate my encryption keys as well, so I tried again with that, then it was asking me to enter ID/PWD to access server here I am totally blank because it was not accepting my account credentials !!!. Weird thing is I can see my existing reports if I follow this URL
hxxp://myServer:80/Reports , for which My guess is solely used to view reports.
I have read post here about kind of same problem, but it seems that OP just left forum after asking question... Also, MSDN does have these helps
hxxp://msdn.microsoft.com/en-us/library/ms156034.aspx
hxxp://msdn.microsoft.com/en-us/library/bb630430.aspx
but both of this didn't workout for me.
I will really appriciate it if any one can help me out.
Jack
p.s. I was not allowed to post more than 1 URL because of my "reputation" so I had to change the string a bit. Please replace hxxp wih http in URLs.