5th January 08:32
Although we figured out a way to fix this, I thought I would mention it
here for anyone else who may experience this error.
On our Reporting server, we started receiving the error "The report
server cannot open a connection to the report server database. The
logon failed. (rsReportServerDatabaseLogonFailed) Get Online Help.
Logon Failure: unknown user name or bad password."
things we tried:
1) restarted the reporting service (no help)
2) re-ran the rsConfig tool (no help)
3) Checked all DB permissions for the account and all were OK
4) Rebooted the server (no help)
What we did that DID help was to use make a copy of the
ReportServer.config file then run the rsConfig tool specifying a newly
created test account and making sure that account was an admin on the
box (restarted reportserver service). The report services reports
started working again. We then copied the original ReportServer.config
file back in place and restarted the reportserver service and all is
We do not know the original cause of the problem at this point but
found this as a way to get things working. All information that we
found on the net pointed to the rsConfig tool but using the same
account again did not fix the problem for use. It was not until we
used a new account that everything started working again.. Perhaps
there is a hard coded cached somewhere that held on to the user
information on IIS.
We just thought we would share for the next person.