Cloud Lab-21: How to Install vCenter Update Manager (VUM) – “DB Preparation” (Part 1)

What is VUM?  

VMware vSphere Update Manager automates patch management and eliminates manual tracking and patching of vSphere hosts and virtual machines. It compares the state of vSphere hosts with baselines, then updates and patches to enforce compliance.

I divided my VUM lab into two parts. In first part, i will show you how to create VUM VM and his Database and in second part , i am going to show you how to install the VUM Server.

LAB-21 TASKS (Part 1)

In this Lab we will perform following tasks

  1. Create a VM for vCenter Update Manager
  2. Our Perquisites configuration for vCenter Update Manager
  3. vCenter Update Manager Database creation.
  4. DNS Configuration for vCenter update Manager Database

1-Create VM for vCenter Update Manager

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

o   Right Click on Server and Choose New Virtual Machine
o   Enter VM Name (Cloud-VUM) 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: 2GB
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: 50GB
o   Use thin provision
o   Install OS.

2-Our Perquisite Configuration for Management Server

After Installation of Management server. Configure following perquisite

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

3-vCenter Update Manager Database Creation.

Go to SQL Server Machines (192.168.150.3) -> Open the “SQL management studio” from programs menu

Add server name -> choose authentication as shown->“connect”

cloudlab20-VUM-1

In the Object Explorer ->Databases folder->Right-click->“New Database”

cloudlab20-VUM-2

Enter the Database Name, in our case it is “VUM

cloudlab20-VUM-3

In Options->Recovery model->Choose “Simple” ,Click “OK”

cloudlab20-VUM-4

Create a new user for “VUM” Database.

VUM Database Login

In the Object Explorer->Security folder->Login->right click->“New Login”

cloudlab20-VUM-5

Select username (vumuser) , password  and default DB “VUMs”, language for User.

cloudlab20-VUM-6

Server Roles->Select “sysadmin” role.

cloudlab20-VUM-7

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

cloudlab20-VUM-8

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

cloudlab20-VUM-9

4-DNS Configuration for vCenter update Manager Database

*NOTE: Virtual Center Update Manager required 32 bit DSN connectivity*

On Cmd: C:\Windows\SysWOW64\odbcad32.exe

ODBC Data source Administrator->System DSN->Click “Add”

cloudlab20-VUM-10

Choose SQL Native Client

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.

cloudlab20-VUM-11

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-VUM” 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”

cloudlab20-VUM-12

Enter a name for the “DSN” and enter SQL Server for VUM database. It is (cloud-vum.vmlab.com) in my case because vCenter and SQL are on different box).Click “Next”

cloudlab20-VUM-13

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

cloudlab20-VUM-14

Check Change default database->Choose you “DB”Click “Next”

cloudlab20-VUM-15

Click “Finish”

cloudlab20-VUM-16

Click “Test Data Source”.

cloudlab20-VUM-17

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

cloudlab20-VUM-18

Now every thing is set and ready for installation of VUM Server. i will show you how to install VUM in my next part of this post.

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s