Tips for troubleshooting SQL Agent Error: 15281
Chris Skorlinski
Microsoft SQL Server Escalation ServicesWe 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 LogSQLServerAgent 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 LogThe 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
Chris Skorlinski
Microsoft SQL Server Escalation ServicesWe 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 LogSQLServerAgent 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 LogThe 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
Posts
4 comments:
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
Greetings! Very helpful advice in this particular post!
It is the little changes that produce the
biggest changes. Thanks for sharing!
buy smoke stars
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
website.
Mito slim
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
Post a Comment