Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Configuration of Agent XP brings down server Expand / Collapse
Author
Message
Posted Wednesday, February 28, 2007 6:10 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, September 17, 2007 8:55 AM
Points: 563, Visits: 1

Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install.

Next alert
Only administrators may connect at this time.

There is a chance some one messed with this but I cannot understand why.The person who was logged in at the time was running profiler and the logs confirm that the trace was stopped?


What could trigger the change except user input.
your input is as usual appreciated

Mike




Post #348091
Posted Monday, March 05, 2007 8:00 AM
SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,039, Visits: 1
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
Post #349116
Posted Friday, September 28, 2007 9:20 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 19, 2007 12:41 AM
Points: 1, Visits: 4
Not sure this is a sure answer, but I recently experienced a similar event while snmp services was being installed. There is little to explain it other than this. The machines (plural) that were 'clustered' together both terminated the DTC and SQL Server 2005 processes. Once the SQL service was restarted, both services (snmp) run together with out any issues. Unfortunately we only have these 2 machines configured in this manner

We tried a repeat on a stand alone, and it did not cause the process to stop.
Post #404086
Posted Saturday, September 29, 2007 2:57 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:21 AM
Points: 41,507, Visits: 34,422
The agent XPs always change from 1 to 0 as the server starts shutting down. It's an effect, not a cause.

What caused the shutdown is another matter. What's the last line of the error log?



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #404327
Posted Wednesday, December 12, 2007 10:11 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, September 06, 2009 6:36 AM
Points: 1, Visits: 93
Date 12/11/2007 3:14:02 PM
Log SQL Server (Archive #1 - 12/11/2007 3:15:00 PM)

Source Server

Message
The connection has been lost with Microsoft Distributed Transaction Coordinator (MS DTC). Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) will begin once the connection is re-established. This is an informational message only. No user action is required.

Next-----

Date 12/11/2007 3:15:41 PM
Log SQL Server (Archive #1 - 12/11/2007 3:15:00 PM)

Source Logon

Message
Login failed for user 'OVERN'. Only administrators may connect at this time. [CLIENT: 10.200.18.22]

NExt-----
Date 12/11/2007 3:15:44 PM
Log SQL Server (Archive #1 - 12/11/2007 3:15:00 PM)

Source spid35s

Message
Service Broker manager has shut down.
Post #432432
Posted Tuesday, February 26, 2008 11:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, June 07, 2009 11:37 AM
Points: 1, Visits: 35
We are having the same with the SQL Server 2005 Cluster. Does anyone have any idea why the server failover randomly with these errors?

Thanks,
Post #460410
Posted Tuesday, February 26, 2008 11:36 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:21 AM
Points: 41,507, Visits: 34,422
Check the cluster logs and the event logs to see if you can find a reason for the service to fail over.

Agent XPs are always switched to 0 as a SQL server shuts down. It's not the cause of the failure.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #460440
Posted Friday, March 04, 2011 7:47 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 22, 2012 9:48 AM
Points: 8, Visits: 16
Please,

Try this.

exec sp_configure 'agent',1
reconfigure with override
go

The original post is: "http://learnsqlwithbru.com/SQLForums/index.php?topic=148.0"
Post #1073334
Posted Thursday, May 09, 2013 12:16 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 7:17 PM
Points: 6, Visits: 269
This can be because of a security patch update on the server, for more information please refer:
Agent XPs Server Configuration Option

Thanks,
Suresh Raavi
Post #1450898
Posted Monday, September 09, 2013 2:09 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, April 10, 2014 1:29 PM
Points: 41, Visits: 512
We also just experienced this issue. In our case, it was due to our infrastructure team installing SNMP on the server, which in certain environments will stop the SQL Server service and SQL Agent service -

[url=http://social.technet.microsoft.com/Forums/windowsserver/en-US/957e0a70-e502-44eb-9a4c-8efdbcf380b4/installing-snmp-services-stops-sql-server-services][/url]
Post #1492916
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse