Friday, November 14, 2008

The report server cannot open a connection to the report server database. The logon failed (rsReportServerDatabaseLogonFailed). Logon failure: unknown

Problem Description:
=======================================================================
"The report server cannot open a connection to the report server database. The logon failed (rsReportServerDatabaseLogonFailed). Logon failure: unknown user name or bad password."

Cause:
=======================================================================
Not configured properly rsreportserver.config

Resolution:
=======================================================================
Run the Rsconfig command rsconfig -c -s -d ReportServer -a windows -u -p
Run the Rsactivate.exe -c "c:\programfiles\microsoft sql server\mssql\reporting services\reportserver\rsreportserver.config"
Reset the iis and service of reportserver

No comments: