none
DPM 2012 R2 on Clustered SQL 2012 SP1 gives 832 Setup cannot grant the MyDomain.com\DomainAdministrator account access to the DPM database. RRS feed

  • Question

  •  Im trying to troubleshoot this issue, Im not doing anything stupid like trying to install on a domain controller they are all 2012 r2 member servers. Both sql instances have the dpmsql account added as administrator and the account added in lusrmgr.msc

    Ive given up on using a regular domain account to connect to the sql servers and created a domain admin account (enterprise admin, domain admin, schema admin etc)  but im still getting this issue.

    Ive deleted the database each time. Can anyone suggest how to troubleshoot this ? 

    [12/31/2013 8:07 PM] Information : Start configuration.
    [12/31/2013 8:07 PM] Information : Starting Service:MSSQL$SCDPM on machine:DPMSQL.MyDomain.com flag restart:False
    [12/31/2013 8:07 PM] Information : Starting Service:SQLAgent$SCDPM on machine:DPMSQL.MyDomain.com flag restart:False
    [12/31/2013 8:09 PM] Information : Inspect.CheckSqlServerTools : MsiQueryProductState returned : INSTALLSTATE_DEFAULT
    [12/31/2013 8:09 PM] Data : dbScriptsPath = C:\Program Files\Microsoft System Center 2012 R2\DPM\DPM\Setup\DB
    [12/31/2013 8:09 PM] Data : sqlcmdPath = "C:\Program Files\Microsoft SQL Server\110\Tools\Binn\SQLCMD.EXE"
    [12/31/2013 8:09 PM] Data : instanceName = DPMSQL.MyDomain.com\SCDPM
    [12/31/2013 8:09 PM] Information : Deleting schedules
    [12/31/2013 8:09 PM] * Exception :  => System.Data.SqlClient.SqlException (0x80131904): The specified @category_name ('DPM_08c3b6dd-58a1-4ffd-b06e-20f3184f93c3') does not exist.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
       at System.Data.SqlClient.SqlDataReader.get_MetaData()
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
       at Microsoft.Internal.EnterpriseStorage.Dls.DB.SqlRetryCommand.InternalExecuteReader()
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Configuration.DBConfigurator.DeleteSchedules(Boolean needImpersonation, String categoryName)
    ClientConnectionId:aa5543af-1c13-4ea0-b003-50d99a627269
    [12/31/2013 8:09 PM] Information : Creating database
    [12/31/2013 8:10 PM] Information : Executing query to create database
    [12/31/2013 8:10 PM] Data : Database creation query = CREATE DATABASE DPMDB_SCDPM
                                ON
                                (
                                    NAME=MSDPM2012$DPMDB_SCDPM_dat,
                                    FILENAME='G:\MSSQL11.SCDPM\MSSQL\DATA\MSDPM2012$DPMDB_SCDPM.mdf',
                                    SIZE=400MB
                                )
                                LOG ON
                                (
                                    NAME=MSDPM2012$DPMDB_SCDPMLog_dat,
                                    FILENAME='G:\MSSQL11.SCDPM\MSSQL\DATA\MSDPM2012$DPMDB_SCDPM_log.ldf',
                                    SIZE=500MB
                                );
    [12/31/2013 8:10 PM] Information : Creating the required roles
    [12/31/2013 8:10 PM] * Exception : Ignoring the following exception intentionally => System.Data.SqlClient.SqlException (0x80131904): Cannot drop the role 'MSDPMExecRole', because it does not exist or you do not have permission.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at Microsoft.Internal.EnterpriseStorage.Dls.DB.SqlRetryCommand.ExecuteNonQuery()
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Configuration.DBConfigurator.CreateRole(SqlContext ctx, String roleName)
    ClientConnectionId:bb26cb02-879e-49ba-8f43-9edc59f4d8c2
    [12/31/2013 8:10 PM] Information : MSDPMExec role created
    [12/31/2013 8:10 PM] * Exception : Ignoring the following exception intentionally => System.Data.SqlClient.SqlException (0x80131904): Cannot drop the role 'MSDPMReaderRole', because it does not exist or you do not have permission.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at Microsoft.Internal.EnterpriseStorage.Dls.DB.SqlRetryCommand.ExecuteNonQuery()
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Configuration.DBConfigurator.CreateRole(SqlContext ctx, String roleName)
    ClientConnectionId:bb26cb02-879e-49ba-8f43-9edc59f4d8c2
    [12/31/2013 8:10 PM] Information : MSDPMReader role created
    [12/31/2013 8:10 PM] * Exception : Ignoring the following exception intentionally => System.Data.SqlClient.SqlException (0x80131904): Cannot drop the role 'MSDPMRecoveryRole', because it does not exist or you do not have permission.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at Microsoft.Internal.EnterpriseStorage.Dls.DB.SqlRetryCommand.ExecuteNonQuery()
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Configuration.DBConfigurator.CreateRole(SqlContext ctx, String roleName)
    ClientConnectionId:bb26cb02-879e-49ba-8f43-9edc59f4d8c2
    [12/31/2013 8:10 PM] Information : MSDPMRecovery role created
    [12/31/2013 8:10 PM] Information : Changing temp table names
    [12/31/2013 8:10 PM] Information : Creating tables
    [12/31/2013 8:10 PM] Information : Execute the SQL script
    [12/31/2013 8:10 PM] Data : FileName = "C:\Program Files\Microsoft SQL Server\110\Tools\Binn\SQLCMD.EXE"
    [12/31/2013 8:10 PM] Data : Arguments = -b -E -d DPMDB_SCDPM -i master.sql -r -S DPMSQL.MyDomain.com\SCDPM
    [12/31/2013 8:11 PM] Data : Error code = 0
    [12/31/2013 8:11 PM] Information : Inspect.CheckSqlServerTools : MsiQueryProductState returned : INSTALLSTATE_DEFAULT
    [12/31/2013 8:11 PM] Data : dbScriptsPath = C:\Program Files\Microsoft System Center 2012 R2\DPM\DPM\Setup\DB
    [12/31/2013 8:11 PM] Data : sqlcmdPath = "C:\Program Files\Microsoft SQL Server\110\Tools\Binn\SQLCMD.EXE"
    [12/31/2013 8:11 PM] Data : instanceName = DPMSQL.MyDomain.com\SCDPM
    [12/31/2013 8:11 PM] Information : Populate database with error strings
    [12/31/2013 8:12 PM] Information : Register verbs
    [12/31/2013 8:12 PM] Information : Set the InventoryHouseKeepingJobStartTime entry to 12/31/2013 09:00:00
    [12/31/2013 8:12 PM] Information : Set the value of libraryInventory needed to True
    [12/31/2013 8:12 PM] Information : Set the value of IsPruningNeeded in the DB
    [12/31/2013 8:12 PM] Information : **************************************************************************************
    [12/31/2013 8:12 PM] Information : Start configuration.
    [12/31/2013 8:12 PM] Information : Starting Service:MSSQL$SCDPM on machine:DPMSQL.MyDomain.com flag restart:False
    [12/31/2013 8:12 PM] Information : Starting Service:SQLAgent$SCDPM on machine:DPMSQL.MyDomain.com flag restart:False
    [12/31/2013 8:12 PM] Information : Starting Service:ReportServer on machine:SQL1.MyDomain.com flag restart:False
    [12/31/2013 8:12 PM] Information : Create a registry containing sql agent account information
    [12/31/2013 8:12 PM] Information : Querying WMI Namespace: \\SQL4\root\cimv2 for query: SELECT * FROM Win32_Service WHERE Name='SQLAgent$SCDPM'
    [12/31/2013 8:12 PM] Information : Querying WMI Namespace: \\SQL1\root\cimv2 for query: SELECT * FROM Win32_Service WHERE Name='SQLAgent$SCDPM'
    [12/31/2013 8:12 PM] Information : Querying WMI Namespace: \\SQL3\root\cimv2 for query: SELECT * FROM Win32_Service WHERE Name='SQLAgent$SCDPM'
    [12/31/2013 8:12 PM] Information : Querying WMI Namespace: \\SQL2\root\cimv2 for query: SELECT * FROM Win32_Service WHERE Name='SQLAgent$SCDPM'
    [12/31/2013 8:12 PM] Information : Sql Agent account name = MYDOMAIN\SQL
    [12/31/2013 8:12 PM] Information : Create a registry containing the trigger job path information
    [12/31/2013 8:12 PM] Data : TriggerJobPath = c:\Program Files\Microsoft Data Protection Manager\DPM2012R2\SQLPrep
    [12/31/2013 8:12 PM] Information : Add user: MYDOMAIN\SQL to local group: Distributed COM Users on server: SCDPM
    [12/31/2013 8:12 PM] Information : Give user: MYDOMAIN\SQL read and execute permissions on file: C:\Program Files\Microsoft System Center 2012 R2\DPM\DPM\bin\msdpm.exe
    [12/31/2013 8:12 PM] Information : Creating group DPMDBAdministrators on remote SQL Server machine SQL1.MyDomain.com
    [12/31/2013 8:12 PM] Information : Adding local group MSDPMTrustedUsers on server SCDPM
    [12/31/2013 8:12 PM] Information : Deleting local group MSDPMTrustedUsers on server SCDPM
    [12/31/2013 8:12 PM] * Exception : Ignoring the following exception intentionally => An error occurred while trying to configure DPM.Uninstall DPM by using Add or Remove Programs in Control Panel, and then run DPM Setup again.Microsoft.Internal.EnterpriseStorage.Dls.Setup.Exceptions.BackEndErrorException: Exception of type 'Microsoft.Internal.EnterpriseStorage.Dls.Setup.Exceptions.BackEndErrorException' was thrown.
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.SecurityConfigurationHandler.DeleteLocalGroup(String serverName, String localGroupName)
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.SecurityConfigurationHandler.AddLocalGroup(String serverName, String localGroupName)
    *** Mojito error was: DpmSetupConfigurationError; 2220; WindowsAPI
    [12/31/2013 8:12 PM] Information : Adding local group DPMSCOM on server SCDPM
    [12/31/2013 8:12 PM] Information : Deleting local group DPMSCOM on server SCDPM
    [12/31/2013 8:12 PM] * Exception : Ignoring the following exception intentionally => An error occurred while trying to configure DPM.Uninstall DPM by using Add or Remove Programs in Control Panel, and then run DPM Setup again.Microsoft.Internal.EnterpriseStorage.Dls.Setup.Exceptions.BackEndErrorException: Exception of type 'Microsoft.Internal.EnterpriseStorage.Dls.Setup.Exceptions.BackEndErrorException' was thrown.
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.SecurityConfigurationHandler.DeleteLocalGroup(String serverName, String localGroupName)
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.SecurityConfigurationHandler.AddLocalGroup(String serverName, String localGroupName)
    *** Mojito error was: DpmSetupConfigurationError; 2220; WindowsAPI
    [12/31/2013 8:12 PM] Information : Inspect.CheckSqlServerTools : MsiQueryProductState returned : INSTALLSTATE_DEFAULT
    [12/31/2013 8:12 PM] Data : dbScriptsPath = C:\Program Files\Microsoft System Center 2012 R2\DPM\DPM\Setup\DB
    [12/31/2013 8:12 PM] Data : sqlcmdPath = "C:\Program Files\Microsoft SQL Server\110\Tools\Binn\SQLCMD.EXE"
    [12/31/2013 8:12 PM] Data : instanceName = DPMSQL.MyDomain.com\SCDPM
    [12/31/2013 8:12 PM] Information : Grant permissions on database
    [12/31/2013 8:12 PM] Data : Database connection string = Integrated Security=SSPI;server=DPMSQL.MyDomain.com\SCDPM;Pooling=false;database=DPMDB_SCDPM;Pooling=false
    [12/31/2013 8:12 PM] Data : Account name = LoginName: MyDomain.com\DomainAdministrator MakeDBAdmin: False
    [12/31/2013 8:12 PM] *** Error : SqlException in CreateSqlLoginAndGrantDBAccess
    [12/31/2013 8:12 PM] * Exception :  => System.Data.SqlClient.SqlException (0x80131904): Windows NT user or group 'MyDomain.com\DomainAdministrator' not found. Check the name again.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at Microsoft.Internal.EnterpriseStorage.Dls.DB.SqlRetryCommand.ExecuteNonQuery()
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Helpers.SetupDatabaseHelper.CreateSqlLogin(SqlContext ctx, String loginName)
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Helpers.SetupDatabaseHelper.CreateSqlLoginAndGrantDBAccess(SqlContext sqlContext, String loginName, String nameInDatabase, Boolean revokeFirst)
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Configuration.DBConfigurator.CreateSqlLoginAndGrantDBAccess(SqlContext ctx, String loginName, Boolean makeDBAdmin)
    ClientConnectionId:a7421d21-837c-493d-a115-467f9fc28be3
    [12/31/2013 8:12 PM] * Exception :  => Setup cannot grant the MyDomain.com\DomainAdministrator account access to the DPM database.Verify that SQL Server is properly installed and that it is running.Microsoft.Internal.EnterpriseStorage.Dls.Setup.Exceptions.BackEndErrorException: exception ---> Microsoft.Internal.EnterpriseStorage.Dls.Setup.Exceptions.DatabaseConfigurationException: exception ---> System.Data.SqlClient.SqlException: Windows NT user or group 'MyDomain.com\DomainAdministrator' not found. Check the name again.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at Microsoft.Internal.EnterpriseStorage.Dls.DB.SqlRetryCommand.ExecuteNonQuery()
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Helpers.SetupDatabaseHelper.CreateSqlLogin(SqlContext ctx, String loginName)
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Helpers.SetupDatabaseHelper.CreateSqlLoginAndGrantDBAccess(SqlContext sqlContext, String loginName, String nameInDatabase, Boolean revokeFirst)
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Configuration.DBConfigurator.CreateSqlLoginAndGrantDBAccess(SqlContext ctx, String loginName, Boolean makeDBAdmin)
       --- End of inner exception stack trace ---
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Configuration.DBConfigurator.CreateSqlLoginAndGrantDBAccess(SqlContext ctx, String loginName, Boolean makeDBAdmin)
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Configuration.DBConfigurator.GrantLocalUserPermissionsToDatabase(Boolean isRemoteDb, String sqlServerMachineName)
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.MiniSetupConfiguration.PopulateDB(Boolean upgrading, Boolean isRemoteDb, String sqlServerMachineName)
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.BackEnd.MachineSpecificConfiguration(Boolean existingDB, Boolean upgrading, Boolean isRemoteDb, String sqlServerMachineName, String sqlInstanceName, Boolean isRemoteReporting, String reportingMachineName, String reportingInstanceName)
       --- End of inner exception stack trace ---
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.BackEnd.MachineSpecificConfiguration(Boolean existingDB, Boolean upgrading, Boolean isRemoteDb, String sqlServerMachineName, String sqlInstanceName, Boolean isRemoteReporting, String reportingMachineName, String reportingInstanceName)
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.BackEnd.Configure(Boolean existingDB, Boolean upgrading, String databaseLocation, String sqlServerMachineName, String sqlInstanceName, String reportingMachineName, String reportingInstanceName, Boolean oemSetup)
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.DpmInstaller.Configure()
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.ProgressPage.InstallDpm()
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.ProgressPage.InstallerThreadEntry()
    *** Mojito error was: GrantDatabaseAccessFailed; 0; None
    [12/31/2013 8:12 PM] *** Error : Setup cannot grant the MyDomain.com\DomainAdministrator account access to the DPM database.

    Verify that SQL Server is properly installed and that it is running.

    ID: 832
    [12/31/2013 8:12 PM] Information : Data Protection Manager installation has failed. To return the server to its original state, you must uninstall Data Protection Manager by using Add or Remove Programs in Control Panel. This will remove all files and components copied during installation.
    For details, click the Error tab.
    [12/31/2013 8:12 PM] Data : Error Code Web Link = http://go.microsoft.com/fwlink/events.asp?ProdName=Microsoft System Center Data Protection Manager&ProdVer=4.2.1205.0&EvtID=832&EvtSrc=MSDPM&LCID=1033&P2wAppId=p2wMsdpmEE


    Wednesday, January 1, 2014 11:58 AM

All replies

  • Same issue; though i'm not using clustered SQL, 

    SQL server 2012 R2 (stand alone, single instance SQL server)

    Server 2012 R2 /w DPM 2012 

    Friday, January 3, 2014 2:47 PM
  • [1/4/2014 2:39 PM] Data : instanceName = DPMSQL.MyDomain.com\SCDPM [1/4/2014 2:39 PM] Information : Grant permissions on database [1/4/2014 2:39 PM] Data : Database connection string = Integrated Security=SSPI;server=DPMSQL.MyDomain.com\SCDPM;Pooling=false;database=DPMDB_SCDPM;Pooling=false [1/4/2014 2:39 PM] Data: Account name = LoginName: MyDomain.com\DPMSQL MakeDBAdmin: False [1/4/2014 2:39 PM] *** Error : SqlException in CreateSqlLoginAndGrantDBAccess [1/4/2014 2:39 PM] * Exception : => System.Data.SqlClient.SqlException (0x80131904): Windows NT user or group 'MyDomain.com\DPMSQL' not found. Check the name again.

    Reformat of the dpm server did nothing to remedy this, Im still getting "Windows NT user or group 'MyDomain.com\DPMSQL' not found"

    This account does exsist and id did add it to the administrators group and domain administrators group but still no luck

    Saturday, January 4, 2014 4:50 PM
  • Hello,

    I was also having the same issue on SQL Server 2012 with SP1, stand alone, single instance SQL. I did finally manage to install it.

    In the part where DPM asks for a domain user that has sysadmin rights on the SQL server, do not enter your domain name in the format of 'Mydomain.com' instead just use 'Mydomain'

    This is what I think made it work for me. Pretty silly, but seems to make it work!

    However, there is also the following requirement about port 80 required to be open on the SQL server, which I applied at the same time as using the above format for the domain, so not 100% sure if this is also a cause

    http://technet.microsoft.com/en-us/library/jj852163.aspx

    "For the DPM server to access a remote instance of SQL Server through Windows Firewall, on the remote computer, you must configure an incoming exception for sqlservr.exe for the specific instance that you use for the DPM database to allow use of the TCP protocol on port 80."


    • Proposed as answer by Zaid Tuesday, January 7, 2014 2:08 PM
    • Edited by Zaid Tuesday, January 7, 2014 2:09 PM
    Tuesday, January 7, 2014 2:08 PM
  • Worked for me too.
    Monday, October 13, 2014 9:17 PM
  • This worked for me too! Thank you Zaid!
    Thursday, May 12, 2016 3:54 PM