Although my SQL 2012 DB AlwaysOn feature wasn't enabled the DPM job always fails immediately after it starts, Consistency check also didn't work as well. After some investigation and several trials it turns out that the NT AUTHORITY\SYSTEM account on the SQL server needs to have Sysadmin role/right
- Make sure the AlwaysOn feature is not enabled (Currently DPM 2012 RTM doesn't support it)
- Grant the SQL NT AUTHORITY\SYSTEM account SysAdmin Right.
- Remove the Protection group and add it again after applying the above changes.
0 comments:
Post a Comment