Archive for category Troubleshooting
After investigations, it was discovered that the vCenter service stopped for no reasonable reason. Revising the VC server’s System Event Log, the next error was logged:
The VMware VirtualCenter Server service terminated with service-specific error 2 (0x2).
Cause: You are trying to start the VC service before SQL Service starts. The VC Service should automatically try to restart on its own after 5 minutes after starting the SQL Service.
Resolution: To avoid this and to ensure when trying to start the VC service that the SQL service will start automatically, follow these steps to configure services’ dependencies:
- Obtain the service name for your SQL Service – in Registry Editor, browse to HKLM\System\CurrentControlSet\Services and look for entries starting with MSSQL. In all likelyhood, yours will be called either MSSQL or MSSQL$SQLEXPRESS (ignore MSSQLServerADHelper).
- Now browse to HKLM\System\CurrentControlSet\Services\vpxd
- Open the REG_MULTI_SZ value called DependOnService
- Add a line called MSSQL$SQLEXPRESS (or whatever value you determined above)
- Ensure that the last line in the value is blank
I got that error after upgrading my VMware Cluster from vSphere 4 update 2 to vSphere 4.1. Also, I had to migrate my vCenter 4 update 2 (on 32-bit Windows 2003 with MSSQL 2005 installed locally) to vCenter 4.1 (on 64-bit Windows 2008 R2 with a remote MSSQL 2008 R2 Cluster) as vCenter must be install on 64-bit OS.
Anyways, after the upgrade everything went fine escept for some issues like this error:
This error may occure because you are using a custom SQL server database with a custom Java Database Connectivity (JDBC) SQL port
Here are the steps to fix it:
- On the vCenter Server system, navigate to: C:\Documents and Settings\All Users\Application Data\VMware\VMware VirtualCenter
- Open the vcdb.properties file.
- Comment out the string usevcdb = true.
- Ensure that the values for url, driver, and dbtype are as follows or add them (after the “usevcdb = true” line) if they don’t exist:
url = jdbc:sqlserver://<hostname>:<port>;integratedSecurity=true
driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
dbtype = mssql
- Restart the VMware VirtualCenter Management WebServices service.