Report Server Windows Service (MSSQLServer) 107

Details

Category Value
Product Name SQL Server
Event ID 107
Event Source Report Server Windows Service
Component Reporting Services
Message Text Report Server Windows Service (MSSQLSERVER) can't connect to the report server database.

Explanation

The SQL Server 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:

  • SQL Server Database Engine service isn't running when the Report Server service starts.

  • The connection to the Database Engine 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 Reporting Services Configuration tool to set up the account or the report server database.

User action

Start the Database Engine service if it isn't running and check that remote connections are enabled for TCP/IP protocol.

Use the Reporting Services Configuration tool to configure the report server database and service account.

Internal-only

Configure the report server service account (Report Server Configuration Manager)
Report Server Configuration Manager (native mode)

Start and stop the report server service