Problem Solved

Today I was working on problem related to VMware Update Manager pointing to wrong database and I managed to find the solution to this problem.

In my case SQL server was running on Windows Server 2008 R2 so I had to check 32 bit DSN located in %SystemRoot%\syswow64\odbcad32.exe

Of course DSN was pointing to correct database on correct DB server but VUM was still not working.  Also it is important to mention that two days before vCenter Server was migrated from one host to another with vCenter Server version upgrade. I knew previous SQL database names so I knew what I was looking for. On new SQL server I created new databases – the one which was VUM referring to.

I didn’t know how to find root cause but colleague of mine suggested that it must be somewhere in VUM configuration file.

I did small Powershell (grep like) query which pointed me to configuration file.

When Powershell query finished I got results where DBSTRING was located. It was vci-integrity.xml file located in VUM installation folder – in my case C:\Program Files (x86)\VMwareInfrastructure\Update Manager.

After changing section in xml and restarting VUM service everthing worked fine.

Sadly after spending some time on this I found VMware KB kb.vmware.com/kb/101522.

Rate this post
Social Media

Wojciech Marusiak

Solution Architect at Alibaba Cloud
I am an innovative and experienced IT professional with over 13 years in the IT industry.

My experience and skills have been proven by leading vendor certifications like AWS, Alibaba Cloud, VMware, and Microsoft. I contribute to the IT community and I received VMware vExpert 2014 - 2019, vExpert Pro and VMware vExpert NSX 2017 Award.

My blog wojcieh.net - was voted #76 in Top vBlog 2018 contest!

Do what you love, and you’ll never work another day in your life.
Wojciech Marusiak
Social Media