Support Tip: DPM admin console fails to open and generates error ID 948

~ Dwayne Jackson | Senior Support Escalation Engineer

imageHi everyone, Dwayne Jackson here with a quick tip in case you ever run into an issue where the console for System Center 2012 Data Protection Manager (DPM 2012 or DPM 2012 R2) fails to open. First, check to see if your symptoms match any of those listed below.

The first symptom is that you’ll see this error:

Unable to connect to DPM Server Name.Consoto.com (ID: 948)
Verify that the DPM service is running on this computer

You will also see an event logged similar to this one:

Log Name: Application
Source: MSDPM
Date: Date/Time
Event ID: 941
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: DPMServerName.Contoso.com
Description:
The description for Event ID 941 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 DPM database. Make sure that SQL Server is running and that it is configured correctly.
Problem Details:
<FatalServiceError><__System><ID>19</ID><Seq>1</Seq><TimeCreated>1/28/2015 3:22:57 PM</TimeCreated><Source>DpmThreadPool.cs</Source><Line>163</Line><HasError>True</HasError></__System><ExceptionType>SqlException</ExceptionType><ExceptionMessage>Cannot open database "DPMDBNAME" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\SYSTEM'.</ExceptionMessage><ExceptionDetails>System.Data.SqlClient.SqlException (0x80131904): Cannot open database " DPMDBNAME " requested by the login. The login failed.

Also, if you examine DPMUI0Curr.log you’ll see entries similar to the ones in my example below.

095C 0558 01/28 15:06:37.101 09 proxyutils.cpp(64) NORMAL CoreServicesProxy::CreateCoreServices
095C 0558 01/28 15:06:37.101 09 proxyutils.cpp(104) NORMAL CoreServicesProxy::CreateCoreServicesImpl(DPMServer.Contoso.com)
095C 0558 01/28 15:06:37.101 09 engineservicesproxy.cpp(550) NORMAL EngineServicesProxy::GetOSVersionOnDPMServer()
095C 0558 01/28 15:06:39.304 09 Catalog.cs(1822) WARNING No retry on exception System.Data.SqlClient.SqlException (0x80131904): Cannot open database "DPMDBNAME" requested by the login. The login failed.
095C 0558 01/28 15:06:39.304 09 Catalog.cs(1822) WARNING Login failed for user 'Domain\user attempting to login'.

095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING Login failed for user 'Domain\user attempting to login'.
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING at System.Data.SqlClient.SqlConnection.Open()
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING at Microsoft.Internal.EnterpriseStorage.Dls.DB.SqlContext.Open()
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING ClientConnectionId:df004fd3-c27c-4485-851a-9255a0777ad0
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING Error = 4060
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING Index #0
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING Source: .Net SqlClient Data Provider
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING Number: 4060
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING State: 1
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING Class: 11
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING Server: tcp: DPMSERVERNAME
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING Message: Cannot open database "DPMDBNAME" requested by the login. The login failed.
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING Procedure:
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING Line: 65536
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING Index #1
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING Source: .Net SqlClient Data Provider
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING Number: 18456
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING State: 1
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING Class: 14
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING Server: tcp:DPMSERVERNAME
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING Message: Login failed for user 'Domain\user attempting to login'.
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING Procedure:
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING Line: 65536 FileName:; Method:Open(); lineNo:0; ilOffset:14.
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING FileName:; Method:Open(); lineNo:0; ilOffset:14.
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING FileName:; Method:CreateAgentTypes(); lineNo:0; ilOffset:51.
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING FileName:; Method:.ctor(); lineNo:0; ilOffset:62.
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING FileName:; Method:Connect(); lineNo:0; ilOffset:147.
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING FileName:; Method:GetDpmServerObject(); lineNo:0; ilOffset:48.
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING FileName:; Method:GetServer(); lineNo:0; ilOffset:233.
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING FileName:; Method:ProcessRecord(); lineNo:0; ilOffset:61.
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING FileName:; Method:ProcessRecord(); lineNo:0; ilOffset:264.
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING FileName:; Method:DoExecute(); lineNo:0; ilOffset:35.
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING FileName:; Method:SynchronousExecuteEnumerate(); lineNo:0; ilOffset:78.
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING FileName:; Method:InvokeHelper(); lineNo:0; ilOffset:305.
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING FileName:; Method:InvokeThreadProc(); lineNo:0; ilOffset:217.
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING FileName:; Method:RunInternal(); lineNo:0; ilOffset:112.
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING FileName:; Method:Run(); lineNo:0; ilOffset:0.
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING FileName:; Method:Run(); lineNo:0; ilOffset:43.
095C 0558 01/28 15:06:39.319 09 Catalog.cs(1822) WARNING FileName:; Method:ThreadStart(); lineNo:0; ilOffset:26.
095C 0558 01/28 15:06:39.319 62 OMCatalog.cs(242) WARNING OMSqlContext :: Open() refreshing token
095C 0558 01/28 15:06:39.382 62 DpmServer.cs(802) WARNING Caught exception – System.InvalidOperationException: ExecuteReader requires an open and available Connection. The connection's current state is closed.
095C 0558 01/28 15:06:39.382 62 DpmServer.cs(802) WARNING at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
095C 0558 01/28 15:06:39.382 62 DpmServer.cs(802) WARNING at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
095C 0558 01/28 15:06:39.382 62 DpmServer.cs(802) WARNING at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
095C 0558 01/28 15:06:39.382 62 DpmServer.cs(802) WARNING at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
095C 0558 01/28 15:06:39.382 62 DpmServer.cs(802) WARNING at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
095C 0558 01/28 15:06:39.382 62 DpmServer.cs(802) WARNING at Microsoft.Internal.EnterpriseStorage.Dls.DB.SqlRetryCommand.InternalExecuteReader()
095C 0558 01/28 15:06:39.382 62 DpmServer.cs(802) WARNING at Microsoft.Internal.EnterpriseStorage.Dls.UI.ObjectModel.OMCommon.OMSqlRetryCommand.InternalExecuteReader()
095C 0558 01/28 15:06:39.382 62 DpmServer.cs(802) WARNING at Microsoft.Internal.EnterpriseStorage.Dls.UI.ObjectModel.AgentManagementDBReader.ReadAgentManagementAllAgentTypes(OMSqlContext context)
095C 0558 01/28 15:06:39.382 62 DpmServer.cs(802) WARNING at Microsoft.Internal.EnterpriseStorage.Dls.UI.ObjectModel.AgentManagement.AMFactory.CreateAgentTypes(ProductionServerController productionServerController)
095C 0558 01/28 15:06:39.382 62 DpmServer.cs(802) WARNING at Microsoft.Internal.EnterpriseStorage.Dls.UI.ObjectModel.AgentManagement.ProductionServerController..ctor(DpmServer dpmServer)
095C 0558 01/28 15:06:39.382 62 DpmServer.cs(802) WARNING at Microsoft.Internal.EnterpriseStorage.Dls.UI.ObjectModel.OMCommon.DpmServer.Connect(AsyncOperation asyncOperation)
095C 0558 01/28 15:06:39.382 62 CmdLetUtils.cs(56) WARNING DlsException 948:ConnectionToServerFailed
095C 0558 01/28 15:06:39.382 62 CmdLetUtils.cs(56) WARNING Microsoft.Internal.EnterpriseStorage.Dls.Utils.DlsException: exception —> System.InvalidOperationException: ExecuteReader requires an open and available Connection. The connection's current state is closed.
095C 0558 01/28 15:06:39.382 62 CmdLetUtils.cs(56) WARNING at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
095C 0558 01/28 15:06:39.382 62 CmdLetUtils.cs(56) WARNING at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
095C 0558 01/28 15:06:39.382 62 CmdLetUtils.cs(56) WARNING at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
095C 0558 01/28 15:06:39.382 62 CmdLetUtils.cs(56) WARNING at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
095C 0558 01/28 15:06:39.382 62 CmdLetUtils.cs(56) WARNING at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
095C 0558 01/28 15:06:39.382 62 CmdLetUtils.cs(56) WARNING at Microsoft.Internal.EnterpriseStorage.Dls.DB.SqlRetryCommand.InternalExecuteReader()
095C 0558 01/28 15:06:39.382 62 CmdLetUtils.cs(56) WARNING at Microsoft.Internal.EnterpriseStorage.Dls.UI.ObjectModel.OMCommon.OMSqlRetryCommand.InternalExecuteReader()
095C 0558 01/28 15:06:39.382 62 CmdLetUtils.cs(56) WARNING at Microsoft.Internal.EnterpriseStorage.Dls.UI.ObjectModel.AgentManagementDBReader.ReadAgentManagementAllAgentTypes(OMSqlContext context)
095C 0558 01/28 15:06:39.382 62 CmdLetUtils.cs(56) WARNING at Microsoft.Internal.EnterpriseStorage.Dls.UI.ObjectModel.AgentManagement.AMFactory.CreateAgentTypes(ProductionServerController productionServerController)
095C 0558 01/28 15:06:39.382 62 CmdLetUtils.cs(56) WARNING at Microsoft.Internal.EnterpriseStorage.Dls.UI.ObjectModel.AgentManagement.ProductionServerController..ctor(DpmServer dpmServer)
095C 0558 01/28 15:06:39.382 62 CmdLetUtils.cs(56) WARNING at Microsoft.Internal.EnterpriseStorage.Dls.UI.ObjectModel.OMCommon.DpmServ0808 0F74 01/28 15:09:31.849 34 ScopeHelper.cs(376) NORMAL Command line arguments: [C:\Windows\system32\mmc.exe] [C:\Program Files\Microsoft System Center 2012 R2\DPM\DPM\bin\Microsoft System Center 2012 R2 Data Protection Manager.msc]
./

If you encounter these symptoms then the most likely cause is that DPMDB is in SQL Server "Single User Mode".

To fix this, change the database to Multi User Mode by following the steps below.

1. From SQL Management Studio select the DPMDB
2. Right click the DPMDB select Properties
3. From Database properties select Options page
4. Scroll down to State for Restrict Access change from SINGLE_USER to MULTI_USER
5. Select OK

Once this is complete you should be able to open the console successfully.

Dwayne Jackson | Senior Support Escalation Engineer | Microsoft GBS Management and Security Division

Get the latest System Center news on Facebook and Twitter:

clip_image001 clip_image002

System Center All Up: http://blogs.technet.com/b/systemcenter/

Configuration Manager Support Team blog: http://blogs.technet.com/configurationmgr/ 
Data Protection Manager Team blog: http://blogs.technet.com/dpm/ 
Orchestrator Support Team blog: http://blogs.technet.com/b/orchestrator/ 
Operations Manager Team blog: http://blogs.technet.com/momteam/ 
Service Manager Team blog: http://blogs.technet.com/b/servicemanager 
Virtual Machine Manager Team blog: http://blogs.technet.com/scvmm

Microsoft Intune: http://blogs.technet.com/b/microsoftintune/
WSUS Support Team blog: http://blogs.technet.com/sus/
The RMS blog: http://blogs.technet.com/b/rms/
App-V Team blog: http://blogs.technet.com/appv/
MED-V Team blog: http://blogs.technet.com/medv/
Server App-V Team blog: http://blogs.technet.com/b/serverappv
The Surface Team blog: http://blogs.technet.com/b/surface/
The Application Proxy blog: http://blogs.technet.com/b/applicationproxyblog/

The Forefront Endpoint Protection blog : http://blogs.technet.com/b/clientsecurity/
The Forefront Identity Manager blog : http://blogs.msdn.com/b/ms-identity-support/
The Forefront TMG blog: http://blogs.technet.com/b/isablog/
The Forefront UAG blog: http://blogs.technet.com/b/edgeaccessblog/

DPM 2012 R2