Yesterday I ran into this error message while installing a new SQL Server 2005 instance on a Windows 2003 cluster:
Setup failed to start on the remote machine. Check the Task scheduler event log on the remote machine.
SQL Server 2005 setup, in a clustered environment, relies on a remote setup process started on the passive nodes through a scheduled task:
For some weird reason, the remote scheduled task refuses to start if there is an active RDP session on the passive nodes. This KB article describes symptoms and resolution in detail: http://support.microsoft.com/kb/910851/en-us
If you look into the Scheduled Tasks log you will find something similar to this:
sql server Task did not appear to start on machine <machine_name> 267015
Needless to say that one of my co-workers was logged on the desktop of one of the passive nodes. So, if you need another good reason to lock everyone out of your servers’ desktop, here it is.
After resetting the offending session, remember to log on to all the passive nodes and kill the zombie setup processes you may have left. Also, delete the scheduled tasks from each node.