Error upgrading DPM 2010 to DPM 2012

I ran into a problem regarding upgrading from DPM 2010 to DPM 2012 the other day. When performing the upgrade I got the error 832 that would like me to verify that the SQL server was properly installed and running.

 

During the upgrade from DPM 2010 to DPM 2012, SQL takes two inputs for adding some permissions to the DPM database. If the error occur then the account DPMDBReader have the wrong syntax. On the faulty upgraded server the syntax of the account is ’\DPMDBReader$’ it should be ‘DPMDBReader$’

To resolve this error and be able to perform your upgrade you must delete the schema named DPMDBReader$ in the original DPM 2010 SQL database and then perform the upgrade again.

To delete the schema open the SQL management studio on the DPM 2010 server do this:

1. Open the SQL Management Studio and connect to the DPM instance
2. Go to DPMDB
3. Security
4. Schema
5. Delete the DPMDBReader$Machinename schema.