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 1 - Install guide introduction
- Part 2 - Install ESXi 5.5
- Part 3 - Install vCenter Single Sign-On
- Part 4 - Install vSphere Web Client
- Part 5 - Install Inventory Service
- Part 6 - Create vCenter database and DSN
- Part 7 - Install vCenter Server
- Part 8 - Create Update Manager database and DSN
- Part 9 - Install Update Manager
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:
TESTS COMPLETED SUCCESSFULLY
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
