cluster

Some months ago I posted a method to overcome some quirks in the MDW database in a clustered environment. Today I tried to upgrade that clustered instance (in a test environment, fortunately) and I got some really annoying errors. Actually, I got what I deserved for messing with the system databases and I wouldn’t even dare posting my experience if it wasn’t cause by something I suggested on this blog. [Read More]

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. [Read More]