I was at it for hours and every time I tried to browse the URL http://[servername]/ReportServer I was disappointed. The Report Server Logs (at C:\Program Files\Microsoft SQL Server\MSRS10_50.\ReportingService\Logs) says the User does not has access to Report Server Database. Tried all the obvious options:
- Checked if SQL Server Reporting Services is started.
- Checked if the report server service account user has access to ReportServer database.
- Restarted the server (most of the times this is your best resort)
But nothing worked.
Resolution:
You can resolve the issue by following these steps:
1. Open the rsreportserver.config file with a text editor
2. Search for the "SecureConnectionLevel" string.
3. Once found, You should have the related "Value" set to "2"; change it from "2" to "0".
Change the line: [Add Key="SecureConnectionLevel" Value="2"]
To be: [Add Key="SecureConnectionLevel" Value="0"]
For SQL Server 2008 R2, rsreportserver.config default location is:
C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer
For SQL Server 2012:
C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer