Database problems with the vSphere Update Manager Download Service (UMDS)

While running the vmware-umds.exe tool, you might encounter this error message.

INFO -  [440] SQL execution failed: select id from VCI_SEQUENCE where name = ?
INFO -  [441] Bind parameters:
INFO -  [446] datatype: 11 size: 30
ERROR – [main, 565] “ODBC error: (42S02) – [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name ‘VCI_SEQUENCE’.” is returned when executing SQL statement “select id from VCI_SEQUENCE where name = ?”

Cause: The default database for the user has not been set to the UMDS database. To change the default database, perform the following tasks.

1. Open the Microsoft SQL Server Management Studio
2. In the Object Explorer, navigate to Security > Logins
3. Right-click on the account you’re using to perform UMDS downloads/your UMDS service account then click Properties
4. Change the Default database to your UMDS database then click OK.