Problem Installing vCenter Server 6: The user associated with the DSN has insufficient privileges

Manish Jha

Today while working in my lab I was facing one issue when I was trying to install vCenter Server on top of Server 2012. I was experimenting to deploy vCenter Server with external SQL 2014 database. This was my first experience with working on external database for vCenter Server and I knew I am gonna face some issues.

I created vCenter Server database on my SQL Server and tested connection from vCenter Server to database (ping, telnet etc) and all went fine. I setup 64 bit DSN on my vCenter Server to connect to the SQL Server and that too went fine and I was very relaxed that most difficult part is already over.

vc-14

This is when my happiness was blown away by error as described below.

vcp-5

On database settings page when I choose next I was getting error “The user associated with the DSN has insufficient privileges“. This is shown below:

vcp-1

I was not aware of this issue so I started googling and immediately found the solution.… Read More

vSphere Replication-Part 5: Replicating and Recovering VM’s using VR

Manish Jha

In last post of this series we saw how to deploy vSphere Replication appliance. In this appliance we will see the basic configurations of the replication appliance and will replicate a VM from source site to DR site. Also we will see how to recover VM on target (DR) site when your primary site has gone down.

If you have missed earlier posts of this series then you can access the same by clicking on below links:

1:Introduction to vSphere Replication

2: Lab Setup

3: Preparing vCenter for Replication

4: Deploying vSphere Replication Appliance

Let’s jump into lab and see things into action.

1: Configure vSphere Replication Appliance

a: To start configuring vSphere Replication appliance, login to the VAMI console of the appliance. This is typically accessible over URL https://VRA_FQDN:5480

Login to appliance with user root and password set during deploying vSphere Replication appliance.

config-1

b: Review your Network configuration by clicking on Network tab.… Read More

Deprecated VMFS volume(s) found on the host. Please consider upgrading volume(s) to the latest version

Manish Jha

Today while working in my Lab I was seeing following warning message on my Esxi host:
Deprecated VMFS volume(s) found on the host. Please consider upgrading volume(s) to the latest version

1

This error occurred just after I added a new shared LUN from my openfiler appliance.

If you SSH to Esxi host you will see error similar to as shown below in the /var/log/hostd.log file

… Read More

How To Configure NTP Server for vSphere Lab

Manish Jha

Today while working in my lab I was facing an issue where my vSphere Replication appliance was not getting registered to my vCenter server and while troubleshooting I came to find out this is happening because of time difference on my vCenter Server and Replication appliance.

We all know how critical is NTP in vSphere infrastructure as it keep time on all pieces of infrastructure in sync with each other and saves us from common problems that can occur due to time difference on servers.

So I decided to setup NTP server in my home lab. I have read a blog somewhere in past that primary domain controller (PDC) can be configured as NTP server. I have a domain controller in my lab so I followed the following steps to force my PDC to sync its time from internet and later point all my infrastructure servers (vCenter, esxi, replication appliance) to sync its time from my PDC.… Read More

vSphere Replication-Part 4: Deploying vSphere replication Appliance

Manish Jha

In last post of this series we saw the prerequisites that needs to be configured in vCenter Server before start deploying the replication appliance. In this post we will see how to deploy vSphere Replication appliance.

If you have missed earlier posts of this series then you can access the same by clicking on below links:

1:Introduction to vSphere Replication

2: Lab Setup

3: Preparing vCenter for Replication

Let’s dive into the installation process of replication appliance.

The vSphere Replication appliance is available in  ovf format. Download the ovf file from here.

1: Login to vCenter Web Client and select the Esxi host where you want to deploy the replication appliance and right click on it and choose Deploy OVF template.

ra-1

2: Browse to the directory where you have downloaded the ovf file and hit Next.

ra-2

3: Review the ovf details and hit Next.

ra-3

4: Accept the EULA and hit Next to continue.… Read More

vSphere Replication-Part 3: Preparing vCenter for Replication

Manish Jha

In last post of this series we had a look on pieces of infrastructure that needs to be made ready before starting and using vSphere Replication. In this post we will see what are the vCenter server requirements before start deploying vSphere Replication appliances and start configuring it.

If you have missed earlier posts of this series then you can access the same by clicking on below links:

1:Introduction to vSphere Replication

2: Lab Setup

Following settings are required to be configured in vCenter Server prior to deploying and configuring vSphere replication Appliances.

1: vCenter Server managed IP Address

The managed address settings corresponds to vCenter server name, so basically its the IP address of the management network. By default this managed address field is left blank. The vSphere Replication appliance require this to exist, so you need to punch the management IP address of your vCenter server here and then reboot the vCenter server.… Read More

vSphere Replication-Part 2: Lab Setup

Manish Jha

In first part of this series vSphere Replication Introduction we have discussed what is vSphere Replication and how it works. We also discussed the architecture and components involved and saw the possible use cases where vSphere Replication can be used.

In this post we will look on how to setup lab for deployment of vSphere Replication and what pieces of infrastructure should be ready before we start using vSphere Replication.

I am going to use cross site replication in my lab so here is my lab components:

Hardware Component

I have a Dell M4800 Mobile workstation laptop with 32 GB of RAM and i7 Quad Core processor. I am running all the lab components inside VMware Workstation.

My Lab Components

  1. I installed Server 2012 R2 Datacenter edition as my base OS. This machine will act as my Domain Controller as well as DNS Server (AD Integrated DNS).
  2. I have another Server 2012 R2 Datacenter edition installed in VMware Workstation.
… Read More

vSphere Replication-Part 1: Introduction

Manish Jha

I am quite a new candidate to vSphere Replication and have seen quite a few appliances deployed in our production environment as we are offering Disaster Recovery to Cloud (DR2C) services to our customers in vCloud Air and often have to troubleshoot issues related to replication.

So to understand how disaster recovery works and what should be the area we should be looking for while troubleshooting replication issues, I decided to try my hand on learning and deploying vSphere Replication in my lab.

So let’s begin with understanding what is vSphere Replication and its architecture and what components are involved in setting up disaster recovery environment.

What is vSphere Replication?

Earlier vSphere Replication was a feature of Site Recovery Manager (SRM) that automates the failover of virtual machines to a recovery site. vSphere Replication enables the replication of virtual machines (VMs) at the virtual layer instead of at the storage layer, as was required with earlier versions of vSphere and SRM.… Read More

vSphere-6:Part 10-Configuring vSphere Update Manager

Manish Jha

In last post of this series we learnt how to install VUM and discussed why we need VUM and how it can simplify the update and upgrades in a large infrastructure and thus make life of a VMware admin easy.

In this post we will see how to configure various settings in VUM and how to create baselines and attach the baselines to host/cluster and then how to remediate hosts.

If you have missed earlier posts of this series then you can access the same by clicking on below links:

1: Introduction to vSphere 6

2: vSphere 6-Lab Setup

3: Installing and Configuring Esxi Server 6

4: Installing vCenter 6

5: Enabling AD Authentication for vCenter Server

6: vCenter Server 6 Basic Configuration

7: Configuring dvSwitch & Port groups

8: Configuring Esxi host

9: Installing vSphere Update Manager

Configuring VUM is fairly easy task and there are not much settings involved in it.… Read More

vSphere-6:Part 9-Installing vSphere Update Manager

Manish Jha

In last post of this series we have seen how to add Esxi hosts to domain and how to configure Esxi host to reach iSCSI storage.

In this post we will learn how to install and configure vSphere Update Manager.

If you have missed earlier posts of this series then you can access the same by clicking on below links:

1: Introduction to vSphere 6

2: vSphere 6-Lab Setup

3: Installing and Configuring Esxi Server 6

4: Installing vCenter 6

5: Enabling AD Authentication for vCenter Server

6: vCenter Server 6 Basic Configuration

7: Configuring dvSwitch & Port groups

8: Configuring Esxi host

Why you need VUM?

You can ask this question to yourself that do you really need VUM in your environment especially while working in Lab environment. I would say yes. May be you are not looking for any upgrade related tasks in your lab but it is always a good idea to have hands on how VUM operates.… Read More