vCenter Server won't automatically start on boot after domain join

I am getting errors like: ODBC error: (08001) - [Microsoft][SQL Native Client]Client unable to establish connection due to prelogin failure in C:\Documents and Settings\All Users\Application Data\VMware\VMware VirtualCenter\Logs\vpxd-##.log

Related tags: MSSQL Windows

Credit: Original Poster

It is most likely the ODBC connection is misconfigured to use localhost or a different name when connecting to the database.
To fix it go in to Data Sources (ODBC) under Administrative Tools.
Select the System DSN tab.
Select the VMware VirtualCenter data source and select Configure
In the "Which SQL Server do you want to connect to?" drop down change localhost\SQLEXP_VIM to HOSTNAME\SQLEXP_VIM
Do not use the fully qualified hostname, just the server name.
Click Next a few times and then Finish and Test the data source. If it tests ok, give the server a reboot and it should start automatically.

Rating: 2

Propose a different solution...