Cloud Lab-10 : How to Install and Configure Cloud vCenter -“Prepare vCenter DB” (Part 1)

In my Cloud lab, if you check or remember my cloud lab setup guide than you will know, i divide my private cloud into two sections. one is for management and second for resource group. so i have to configure and install vCenter for boths (Manangement & RG). In this post, i will show you only one vCenter Installation. it is for Resource group (RG) vCenter. you will follow the same steps for your Management vCenter installation. 

LAB-10 TASKS (Part 1)

In this Lab we will perform following tasks

  1. Create a vm for Resource group VCenter
  2. Our Perquisites configuration for Resource Group VCenter Server
  3. RG VCenter Database creation.
    • Create New vCenter DB Login
  4. DSN Configuration for RG vCenter Database
    • Install SQL Native Client

1-Create VM for Management vCenter Server

Use the following specs to create a VM for active directory and install OS.

o   Right Click on Server and Choose New Virtual Machine
o   Enter VM Name (RG-VC) and Inventory Location
o   Select Datastore
o   Select Virtual Machine Version: select latest available
o   Select “Microsoft Windows Server 2008 R2 (64-bit)” as OS Version
o   # of Virtual Processors: 1
o   Amount of RAM: 4GB
o   Network

  • # of NICs: 1
  • Adapter Type: VMXNET 3
  • Select “Connect at Power On

o   SCSI Controller: LSI Logic SAS
o   Create New Virtual Disk: 40GB
o   Use thin provision
o   Install OS.

2-Our Perquisite Configuration for Management vCenter Server

After Installation of Management server. Configure following perquisite

  • Set system name (
  • Configure an IP address (
  • Install Microsoft .Net 3.5 role.
  • Enable remote desktop
  • Verify time and time zone settings (GMT+5)
  • Enter forward and Reverse DNS Entry for 
  • Join domain
  • Disable Windows Firewall

3-RG vCenter Database Creation

Go to the SQL Server (, which we installed in my SQL Server Lab and connect through RDP.

Open the SQL Management Tools -> connect using “sa” user credentials.


In the Object Explorer ->Databases folder->Right-click->”new Database”.


Enter the Database Name, in our case it is “Cloud-VC1”. Choose as you like


In Options->Recovery model->choose “simple”, Click “OK” 


Create a new user for “Cloud-VC1” Database.

Create New vCenter Database Login

In the Object Explorer->Security folder->Login->right click->new Login


Select username (cloudvc1-user), password “P@ssw0rd”  or whatever you may like and default DB “Cloud-VC1”, language for User.


Server Roles->Select “sysadmin” role.


User mapping->Select DB “Cloud-VC1”->Choose both “db_owner, public”


Status tab-> verify the permissions for login as highlighted, Click “OK”.


4-DSN Configuration for RG VCenter Database.

For DSN configuration go to Control panel->administrative tools->ODBC Data source Administrator->System DSN-> “Add”


Choose SQL Native Client

NOTE: If SQL Server and VCenter are on the same machine then you don’t need to install SQL server native client, because it’s already installed with sql server.

In our case we have sql server and VCenter on different machines. So we have to install sql native client first. As you see below, snap before installing of native client.


Install SQL Native Client.

You will find native client installer in SQL media ISO/CD at “x64\Setup\x64\sqlncli.msi” folder. Grab the installer on “Cloud-VC1” server and install. It’s very easy you just have to click next.

Now go back to system DNS-> “Add”.

Select “SQL Server Native Client 10.0” -> Click “Finish”


Enter a name for the “DSN” and enter SQL Server for RG vCenter database. It is ( in my case because vCenter and SQL are on different box).

Click “Next”


Select 2nd option “SQL Authentication” and enter the username/password which we created earlier for “cloud-vc1” database, Click “Next”


Check “Change default database”->Choose “Cloud-VC1” Database, Click “Next”.


Click “Finish”


Click “Test Data Source”


If it’s successful then all is well, Click “OK”.

Thats it for this lab. What we have covered in this lab:

vCenter DB and DSN Connection has been for vCenter. every thing is set and ready for intallation. in my next Cloud Post i will show you how to install vCenter.


Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s