--- title: "VMware vSphere Update Manager 5.5" date: "2013-11-06T08:30:32Z" tags: ["SQL Server", "SQL Server 2012 SP1", "VMware Update Manager", "Windows Server"] categories: ["Microsoft", "VMware"] --- ![VMware vSphere Update Manager][1] Once we successfully installed vCenter Server 5.5 it is time to enhance its functionality by installing VMware vSphere Update Manager. ## What is VMware vSphere Update Manager? In short words, Update Manager is used to automating patching of VMware hosts. It is really simple yet powerful tool - it allows you easily update your whole infrastructure with zero downtime (if all done properly 😉 ). You can read details on VMware site http://www.vmware.com/products/vsphere/features/update-manager.html. ## VMware vSphere Update Manager Database creation I didn't find anything on VMware site how to prepare or create VMware Update Manager database but I will use example script for vCenter Database and just rename it. ```sql go CREATE DATABASE [vUMDB] ON PRIMARY (NAME = N'vUMDB', FILENAME = N'E:Program FilesMicrosoft SQL ServerMSSQL11.MSSQLSERVERMSSQLDATAvUMDB.mdf' , SIZE = 3000KB , FILEGROWTH = 10% ) LOG ON (NAME = N'vUMDB_log', FILENAME = N'E:Program FilesMicrosoft SQL ServerMSSQL11.MSSQLSERVERMSSQLDATAvUMDB.ldf' , SIZE = 1000KB , FILEGROWTH = 10%) COLLATE SQL_Latin1_General_CP1_CI_AS go use vUMDB go sp_addlogin @loginame=[vumser], @passwd=N'Start123@_1_2', @defdb='vUMDB', @deflanguage='us_english' go ALTER LOGIN [vumser] WITH CHECK_POLICY = OFF go CREATE USER [vumser] for LOGIN [vumser] go ``` ![VMware vSphere Update Manager - Database Creation][2] After successful Database creation, you need to add a user to **db_owner** to VUMDB. ## VMware vSphere Update Manager 32 bit DSN creation VMware vSphere Update Manager use 32 bit DSN ODBC connector. In order to configure it, you need to navigate to **%windir%SysWoW64odbcad32.exe** directory and create DSN. It is pretty much the same next, next, finish creator. Please remember to use SQL Native Client 32-bit DSN, otherwise, it will be not detected by VUM. 1. Navigate to directory and start odbcad32.exe
![VMware vSphere Update Manager - 32 bit DSN 1][3] 2. Click Add and select SQL Server Native Client and click Finish.
![VMware vSphere Update Manager - 32 bit DSN 2][4] 3. Provide Name, Description and SQL Server.
![VMware vSphere Update Manager - 32 bit DSN 3][5] 4. Point to SQL Database VUMDB
![VMware vSphere Update Manager - 32 bit DSN 4][6] 5. Go to the end of setup and test connectivity.
![VMware vSphere Update Manager - 32 bit DSN 5][7] ## VMware vSphere Update Manager Installation Installation is pretty straight forward. If you configured 32-bit DSN it will be painless. Let us go through it quickly so we can patch our Infrastructure. 1. Launch installation from ISO
![VMware vSphere Update Manager - Installation 1][8] 2. Accept License Agreement
![VMware vSphere Update Manager - Installation 2][9] 3. Select if you want to immediately download patches from VMware site. I deselected it because I want to do it manually later.
![VMware vSphere Update Manager - Installation 3][10] 4. Provide vCenter Server IP address and credentials.
![VMware vSphere Update Manager - Installation 4][11] 5. Select previously configured 32-bit DSN.
![VMware vSphere Update Manager - Installation 5][12] 6. Summary of Database information
![VMware vSphere Update Manager - Installation 7][13] 7. Enter connection information in your environment.
![VMware vSphere Update Manager - Installation 8][14] 8. If you have less than 120GB free on disk where you will install VMware Update Manager you will receive this warning. Don't worry - installation will be not canceled.
![VMware vSphere Update Manager - Installation 9][15] 9. Change Directory if needed.
![VMware vSphere Update Manager - Installation 10][16] 10. Click Install to go ahead with the installation.
![VMware vSphere Update Manager - Installation 11][17] 11. Click Finish.
![VMware vSphere Update Manager - Installation 12][18] Once VUM is installed you can check via vSphere Web Client or vSphere Client if the plugin is available.As you see on the screenshot it is available. ![VMware Update Manager plugin][19] That is it. I hope your installation process was painless and it worked fine. I will cover VUM usage in next posts. [1]: /images/uploads/2013/11/VMware-vSphere-Update-Manager.webp [2]: /images/uploads/2013/11/VMware-vSphere-Update-Manager-Database-Creation.webp [3]: /images/uploads/2013/11/VMware-vSphere-Update-Manager-32-bit-DSN-1.webp [4]: /images/uploads/2013/11/VMware-vSphere-Update-Manager-32-bit-DSN-2.webp [5]: /images/uploads/2013/11/VMware-vSphere-Update-Manager-32-bit-DSN-3.webp [6]: /images/uploads/2013/11/VMware-vSphere-Update-Manager-32-bit-DSN-4.webp [7]: /images/uploads/2013/11/VMware-vSphere-Update-Manager-32-bit-DSN-5.webp [8]: /images/uploads/2013/11/VMware-vSphere-Update-Manager-Installation-1.webp [9]: /images/uploads/2013/11/VMware-vSphere-Update-Manager-Installation-2.webp [10]: /images/uploads/2013/11/VMware-vSphere-Update-Manager-Installation-3.webp [11]: /images/uploads/2013/11/VMware-vSphere-Update-Manager-Installation-4.webp [12]: /images/uploads/2013/11/VMware-vSphere-Update-Manager-Installation-5.webp [13]: /images/uploads/2013/11/VMware-vSphere-Update-Manager-Installation-7.webp [14]: /images/uploads/2013/11/VMware-vSphere-Update-Manager-Installation-8.webp [15]: /images/uploads/2013/11/VMware-vSphere-Update-Manager-Installation-9.webp [16]: /images/uploads/2013/11/VMware-vSphere-Update-Manager-Installation-10.webp [17]: /images/uploads/2013/11/VMware-vSphere-Update-Manager-Installation-11.webp [18]: /images/uploads/2013/11/VMware-vSphere-Update-Manager-Installation-12.webp [19]: /images/uploads/2013/11/VMware-Update-Manager-plugin.webp