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