asked on

Microsoft System Center 2012 R2 Data Protection Manager Rollup 11 to 12

We currently have a DPM server with version 4.2.1553.0 installed. We are trying to install rollup 12 version 4.2.1589.0. When attempting the install, initially we had problems with services not stopping during install and it would return 'Microsoft System Center 2012 R2 Data Protection Manager Update - KB3209592'. It would then rollback however we seem to get round this by allowing permissions to the C:\Program Files\Microsoft System Center 2012 R2\DPM\DPM\agents\RA\4.2.1553.0. After adding these permissions the services could then be stopped and started successfully by the installation.

We have now hit another error during the install when the install is on the stage 'executing sql strings', when reviewing the log file the following error appears

MSI (s) (44:D4) [10:01:12:505]: Executing op: ActionStart(Name=ExecuteSqlStrings,Description=Executing SQL Strings,)
MSI (s) (44:D4) [10:01:12:573]: Executing op: CustomActionSchedule(Action=ExecuteSqlStrings,ActionType=25601,Source=BinaryData,Target=**********,CustomActionData=**********)
MSI (s) (44:B0) [10:01:12:575]: Invoking remote custom action. DLL: C:\Windows\Installer\MSIFAE4.tmp, Entrypoint: ExecuteSqlStrings
MSI (s) (44!28) [10:01:29:150]: Transforming table Error.

MSI (s) (44!28) [10:01:29:150]: Transforming table Error.

MSI (s) (44!28) [10:01:29:150]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (44!28) [10:01:29:150]: Transforming table Error.

MSI (s) (44!28) [10:01:29:151]: Transforming table Error.

MSI (s) (44!28) [10:01:29:151]: Note: 1: 2262 2: Error 3: -2147287038
ExecuteSqlStrings: Error 0x80004005: failed to connect to database: '*****DPM DB NAME*****'
MSI (s) (44!28) [10:01:29:151]: Transforming table Error.

MSI (s) (44!28) [10:01:29:152]: Transforming table Error.

MSI (s) (44!28) [10:01:29:152]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (44!28) [10:01:29:152]: Transforming table Error.

MSI (s) (44!28) [10:01:29:153]: Transforming table Error.

MSI (s) (44!28) [10:01:29:153]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (44!28) [10:01:29:153]: Product: Microsoft System Center 2012 R2 Data Protection Manager -- Error 26203. Failed to connect to SQL database. (-2147467259 *****DPM DB NAME***** )

CustomAction ExecuteSqlStrings returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox)

The log file continues to say that it is removing any copied files and rolling back the setup.

We are not sure why it is unable to connect to the SQL database, we have ensured permissions are set for access to the SQL DB.

Any help much appreciated.

BOFH_John

I ran into something similar executing an MSI install from c:\. Are you installing from a security restricted folder? try running the install from desktop.

CaptainGiblets

ASKER

Yes we have tried running from C:\ and other areas such as the desktop. We also tried extracting the update file and running from an msp file and the same error appears but in an actual error windows rather than just in the log. Also tried without UAC. It must be an access issue somewhere but we have checked everywhere we can think of.
Captu11111re.PNG

BOFH_John

If DPM works it shouldn't be an actual DB permissions issue. Try running Process Monitor and watch the installer for file access attempts.
Process Monitor can be found here: https://docs.microsoft.com/en-us/sysinternals/downloads/procmon.

BOFH_John

Were you able to resolve this issue?

ASKER CERTIFIED SOLUTION

CaptainGiblets

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

CaptainGiblets

ASKER

Closing question