locked
Unable to configure protection SQL Express 2014 RRS feed

  • Question

  • My DPM server is running DPM 2012 R2 Update Rollup 5. I am trying to configure protection for SQL Express 2014 on 2 protected servers but I cannot. I receive this error in DPM.

    Unable to configure protection.

    The DPM job failed for SQL Server 2012 database Server1\SQLEXPRESS\ReportServer$SQLEXPRESS on server1.this.org because the protection agent did not have sysadmin privileges on the SQL Server instance. (ID 33424 Details: )

    Add 'NT Service\DPMRA' to the sysadmin role on the SQL Server instance.

    I tried this which has worked on SQL server 2012 standard and enterprise editions but does not work on SQL 2014 Express editions.  http://scug.be/scdpm/2013/01/19/unable-to-configure-protection-with-sql-server-2012/

    SQL Server Management Studio > Security > Server Roles > Right click on sysadmin and choose Properties >>> Add “NT Authority\System”

    When I right click on sysadmin there is NO "properties" there is only "Start PowerShell", "Reports", and "Refresh"

    What do I need to do to be able to configure protection?

    Friday, May 22, 2015 3:34 PM

Answers

All replies