To prepare a Microsoft SQL Server database to work with Update Manager, you have to create a data source (ODBC).

Procedure

  1. On your Update Manager server system, select Control Panel > Administrative Tools > Data Sources (ODBC).
  2. Click the System DSN tab.
  3. Create or modify an ODBC system data source.

    Option

    Action

    Create an ODBC system data source

    1. Click Add.

    2. For Microsoft SQL Server 2008, Microsoft SQL Server 2008 R2 Express, Microsoft SQL Server 2012, or Microsoft SQL Server 2014 select SQL Native Client, and click Finish.

    Modify an existing ODBC system data source

    Double-click the ODBC system data source that you want to modify.

    To see a detailed list of all Microsoft SQL Server database versions that are compatible with the Update Manager server and the UMDS, select the Solution/Database Interoperability option from the VMware Product Interoperability Matrixes at http://www.vmware.com/resources/compatibility/sim/interop_matrix.php.

  4. In the Microsoft SQL Server DSN Configuration window, enter the necessary information and click Next.
    1. Type an ODBC DSN in the Name text field.

      For example, type VUM.

    2. (Optional) : Type an ODBC DSN description in the Description text field.
    3. Select the SQL Server name from the Server drop-down menu.

      Type the SQL Server machine name in the text field if you cannot find it in the drop-down menu.

  5. Configure the SQL Server authentication, and click Next.
    • If you are using a local SQL Server, you can select Integrated Windows NT authentication.

    • If you are using a remote SQL Server, you must use the SQL Server authentication method.

    If you use the SQL Server authentication method, in the Update Manager installation wizard supply the same user name, password, and ODBC DSN that you used to configure the ODBC.

    Important:

    Update Manager does not support Windows authentication of the database when the database is located on a different machine because of local system account issues. Make sure that if the Update Manager database is on a remote machine, the database, and the system DSN use SQL Server authentication.

  6. Select a database from the Change the default database to drop-down menu, specify the ANSI settings, and click Next.
  7. Specify the language and translation settings, where to save the log files, and click Finish.

What to do next

To test the data source, in the ODBC Microsoft SQL Server Setup window, click Test Data Source, and click OK. Ensure that SQL Agent is running on your database server by double-clicking the SQL Server icon in the system tray.