Web
Analytics Made Easy - StatCounter

vCenter 5.5: create Update Manager database and DSN

vsphere55updmgrdsn01

If the Update Manager database is installed on a dedicated SQL server, the Update Manager database and DSN must be set to properly link the DB to vCenter.

To perform this configuration a working MS-SQL server is required.

 

Installation guide

 

Part 8 - Create Update Manager database and DSN

From MS-SQL Server, open the SQL Studio Management tool and access the system. Right click Databases item and select New Database option.

vsphere55updmgrdsn02

Type a Database name (VIM_UPD) and assign the Owner. The owner should be same account used during vCenter setup. Click OK to confirm.

vsphere55updmgrdsn03

The new database used by Update Manager is then created. Exit SQL Server Studio Management.

vsphere55updmgrdsn04

 

Setup DSN

Because we have already installed the SQL Server 2008 R2 Native Client during vCenter setup, we just need to define DSN for Update Manager.

While Update Manager requires 32-bits DSN for its database, vCenter is actually running on 64-bits architecture. To properly setup the DSN we need to access the 32-bits version of ODBC Data Source Administrator:  in Windows run the file %windir%/syswow64/odbcad.exe.

From Create New Data Source window, select SQL Server Native Client 10.0 driver and click Next to start the configuration.

vsphere55updmgrdsn05

Type a Name and a Description for your data source. Click the right arrow in the Server field and select the SQL instance you want to connect to. Click Next.

vsphere55updmgrdsn06

Leave default settings then click Next.

vsphere55updmgrdsn07

Check the Change the default database to field and select the Update Manager database (VIM_UPD) previously created. Click Next to continue.

vsphere55updmgrdsn08

Leave default settings then click Finish.

vsphere55updmgrdsn09

Test the connection with Test Data Source button.

vsphere55updmgrdsn10

If you get the message:

TESTS COMPLETED SUCCESSFULLY

your system is properly configured. Click OK to save the DSN parameters.

vsphere55updmgrdsn11

The database and DSN are now created. Last step to complete the vCenter Server setup is the Update Manager installation.

Next: Part 9 - Install Update Manager

firma