Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Issues with Report Service in production

Author  Topic 

deepsmehta
Starting Member

4 Posts

Posted - 2009-06-03 : 17:43:50
Hi
We have two servers under NLB for SSRS 2005. Report Service suddenly stops. I checked the event log and found follwoing Warning and Error Messages. We have configured SSRS Sevrice using Windows Service Account. Any solution for this problem? We have not provided any Execution Account in Reporting Services Configuration.


The SQL report service on Production Sevrer frequently stops. These interruptions are usually preceded by Application event 1517



Event Type: Warning

Event Source: Userenv

Event Category: None

Event ID: 1517

Date: 5/27/2009

Time: 11:03:06 PM

User: NT AUTHORITY\SYSTEM

Computer: DAVSSRS01

Description:

Windows saved user Domain\ServcieAccount registry while an application or service was still using the registry during log off. The memory used by the user's registry has not been freed. The registry will be unloaded when it is no longer in use.



This is often caused by services running as a user account, try configuring the services to run in either the LocalService or NetworkService account.



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



. . . and 1516

Event Type: Information

Event Source: Userenv

Event Category: None

Event ID: 1516

Date: 5/27/2009

Time: 11:03:29 PM

User: NT AUTHORITY\SYSTEM

Computer: DAVSSRS01

Description:

Windows unloaded user Domain\ServcieAccount registry when it received a notification that no other applications or services were using the profile.



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



. . . and usually accompanied by multiple instances of event id 107

Event Type: Error

Event Source: Report Server (MSSQLSERVER)

Event Category: Management

Event ID: 107

Date: 5/28/2009

Time: 4:16:41 AM

User: N/A

Computer: DAVSSRS01

Description:

Report Server (MSSQLSERVER) cannot connect to the report server database.



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



. . . another error associated with this phenomenon:

Event Type: Error

Event Source: Report Server (MSSQLSERVER)

Event Category: Extension

Event ID: 108

Date: 5/22/2009

Time: 8:45:46 AM

User: N/A

Computer: DAVSSRS01

Description:

Report Server (MSSQLSERVER) cannot load the Report Server DocumentLibrary extension.



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

- Advertisement -