zzamboni.org

Starting VirtualCenter Automatically When It Fails to Start

Create a .bat file with following script:

net start MSSQL$SQLEXP_VIM
ping 127.0.0.1 -n 120 -w 1000 > null
net start vpxd

Note: for SQL Server substitute MSSQLSERVER in the above batch file instead of MSSQL$SQLEXP_VIM.

Set script to run on boot.

In one of my VirtualCenter servers, a Windows XP machine, the VirtualCenter Server service often fails to start because it tries to run before the MSSQL server is fully initialized. This happens even when the dependencies are set correctly between the services (which is the official solution provided by VMware). The workaround is to create a startup script as shown above. I remove the redirection to nul (which means the script window shows the ping output) as a reminder of what is happening.

To make it a startup script in WinXP, click on Start -> All programs, then right-click on “Startup” and select “Open All Users”. Store the script there (just name it with a .bat extension to make it executable).