This is a mirror of official site:

Tips for troubleshooting SQL Agent Error: 15281

| Thursday, August 19, 2010
Tips for troubleshooting SQL Agent Error: 15281
Chris Skorlinski
Microsoft SQL Server Escalation Services

We encountered an interesting problem the other day I thought I would post on ReplTalk.  Customer call when they noticed the SQL Server Agent resources in their SQL 2008 clustered installation would not start.  The following error appeared in the Windows Application and System Event log.

Windows Application Event Log

SQLServerAgent could not be started (reason: SQLServerAgent must be able to connect
to SQLServer as SysAdmin, but '(Unknown)' is not a member of the SysAdmin role).

[sqagtres] StartResourceService: Failed to start SQLAgent$SQL2K5 service.  CurrentState: 1
[sqagtres] OnlineThread: ResUtilsStartResourceService failed (status 435)
[sqagtres] OnlineThread: Error 435 bringing resource online.

Windows System Event Log

The Cluster service failed to bring clustered service or application 'SQL Server (SQL2K5 )' completely online or offline. One or more resources may be in a failed state. This may impact the availability of the clustered service or application.

Cluster resource 'SQL Server Agent (SQL2K5 )' in clustered service or application 'SQL Server (SQL2K5 )' failed.

We also looked in the MSSQL\LOG folder for SQL Server to see what error messages SQL Server Agent was reporting.  Here is where we noticed Error: 15281.

Read more: REPLTalk covers Using and Tuning SQL Replication

Posted via email from .NET Info


Anonymous said...

If you are going for finest contents like me, only
go to see this website everyday for the reason that it provides quality contents, thanks

Here is my weblog - Dayton Movers

Anonymous said...

Greetings! Very helpful advice in this particular post!

It is the little changes that produce the
biggest changes. Thanks for sharing!

buy smoke stars

Anonymous said...

I have learn several good stuff here. Definitely price bookmarking for revisiting.
I surprise how much attempt you put to create such a great informative

Mito slim

Anonymous said...

Hello, i think that i saw you visited my website so i came
to “return the favor”.I'm trying to find things to enhance my site!I suppose its ok to use some of your ideas!!

Buy dermal meds