cannot open a connection to the report server database

Question

when i execute http://localhost//reportserver this gives me following error..

The report server cannot open a connection to the report server database. The log on failed. (rsReportServerDatabaseLogonFailed)

Answer 1

That is a common error message if it is the first time you are using SSRS. If so, then you will need to enable Named Pipes. Here is how:

• Open the SQL Server Configuration Management tool.
• Click "SQL ServerNetwork Configuration"
• Click "Protocols for MSSQLSERVER"
• Make sure both the TCP/IP and Named Pipes protocols are enabled. (To enable a protocol, right-click on the protocol and click "Enable")

Answer 2

Run the configuration tool again, ensure the database section is configured appropriately and actually works.