| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | ms.custom | helpviewer_keywords | ||
|---|---|---|---|---|---|---|---|---|---|---|---|
Report Server Windows Service (MSSQLServer) 107 |
In this error reference page, learn about event ID 107: Report Server Windows Service (SQL Server) can't connect to the report server database. |
kfollis |
kfollis |
09/25/2024 |
reporting-services |
troubleshooting |
conceptual |
|
|
| Category | Value |
|---|---|
| Product Name | [!INCLUDEssNoVersion] |
| Event ID | 107 |
| Event Source | Report Server Windows Service |
| Component | [!INCLUDEssRSnoversion] |
| Message Text | Report Server Windows Service (MSSQLSERVER) can't connect to the report server database. |
The [!INCLUDEssNoVersion] Report Server service can't connect to the report server database. This error occurs during a service restart if a connection to the report server database can't be established. Conditions under which this error occurs include:
-
[!INCLUDEssNoVersion] [!INCLUDEssDE] service isn't running when the Report Server service starts.
-
The connection to the [!INCLUDEssDE] service fails because remote connections or the TCP/IP protocol isn't enabled.
-
The report server database isn't configured correctly.
-
The service account isn't configured correctly, or the account no longer has permissions on the report server database. This issue can occur if you don't use the [!INCLUDEssRSnoversion] Configuration tool to set up the account or the report server database.
Start the [!INCLUDEssDE] service if it isn't running and check that remote connections are enabled for TCP/IP protocol.
Use the [!INCLUDEssRSnoversion] Configuration tool to configure the report server database and service account.