Tuesday 1 March 2011

SQL Reporting Services Errors

Issue
SQL Reporting Services not working on dedicated SQL Reporting Server.

Symptoms and Troubleshooting
When attempting to run SQL Reporting Services configuration manager on an app server with RS installed (databases on different host), an 'invalid namespace' error was reported.

When I had a look, the ReportServerWindowService reported the following error in the application eventlog:
Event ID: 107
Source: Report Server Windows
"Report Server Windows Server (MSSQLSERVER) cannot connect to the report server database"

I attempted to run rsconfig.exe to repoint reporting services to the SQL Server, since the ReportServer and ReportServerTempDB databases had moved.  I got another error:
"No report servers were found on the specified machine."

I figured that since this server was restored from a tape backup, I'd check with the server team to make sure all looked ok at their end (which it wasn't)

Fix
The server team granted the IIS public account list permissions on the %SystemPath%\Temp directory.  SQL Reporting Services is running successfully now.


No comments:

Post a Comment