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

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 its dependency upon the SQL server resource for the affected instance.
The Solution
Add the SQL Server dependency, bring SQL Server Agent online in Cluster Administrator

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: