SQL

FIX for SQL cluster instance install error: “There was an unexpected failure during the setup wizard. The service cannot be started, either because it is disabled, or because it has no enabled devices associated with it”

by File in: SQL

I received the following generic popup message when installing a new instance on SQL 2005 SP3 cluster running on Windows Server 2003 R2:  There was an unexpected failure during the setup wizard.  The service cannot be started, either because it is disabled, or because it has no enabled devices associated with it.   The active […]

Fix: SQL Configuration Manager Connection to target machine could not be made in a timely fashion

by File in: SQL

Things didn’t go too smoothly yesterday when I was trying to reconfigure our SQL 2005 cluster and it’s database locations.  At one point I couldn’t even get SQL Configuration Manager to start up.  At various times I received both of the following errors. The request failed or the service did not respond in a timely […]

Fix: SQL agent wont start on Windows 2003 Cluster, Event 53

by File in: SQL

The Problem SQL Agent won’t start on a Windows cluster for a particular instance The Symptoms Seen in Windows Application log   Event: 53 Source: SQLAgent$CF3Common Category: Failover   [sqagtres] OnlineThread: Error 6 bringing resource online. [sqagtres] OnlineThread: ResUtilSetResourceServiceEnvironment failed (status 6)   The Cause   In Cluster Administrator, the SQL Server Agent had lost […]