Monday, August 7, 2006

The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing.

In Reporting Services 2005 for some reason, you sometimes get this error:

The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) Get Online HelpSQL Server does not exist or access denied.

Along with a reference to not having named pipes installed.

To fix it, just run the following command:

rsconfig -c -sMyServerName -dReportServer -awindows -uDomain\Account -pMyPassword

No comments:

Post a Comment