none
DPM 2010 database connection issue RRS feed

  • Question

  • Hi Guys,

    We have Data Protection Manager 2010 running on our Windows Server 2008 R2. Its database is pointing to a remote SQL Server 2008 SP1 instance which is a virtual machine.

    For some reasons, the connection to the database always fails when the scheduled tape backup runs every night. Below are the event log that we're getting everytime the scheduled tape backup fails.

    ____________________________________________________________________________________________

    The description for Event ID 940 from source MSDPM cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

    If the event originated on another computer, the display information had to be saved with the event.

    The following information was included with the event:

    Unable to connect to the database because of a fatal database error. It is unlikely that the database itself has been damaged. Review the event log and take appropriate action. Make sure that SQL Server is running.

    Problem Details:

    <FatalServiceError><__System><ID>19</ID><Seq>0</Seq><TimeCreated>6/07/2010 11:23:52 PM</TimeCreated><Source>DpmThreadPool.cs</Source><Line>163</Line><HasError>True</HasError></__System><ExceptionType>SqlException</ExceptionType><ExceptionMessage>A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)</ExceptionMessage><ExceptionDetails>System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

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

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

    at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)

    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.Internal.EnterpriseStorage.Dls.DB.SqlContext.Open()

    at Microsoft.Internal.EnterpriseStorage.Dls.Utils.GlobalSetting.GetGlobalProperty(String propertyName)

    at Microsoft.Internal.EnterpriseStorage.Dls.Utils.ApplicationSettings.GetDatabaseVersion()

    at Microsoft.Internal.EnterpriseStorage.Dls.Engine.CServiceModule.DoStartupValidation(CServiceModule* )

    at Microsoft.Internal.EnterpriseStorage.Dls.Engine.CServiceModule.Initialize(CServiceModule* )

    at Microsoft.Internal.EnterpriseStorage.Dls.Engine.CServiceModule.InitializeSecurity(CServiceModule* )</ExceptionDetails></FatalServiceError>

    the message resource is present but the message is not found in the string/message table

    _____________________________________________________________________________________________

     

    We've read the article "Troubleshooting Database Issues" from Microsoft's Technet Libary but it does not explain much about the error that we keep on receiving which is ERROR 940.

    Any Ideas on how to fix this? Thank you so much!

    Wednesday, July 7, 2010 1:10 AM

Answers

  • Hey,

    If I read it correctly, then the connection to the database fails.

    Do you have this event all the time or only during the scheduled tape backup at night?

    Do you have some maintenance on that SQL server during those times, or is it offlien for other reasons or so? 

    A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

    You need to look at this part in the error.

    Just my 2 cents

    Cheers

    Mike Resseler


    Visit System Center User Group Belgium @ http://scug.be and http://scug.be/blogs/scdpm
    Wednesday, July 7, 2010 6:32 AM
    Moderator

All replies

  • Hey,

    If I read it correctly, then the connection to the database fails.

    Do you have this event all the time or only during the scheduled tape backup at night?

    Do you have some maintenance on that SQL server during those times, or is it offlien for other reasons or so? 

    A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

    You need to look at this part in the error.

    Just my 2 cents

    Cheers

    Mike Resseler


    Visit System Center User Group Belgium @ http://scug.be and http://scug.be/blogs/scdpm
    Wednesday, July 7, 2010 6:32 AM
    Moderator
  • Can you please re-open if the above reply do not resolve the issue?
    Thanks, Praveen D [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.
    Tuesday, July 20, 2010 6:40 AM
  • Hey Mike,

    we also getting same issue ,only during the scheduled tape backup at night, can you please help on this.

    error
    The description for Event ID 940 from source MSDPM cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

    Sunday, September 27, 2015 8:17 AM