Installing vSphere 6.0 Update Manager with External SQL database

VMware vSphere Update Manager is an important component in vSphere environment, Update Manager (VUM) enable you to automate (or in most cases semi-automate) the process of downloading and deploying updates, patches and other 3rd-party component.

The installation of VUM is pretty simple and straightforward, I didn’t find a “complete” step-by-step guide to install VUM with external SQL database so I decided to write this post. there is others great guides for installing VUM and I recommend to also check them up.

In this post I will use vSphere 6 Update 1b.

Important Links –

Prerequisite –

  • vCenter server (Windows or appliance).
  • Windows 2012 R2 Server (This is where we will install VUM).
  • Pre-created Database – I will use a Microsoft SQL 2012 SP2 Server but VUM support another versions (check the “VMware Product Interoperability Matrixes“)
  • Local SQL user with a db-owner permission on the VUM database and db-owner on the MSDB database.

Creating DSN –

You will need to create local DSN before the installation of VUM, VUM is a 32-bit application and you will need to use a 32-bit DSN driver.

Download the SQL Native Client for SQL server 2012 from the “Microsoft® SQL Server® 2012 Feature Pack“. Important! – Download the 64-bit version, it will also install the 32-bit driver.

  1. Select the “SQL Server Native Client 11.0” driver (the “SQL Server” driver will not work, trust me…).
  2. Enter the name of the DSN and the SQL server DSN name (I recommend use FQDN but this is not mandatory).
  3. Integrated Windows authentication is not supported, Select “With SQL Server authentication…” and enter the local SQL username and password.
  4. Select the checkbox for “Change the default database to:” and select the DB you created for VUM.
  5. Keep default and click Finish…
  6. Test the Data Source you just created

Done! You ready to install VUM.

Installing VUM –

  1. Mount (or extract) the “VMware vCenter Server 6.0 Update1b and Modules for windows” ISO image and execute the autorun.exe file. Select “Server” under the “vSphere Update Manager” (like in the picture) and select Install.
  2. Welcome, click next and accept the terms.
  3. You can deselect the option to download updates immediately after the installation. (default is enable).
  4. enter the IP Address or Name of the vCenter Server (again, I recommend to use FQDN), and the domain username and password.
  5. Select the DSN we created earlier.
  6. Enter the username and password for the local SQL authentication.
  7. You might get this warning, its ok. if its a lab environment just remember to monitor the free disk space on the SQL server, for production environment you will need to configure maintenance .
  8. Accept default ports and choose what you prefer – IP or hostname. I prefer hostname.
  9. Select where to install VUM and where to place the downloaded patches. I changed the download directory to a different drive.
    Note – if the drive have less then 120GB of free space the wizard will warn you about this. that ok.
  10. You ready to install, click Install.

Congratulation, you just installed VUM in your environment.

Next – add the plug-in to the vSphere Web Client (and vSphere Client)

Installing the VUM plug-in in the vSphere Web Client is super easy  –

  1. Log on to the vSphere Web Client. Go to Administration –> Client Plug-Ins.
    Click the “Check for New Plug-Ins”.
  2. You will notice this pop-up and after a few seconds the VUM plug-in will be added to the list.
  3. Done! you can access VUM from the Web Client.

Thanks for reading!