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.
LVL 6
CaptainGibletsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

BOFH_JohnCommented:
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.
0
CaptainGibletsAuthor Commented:
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
0
BOFH_JohnCommented:
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.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

BOFH_JohnCommented:
Were you able to resolve this issue?
0
CaptainGibletsAuthor Commented:
We ended up creating a new DPM server and migrating across.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
CaptainGibletsAuthor Commented:
Closing question
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Data Protection Manager (DPM)

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.