You may receive the following error from VirtualCenter after a the server is restarted
The VMware VirtualCenter Server service terminated with service-specific error 2 (0x2).
Checking the VirtualCenter log shows the following.
[2008-11-17 08:48:12.703 'App' 1800 error] ODBC error: (28000) - [Microsoft][SQL Native Client][SQL Server]Login failed for user 'NT AUTHORITY\SYSTEM'.
[2008-11-17 08:48:12.703 'App' 1800 error] Failed to intialize VMware VirtualCenter. Shutting down...
[2008-11-17 08:48:12.703 'App' 1800 info] Forcing shutdown of VMware VirtualCenter now
The SQL Server is not available. In this case the SQL Server is installed on the same server as VirtualCenter and has not started by the time the VirtualCenter Server service attempts to start.
Add the local SQL Server as a dependency to the VirtualCenter Server service. Perform the following on the VirtualCenter Server.
1) Start Regedit
2) Browse to the following key
3) Double Click the DependOnService value name
4) Add the SQL Service key name to the list of services
a. By default this is MSSQL$SQLEXP_VIM
5) Click Ok
6) Restart the computer
You can view the list of dependencies via the Services MMC. Below is a screen shot showing the newly added SQL Server (SQLEXP_VIM) instance as a dependency of VirtualCenter Server.
Article ID: 115, Created On: 9/17/2011, Modified: 9/17/2011