vCenter 5.5: create Update Manager database and DSN


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.


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


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



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.


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.


Leave default settings then click Next.


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


Leave default settings then click Finish.


Test the connection with Test Data Source button.


If you get the message:


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


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