Служба Windows сервера отчетов (MSSQLServer) 107 Report Server Windows Service (MSSQLServer) 107

Сведения Details

Категория Category	Значение Value
Название продукта Product Name	SQL Server SQL Server
Идентификатор события Event ID	107 107
Источник события Event Source	Служба Windows сервера отчетов Report Server Windows Service
Компонент Component	Службы Reporting Services Reporting Services
Текст сообщения Message Text	Служба Windows сервера отчетов (MSSQLSERVER) не может соединиться с базой данных сервера отчетов. Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database.

Объяснение Explanation

Службе сервера отчетов SQL Server SQL Server не удается соединиться с базой данных сервера отчетов. The SQL Server SQL Server 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:

Компонент SQL Server SQL Server Компонент Database Engine Database Engine — служба не была запущена в момент запуска службы сервера отчетов. SQL Server SQL Server Компонент Database Engine Database Engine service is not running when the Report Server service starts.

Не удалось установить соединение со службой компонента Компонент Database Engine Database Engine , так как не включено использование удаленных соединений или протокола TCP/IP. The connection to the Компонент Database Engine Database Engine 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. Это может произойти в том случае, если настройка учетной записи или базы данных сервера отчетов производилась не через программу настройки служб Службы Reporting Services Reporting Services . This can occur if you do not use the Службы Reporting Services Reporting Services Configuration tool to set up the account or the report server database.

Действие пользователя User Action

Если служба компонента Компонент Database Engine Database Engine еще не запущена, то запустите ее и убедитесь, что включены удаленные соединения для протокола TCP/IP. Start the Компонент Database Engine Database Engine service if it is not running and check that remote connections are enabled for TCP/IP protocol.

Производите настройку базы данных сервера отчетов и учетной записи службы при помощи программы настройки служб Службы Reporting Services Reporting Services . Use the Службы Reporting Services Reporting Services Configuration tool to configure the report server database and service account.

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) cannot connect to the report server database.

Explanation

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

SQL Server Database Engine service is not running when the Report Server service starts.

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

User Action

Start the Database Engine service if it is not 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.

Reporting server windows service cannot connect

This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Asked by:

Question

I have 2 SQL servers, 1 principal and 1 mirror on a remote site. On the mirrored server, the following error is being logged.

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

The application domain WindowsService_17 failed to initialize. Error: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. —> System.Data.SqlClient.SqlException: Cannot open database «ReportServer» requested by the login. The login failed.

Login failed for user ‘MYDOMAIN\sqladmin’.

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)

at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)

at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)

at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)

at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)

at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)

at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)

at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)

at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)

at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)

at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

at System.Data.SqlClient.SqlConnection.Open()

at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection()

— End of inner exception stack trace —

at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection()

at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()

at Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread(Object firstStart).

TCP/IP and Named Pipes are enabled on both servers. When I open up the Report Server Configuration Manager on both servers, the settings match so I’m kind of lost as to what’s causing this issue.

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

I have 2 SQL Servers, 1 principal and 1 mirror on a remote site. On the mirrored server, the following error is being logged.

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

The application domain WindowsService_17 failed to initialize. Error: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing.

System.Data.SqlClient.SqlException: Cannot open database «ReportServer» requested by the login. The login failed.

Login failed for user ‘MYDOMAIN\sqladmin’.

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

TCP/IP and Named Pipes are enabled on both servers. When I open up the Report Server Configuration Manager on both servers, the settings match.

OURDOMAIN\sqladmin set up as the service account. SQL Server Reporting Services are running under the OURDOMAIN\sqladmin service account.

Troubleshoot Server & Database Connection Problems with Reporting Services

Use this topic to troubleshoot problems that you experience when connecting to a report server. This topic also provides information about «Unexpected error» messages. For more information about data source configuration and configuring report server connection information, see Specify Credential and Connection Information for Report Data Sources and Configure a Report Server Database Connection (Report Server Configuration Manager).

Cannot create a connection to data source ‘datasourcename’. (rsErrorOpeningConnection)

This is a generic error that occurs when the report server cannot open a connection to an external data source that provides data to a report. This error appears with a second error message that indicates the underlying cause. The following additional errors can appear with rsErrorOpeningConnection.

Login failed for user ‘UserName’

The user does not have permission to access the data source. If you are using a SQL Server database, verify that the user has a valid database user login. For more information about how to create a database user or a SQL Server login, see Create a Database User and Create a SQL Server Login.

Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’

This error occurs when credentials are passed across multiple computer connections. If you are using Windows Authentication, and the Kerberos version 5 protocol is not enabled, this error occurs when credentials are passed across more than one computer connection. To work around this error, consider using stored credentials or prompted credentials. For more information about how to work around this issue, see Specify Credential and Connection Information for Report Data Sources.

An error has occurred while establishing a connection to the server.

When connecting to SQL Server, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 — Could not open a connection to SQL Server). This error is returned by the instance of the Database Engine that hosts the report server database. In most cases, this error occurs because the SQL Server service is stopped. Or, if you are using SQL Server Express with Advanced Services or a named instance, this error will occur if the report server URL or connection string for the report server database is not correct. To work through these issues, do the following:

• Verify that the SQL Server (MSSQLSERVER) service is started. On the computer that hosts the instance of the Database Engine, click Start, click Administrative Tools, click Services, and scroll to SQL Server (MSSQLSERVER). If it is not started, right-click the service, select Properties, in Startup Type select Automatic, click Apply, click Start, and then click OK.
• Verify that the report server URL and report server database connection string is correct. If Reporting Services or the Database Engine was installed as a named instance, the default connection string that is created during Setup will include the instance name. For example, if you installed a default instance of SQL Server Express with Advanced Services on a server named DEVSRV01, the web portal URL is DEVSRV01\Reports$SQLEXPRESS. Furthermore, the database server name in the connection string will resemble DEVSRV01\SQLEXPRESS. For more information about URLs and data source connection strings for SQL Server Express, see Reporting Services in SQL Server Express with Advanced Services. To verify the connection string for the report server database, start the Reporting Services Configuration tool and view the Database Setup page.

A connection cannot be made. Ensure that the server is running.

This error is returned by ADOMD.NET provider. There are several reasons why this error can occur. If you specified the server as «localhost», try specifying the server name instead. This error can also occur if memory cannot be allocated to the new connection. For more information, see Knowledge Base Article 912017 — Error message when you connect to an instance of SQL Server 2005 Analysis Services:.

If the error also includes «No such host is known», it indicates that the Analysis Services server is not available or is refusing the connection. If the Analysis Services server is installed as a named instance on a remote computer, you might have to run the SQL Server Browser service to get the port number used by that instance.

(Report Services SOAP Proxy Source)

If you get this error during report model generation, and the additional information section includes «SQL Server does not exist or access denied», you might be encountering the following conditions:

• The connection string for the data source includes «localhost».
• TCP/IP is disabled for the SQL Server service.

To resolve this error, you can either modify the connection string to use the server name or you can enable TCP/IP for the service. Follow these steps to enable TCP/IP:

1. Start SQL Server Configuration Manager.
2. Expand SQL Server Network Configuration.
3. Select Protocols for MSSQLSERVER.
4. Right-click TCP/IP, and select Enable.
5. Select SQL Server Services.
6. Right-click SQL Server (MSSQLSERVER), and select Restart.

WMI error when connecting to a report server in Management Studio

By default, Management Studio uses the Reporting Services Windows Management Instrumentation (WMI) provider to establish a connection to the report server. If the WMI provider is not installed correctly, you will get the following error when attempting to connect to the report server:

Cannot connect to . The Reporting Services WMI provider is not installed or is misconfigured (Microsoft.SqlServer.Management.UI.RSClient).

To resolve this error, you should reinstall the software. For all other cases, as a temporary work-around, you can connect to the report server through the SOAP endpoint:

• In the Connect to Server dialog box in Management Studio, in Server Name, type the report server URL. By default, it is https:// /reportserver . Or if you are using SQL Server 2008 Express with Advanced Services, it is https:// /reportserver$sqlexpress .

To resolve the error so that you can connect using the WMI provider, you should run Setup to repair Reporting Services, or reinstall Reporting Services.

Connection error, where login failed due to unknown user name or bad password

An rsReportServerDatabaseLogonFailed error can occur if you are using a domain account for the connection from the report server to the report server database connection, and the password for the domain account has been changed.

The full error text is: «The report server cannot open a connection to the report server database. The logon failed (rsReportServerDatabaseLogonFailed). Logon failure: unknown user name or bad password.»

If you reset the password, you must update the connection. For more information, see Configure a Report Server Database Connection (Report Server Configuration Manager).

The report server cannot open a connection to the report server database. (rsReportServerDatabaseUnavailable).

Full Message: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable)
This error occurs when the report server cannot connect to the SQL Server relational database that provides internal storage to the server. The connection to the report server database is managed through the Reporting Services Configuration tool. You can run the tool, go to the Database Setup page, and correct the connection information. Using the tool to update connection information is a best practice; the tool ensures that dependent settings are updated and that services are restarted. For more information, see Configure a Report Server Database Connection and Configure the Report Server Service Account.

This error can also occur if the Database Engine instance that hosts the report server database is not configured for remote connections. Remote connection is enabled by default in some editions of SQL Server. To verify whether it is enabled on the SQL Server Database Engine instance you are using, run the SQL Server Configuration Manager tool. You must enable both TCP/IP and named pipes. A report server uses both protocols. For instructions on how to enable remote connections, see the section «How to Configure Remote Connections to the Report Server Database» in Configure a Report Server for Remote Administration.

If the error includes the following additional text, the password expired on the account used to run the Database Engine instance: «An error has occurred while establishing a connection to the server. When connecting to SQL Server, this failure may be caused by the fact that under the default settings SQL Server does not permit remote connections. (provider: SQL Server Network Interfaces, error: 26 — Error Locating Server/Instance Specified).» To resolve this error, reset the password.

«RPC Server is not listening»

The Report Server service uses Remote Procedure Call (RPC) server for some operations. If you get the «RPC Server is not listening» error, verify that the Report Server service is running.

Unexpected error (General network error)

This error indicates a data source connection error. You should check the connection string, and verify that you have permission to access the data source. If you are using Windows Authentication to access a data source, you must have permission to access the computer that hosts the data source.

Unable to grant database access in SharePoint Central Administration

When you have configured Reporting Services to integrate with a SharePoint product or technology on Windows Vista or Windows Server 2008, you might receive the following error message when you try to grant access on the Grant Database Access page in SharePoint Central Administration: «A connection to the computer cannot be established.»

This happens because User Account Control (UAC) in Windows Vista and Windows Server 2008 requires explicit acceptance from an administrator to elevate and use the administrator token when performing tasks that require administrator permissions. In this case, however, the Windows SharePoint Services Administration service cannot be elevated to grant the Reporting Services service account or accounts access to the SharePoint configuration and content databases.

In SQL Server 2008 Reporting Services, only the Report Server service account requires database access; in SQL Server 2005 Reporting Services SP2, both the Report Server Windows service account and the Report Server Web service account require database access. For more information about the Report Server service account in SQL Server 2008, see Service Account (Reporting Services Configuration).

There are two workarounds for this issue.

1. In one workaround, you can temporarily turn off UAC and use SharePoint Central Administration to grant access.

Use caution if you turn off UAC to work around this issue, and turn on UAC immediately after you grant database access in SharePoint Central Administration. If you do not want to turn off UAC, use the second workaround provided in this section. For information about UAC, see the Windows product documentation.
2. In the second workaround, you can manually grant database access to the Reporting Services service account or accounts. You can use the following procedure to grant access by adding the Reporting Services service account or accounts to the correct Windows group and database roles. This procedure applies to the Report Server service account in SQL Server 2008 Reporting Services; if you are running SQL Server 2005 Reporting Services, perform the procedure for the Report Server Windows service account and the Report Server Web service account.

To manually grant database access

1. Add the Report Server service account to the WSS_WPG Windows group on the Reporting Services computer.
2. Connect to the database instance that hosts the SharePoint configuration and content databases, and create a SQL database login for the Report Server service account.
3. Add the SQL database login to the following database roles:

• db_owner role in the WSS Content database
• WSS_Content_Application_Pools role in the SharePoint_Config database

Unable to connect to the /reports and /reportserver directories when the report server databases are created on a virtual SQL Server that runs in a Microsoft Cluster Services (MSCS) cluster

When you create the report server databases, ReportServer and ReportServerTempDB, on a virtual SQL Server that runs in a MSCS cluster, the remote name in the format \ $ might not be registered to SQL Server as a login. If you have configured the Report Server service account as an account that requires this remote name for connections, users cannot connect to the /reports and /reportserver directories in Reporting Services. For example, the built-in Windows account NetworkService requires this remote name. To avoid this issue, use an explicit domain account or a SQL Server login to connect to the report server databases.

See Also

Need help? Microsoft Q & A, Stackoverflow, SQL Server product feedback