| title | Report Server Windows Service (MSSQLServer) 107 | Microsoft Docs | |
|---|---|---|
| ms.date | 03/14/2017 | |
| ms.prod | reporting-services | |
| ms.prod_service | reporting-services-native | |
| ms.technology | troubleshooting | |
| ms.topic | conceptual | |
| helpviewer_keywords |
|
|
| ms.assetid | 52b5704b-27f9-400a-a821-d8fa0786afe4 | |
| author | maggiesMSFT | |
| ms.author | maggies |
| Product Name | [!INCLUDEssNoVersion] |
| Event ID | 107 |
| Event Source | Report Server Windows Service |
| Component | [!INCLUDEssRSnoversion] |
| Message Text | Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database. |
The [!INCLUDEssNoVersion] Report Server service cannot connect to the report server database. This error occurs during a service restart if a connection to the report server database cannot be established. Conditions under which this error occurs include the following:
-
[!INCLUDEssNoVersion] [!INCLUDEssDE] service is not running when the Report Server service starts.
-
The connection to the [!INCLUDEssDE] service fails because remote connections or the TCP/IP protocol is not enabled.
-
The report server database is not configured correctly.
-
The service account is not configured correctly, or the account no longer has permissions on the report server database. This can occur if you do not use the [!INCLUDEssRSnoversion] Configuration tool to set up the account or the report server database.
Start the [!INCLUDEssDE] service if it is not 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.
Configure the Report Server Service Account (SSRS Configuration Manager)
Reporting Services Configuration Manager (Native Mode)
Start and Stop the Report Server Service