Share via


Report Server Windows Service (MSSQLServer) 107

New: 17 July 2006

Details

Product Name

SQL Server

Product Version

9.0

Product Build Number

9.00.1399

Event ID

107

Event Source

Report Server Windows Service

Component

Reporting Services

Message Text

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

Explanation

The Report Server Windows service (MSSQLSERVER) cannot connect to the report server database. This error occurs when a service restarts. It occurs if the SQL Server Database Engine service (MSSQLSERVER) is not running when the Report Server Windows service starts.

It also occurs if you do not use the Reporting Services Configuration tool to modify the Report Server Windows service account (for example, if you use Services in Administration Tools) and you restart the service.

It can also occur if the account used to run the service no longer has permissions on the database.

User Action

Always use the Reporting Services Configuration tool to update the Report Server Windows service account. The Reporting Services Configuration tool automatically updates the symmetric key and database connection settings that use the service identity.

See Also

Other Resources

Configuring Service Accounts and Passwords in Reporting Services
Managing Encryption Keys
Initializing a Report Server
Storing Encrypted Report Server Data

Help and Information

Getting SQL Server 2005 Assistance