Error (rsInternalError) after installation

I have installed Reporting Services 2005 64bit Enterprise Edition on WIN 2003 64bit SP1 Enterprise Edition.

Reporting Services Configuration Manager indicate that everything is ok, green checks except Encryption Keys and Execution Account.

Reporting Services databases, ReportServer and ReportServerTempDB, is not "installed" at the same server. Tha DB's runs at a SQL 2005 Server 64bit in the same domain.

I get following error:

http://localhost/reportserver:

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
Object reference not set to an instance of an object.

Event Viewer:

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 2006-02-24
Time: 10:11:35
User: N/A
Computer: PRD128ASAL
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 2006-02-24 10:11:35
Event time (UTC): 2006-02-24 09:00:25
Event ID: ac7dc3e0abc2412aab9566d56f81859e
Event sequence: 12
Event occurrence: 7
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/root/ReportServer-1-127851854434156417
Trust level: RosettaSrv
Application Virtual Path: /ReportServer
Application Path: C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportServer\
Machine name: XXXXXXXXXX
Process information:
Process ID: 1900
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: NullReferenceException
Exception message: Object reference not set to an instance of an object.
Request information:
Request URL: http://localhost/reportserver
Request path: /reportserver
User host address: 127.0.0.1
User: DOMAIN\USERID
Is authenticated: True
Authentication Type: Negotiate
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 1
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: True
Stack trace: at Microsoft.ReportingServices.Diagnostics.Globals.EndRequestContext()
at Microsoft.ReportingServices.WebServer.Global.Application_EndRequest(Object sender, EventArgs e)
at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Custom event details:

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Reporting Services LogFiles:

w3wp!library!8!02/24/2006-10:11:35:: e ERROR: Connection close failed. Exception thrown: System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Library.ConnectionManager.DisconnectStorage()
w3wp!library!1!2006-02-24-10:11:35:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
w3wp!library!1!2006-02-24-10:11:35:: e ERROR: Connection close failed. Exception thrown: System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Library.ConnectionManager.DisconnectStorage()
w3wp!runningjobs!1!2006-02-24-10:11:35:: e ERROR: Error in timer Running Requests DB : System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Library.ConnectionManager.DisconnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
at Microsoft.ReportingServices.Library.RunningJobDbTimer.DoTimerAction()
at Microsoft.ReportingServices.Diagnostics.TimerActionBase.TimerAction(Object unused)

Thankful for solution or any idea!

Regards, Jonas

Take a look at this thread.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=250225&SiteID=1

|||

Thanks Trish!

If I stop Reporting Services service, restarts the IIS and starts the Reporting Services service again I get following error.

http://localhost/reportserver:

The event source "Report Server" does not exist. (rsEventLogSourceNotFound)

Reporting Services LogFiles:

w3wp!library!1!2006-02-24-16:08:09:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.EventLogSourceNotFound: The event source "Report Server" does not exist., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.EventLogSourceNotFound: The event source "Report Server" does not exist.

After some minute I refresh the browser and now I get rsInternalError again.

(This behaviour is repeatable.)

It's possible that I have edit (no change!) the ASP.NET tab under properties for the ReportServer website in IIS 6. Why? Some of my first actions after discovering that the installation didn't work was to look in the IIS 6 MMC...

Any suggestions?

Regards, Jonas

|||

The only way we could fix the problem was to uninstall SQL Server and reinstall it.

We tried everything we could think of but it still didn't help. Now we know not to touch those settings!

|||

After hours of thinking, testing, googleing and head scratching I found a workaround.
I tried to change the Reporting Services application pool identity to a windows account. And it worked. This window account is a member of local administrators. Haven't tried more restricted rights yet.
But documentation from Microsoft recommends to use Network Service as application pool identity for Reporting Services.

I found this url interesting, http://support.microsoft.com/kb/896861/.
But I tried both workaround descibed whitout success.

Any idea? Anyone?
I really would like to use the Network Service account as recommended by Microsoft.

Regards, Jonas

|||

Try my solution on the following thread:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1985313&SiteID=1

Regards

Denis