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.

New guide set: Microsoft IaaS Product Line Architecture Guides

 

Microsoft have informed us (MVP mail distribution) and also published two excellent guides about  their Infrastructure as a Service (Iaas) Product Line Architecture (PLA). The first guide is mostly based on Windows Server 2012 storage and virtualization and the second guide is based around System Center 2012. both document will provide you good idea about Microsoft approach. In future they expect to provide more documents like this and also expecting feedback from you.

  • Infrastructure-as-a-Service Product Line Architecture Fabric Architecture Guide (Windows Server 2012)

http://www.microsoft.com/en-us/download/details.aspx?id=38817

  • Infrastructure-as-a-Service Product Line Architecture Fabric Management Architecture Guide (System Center 2012)

http://www.microsoft.com/en-us/download/details.aspx?id=38813

Enjoy the reading during your weekend break Smile

System Center Advisor

I’m not very sure if I’ve talk about this sometime back but with the latest updates they have caried out to the product I wanted to bring this software back to your attention. System Center Advisor is a “Free” (Yes now it is free folks Smile ) cloud service that enables IT pros to proactively avoid problems from server configuration issues. Apart from that for the customer who deploy System Center Advisor get the ability to retrieve reports about the servers current status and also historical configuration data about the servers. Microsoft pools their knowledgebase about the best practices and compare it against your servers to advise you in case if you have misconfigured the servers.

advisoroverview

The above picture gives clear idea about the functionality. Steps require for System Center Advisor setup are as follows,

1. Go to www.systemcenteradvisor.com and register yourself and create an account.

2. Downlaod the agent software and unique certificate.

3. Select a machine as a gateway to connect with Microsoft cloud service an send and receive server related information behalf of the machines in the DMZ zones.

4. Install the agent to all the servers you want to monitor and mention the gateway server name during the setup.

Simple as that you get the System Center Advisor to startup and do it’s magic Smile. Below is a screenshot of my System Center Advisor portal,

image

Recently Microsoft announced System Center Advisor can be linked with System Center Operations Manger as well. what this means is if you have in house SCOM deployed you have a way of getting System Center Advisor ongoing assessment of configuration information to the SCOM console. To get this working you need to have SCOM 2012 SP1 with Update Rollup2 installed in your environment. You can download the connector from here.

Note: System Center Advisor overview picture retrieved from TechNet page.

ITPro session for April month 2013

This month I’ve been discussing about the trend of hybrid hyper-visor movement by customers and why they tend do that. Apart from that we’re now in the next level of virtualization where most organization who adopt virtualization trying to find feasible solutions to manage their environment.

During that discussion one key thing being highlight was ‘What are the key characteristics of Private Cloud” This is very important since most of the customer has the assumption as soon as they have a hypervisor and console to manage it means Private Cloud.

Then we focus on what is really the total management solutions should be like and how System Center 2012 come into the picture to fill the gap. The most interesting part is most VMware guys in the room didn’t know the capability and how strong is “HYPER-V Replica” we had a good time discussion about the feature compare with VMware offered paid solutions Smile

Some of the moments captured during the session.