DPM 2012 fails to backup SQL 2012 database

I was planning to protect remote SQL 2012 server from DPM 2012 server and encountered the below mention error,

SQL error

The suggestion is to add “‘NT Service\DPMRA\ to the sysadmin role on the SQL Server instance.” The problem is I don’t have an ‘NT Service\DPMRA’ user in Windows or SQL on that remote SQL server when tried to add. To make the story short all you have to do is in the remote SQL server do as follows,

  1. In SQL Management Studio, connect to the SQL 2012 Server and then expand Security.
  2. Expand Logins and right click on NT AUTHORITY\SYSTEM and select Properties.
  3. Click Server Roles, check sysadmin and click OK.

SQLconsole 

 

After that run the consistency checkups on the DPM side and you’ll see the problem resolved 🙂

Edit: I found another article stating the same issue with different resolution approach.

Advertisements

Availability of System Center 2012 Configuration Manager SP1 Beta

For the past few month there has been various updates on the System Center 2012 suite. On September 09th Microsoft released the “Beta” version of the SP1 which is include very important updates and enhancement. Out of that personally I’m happy to see the official support on Windows 2012 and Windows 8 Smile

Moving forward some of the significant enhancement are as follows,

  • Support to run management servers on Windows Server 2012 and support for Windows Server 2012 as a client
  • Support for Windows 8
  • Support for SQL Server 2012 as the database server for System Center 2012 SP1
  • Support for management of Windows Azure IaaS
  • Support for Linux/UNIX and Mac OS X clients with Configuration Manager
  • Full support for Windows Server 2012 Hyper-V features such as Network Virtualization and SMB shares
  • Integration of Configuration Manager and Windows Intune for mobile device management, which includes Windows RT and Windows Phone 8
  • Windows Intune Licensing Changes
  • Interoperability of Windows Intune and System Center Configuration Manager Console

You can download the updates from here.