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.

Ethernet Resource Pool in Hyper-V

Resource pooling concept on HYPE-V becomes essential day by day to virtualization data center administrators. I’ve discuss about storage pooling sometime back. You can refer that here. Now we’re in the Server 2012 R2 HYPER-V stage and the concept stays the same.

Now let’s take a scenario before I enter to the technical write-up part.
Let’s assume you’ve two different HYPER-V host servers (HOST1 & HOST2), each having virtual switch which connects the VM’s to the external network. Host HOST1 having external VM switch name as “External-SW-A” & HOST2 having switch name as “External-SW-B”. Assuming you export or live migrate a VM from HostA to HostB you’ll have a technical issue saying VM cannot find the network switch.

Simple reason behind is due to the different switches names on each host. This can be more complex when we’re talking about more HYPER-V hosts having different switches names.

To avoid this problem HYPER-V team introduce to the resource pool concept. Before that I want to show there are no resource pools created on the HYPER-V host,
image

We’ll create switch name as “EthResourcePool1” now unfortunately we don’t have a GUI method so our old friend PS will come to the picture. Try following PS command,

New-VMResoucePool –Name EthResourcePool1 –ResourcePoolType Ethernet
image

Once that completed on each HYPER-V host computer you can add their existing switches to the pool by typing below PS command,

Before that current status of the HOST1 computers network switch settings,
image

HOST1-
Add-VMSwitch –Name External-SW-A –ResourcePoolName EthResourcePool1
image

HOST2
Add-VMSwitch –Name External-SW-B –ResourcePoolName EthResourcePool1

image

Now let’s go to HOST1 and check on one of the VM properties,

image

So what this means is if you live migrate this VM to different HYPER-V host which is part of the Ethernet resource pool there will be no issues to the VM to connect to the relevant network 🙂
If you’re more interested in this feature you can find more parameters and technical information here.

Creating a load balanced, highly available IIS web farm on Windows Azure

Without much intro let me get started straight with this article. Today I’m going to show you how you can create highly available IIS web farm in Windows Azure environment. Let me highlight that in a picture for easy understanding,


Source for this picture can be found here

As you can see in the above picture we get all the HTTP (port 80) traffic routed through the Azure Load balance to the VM’s hosted in the Azure Cloud Service. In case of single or multiple IIS VM’s failure on the target cloud service traffic will be routed to a available VM on the Cloud service.

Before starting this let me clearly state there are several ways you can approach to complete these tasks so what I describe here might be changed in future or might not be the best method for you 🙂

Let’s start now. First go to the Azure portal and create a new Cloud Service. Cloud service can be considered as a container for the hosted VM’s. If you need more information about that please refer this link.

 image

Once you click “Create Cloud Service” it will take few seconds to create the Cloud service container. After that we need to create two VM’s. For this we’ll go ahead and select VM template from the gallery.

image

For this demo I’ve selected latest and the greatest OS in the planet “Windows Server 2012 R2” 🙂
image

Next screen provide a unique name to the VM and username and password,

image

In the next page is important to select the pre-created Cloud service container and also create new availability set. In availability set option Azure will make sure two VM’s will be placed on two different fault domains. In simple English that means two VM’s will be on two different host computers in two different racks. This is to avoid single point of failure.

1

 image

In the next page you’ve to select which ports will be open to the outside world to access. In my case I want to host a IIS web site in secure manner so I plan to open port 443 (HTTPS) for that click the “Enter or Select Value” column and select HTTPS

image

image

After that complete the steps to create the first VM. In the second VM’s setup you’ll select the pre created Cloud service name and the Availability Set from the drop down menus.

Ok so far you’ll with me? Cool let’s move to the next step. Remember in the first VM creation part for the endpoints we open port 443 (HTTPs) to the outside world? Well we did that only to the first VM but in case if that VM is down second VM will not be able to respond since we have not open the port 443 in that server. Apart from that we didn’t create  a load balancer for the two VMs. So in order to complete that task we’ll go to the azure portal —> Virtual machine’s —> click the first VM name. After that click Endpoints section,

image

Highlight the HTTPS and then select “Edit” on bottom of the screen,

image

Notice that HTTPS is not having a Load-Balanceded Set yet i the upper right hand corner? Once you’re in the second page tick “Create a Load Balance Set” Option.

image

In the next page you can give a name to the Load Balance Set. I’ve put a name as “LB1”. Rest settings I don’t think you’ll need to change unless you have a good reason to do so. Click the correct sign to complete the task.

image

ok when that task is complete it’s time to move to the next virtual machine and configure the endpoints section by adding the port 443 🙂

image

Once you click add in the next screen you’ve to select the second option and from the drop down menu need to select the Load Balance Set we’ve created previously.

image

next screen provide a name to the Load Balance set and avoid any other changes and complete the task. This will take few seconds.

image

Once the above task is completed you’ve successfully completed load balancing two VM’s for IIS traffic. Now if you ask me how to test that then steps are as follows (at least this is how I test that)

1. Log into each VM (RDP) and then install IIS service. To make this step much quicker I used the PS command as follows,
Install-WindowsFeature Web-Server -IncludeManagementTools –IncludeAllSubFeature

2. Go to the wwwroot of each VM and open the default IIS graphic file from mspaint and provide each VM unique name. (Eg: VM1 I’ll modify that picture by entering the name VM1…etc)

3. Go to the IIS console on both VM’s and bind 443 to the default web site.

4. Now find the public VIP or the DNS name and type that on your machine’s browser. You should be able to see a default IIS web page. Observe from which VM name appear on that page. Go to Azure portal and shutdown that VM and refresh your web page. After little while you’ll see second VM’s IIS default web page will load. And that is your main proof to identify IIS load balance work perfectly.

VMware-To-Hyper-V V2V Conversion Tool Gets better with 5NINE (V 2.0)

Sometimes back I mention about 5NINE company released a tool to convert VMware VM’s to HYPER-V. If you missed that you can have a look at that here. Now they’re back with V2.0 and all this for FREE 🙂

V 2.0 supports converting following VM’s from VMware to HYPER-V,

  • Server 2008
  • Windows 7
  • Server 2003 (x86 & x64)
  • Advanced Server 2000
  • Ubuntu
  • CentOS

As you can see in the above list Linux conversion also supported which is a welcome feature. When it comes to HYPER-V support let me highlight that from their own words,

”Free 5nine V2V Easy Converter can be used as a standalone tool on different versions of Windows Server, including Free Windows Hyper-V Server 2008 R2/SP1, Server 2008 Core, Windows 8/Server 2012 (2012 R2 new), Full and Core installations and does not require any additional software licenses.”

Some of the key features are,

  • 5nine V2V Easy Converter does not require ‘removing’ the guest from the source VMware environment prior to conversion. Thus this version does not perform the ‘online’ conversion, but the downtime is much less than in case you need to store the guest in the library in order to migrate.
  • 5nine V2V Conversion process is fast, effective and easy to use. Performance testing showed up to x10 times higher conversion speeds than the current competition.
  • 5nine V2V Converter supports migration of the guests with different configurations, including large disk(s) and shared disks – these scenarios are specifically prone to the errors that other tools suffer from.
  • 5nine V2V Easy Converter allows to modify the target guest configuration parameters, although the source VM configuration is preserved by default.
  • 5nine V2V EasyConverter supports conversion of both WindowsOS, Ubuntu and CentOS VMs in most configurations.
  • Additional logging information:
    • Time Start
    • Time End
    • Bytes processed

It’s a known fact that most of the Enterprise companies who moved with VMware in large scale now turning back to HYPER-V to have a hybrid hyper visor model to manage the cost and as a stage migration method. During such period 5NINE software is indeed a welcome bonus for such companies.

Microsoft Cloud OS journey

Last month @ Singapore Microsoft held an event to introduce latest Microsoft technologies (Server 2012 R2, System Center 2012 R2, SQL 2014…etc) What exciting is this is October 17, one day before official launch of the Server 2012 R2 & System Center 2012 R2. I’ve been invited as a guest speaker during this summit.

I’ve to admit event is much better than I expected with nearly 800 participants along with various third party vendor booths. I’ve presented the topic of what’s new in HYPER-V 2012 R2 and hybrid cloud journey. You can access the presentation from here,

Cloud OS Summit