SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Configuration of Agent XP brings down server


Configuration of Agent XP brings down server

Author
Message
mngong
mngong
Right there with Babe
Right there with Babe (751 reputation)Right there with Babe (751 reputation)Right there with Babe (751 reputation)Right there with Babe (751 reputation)Right there with Babe (751 reputation)Right there with Babe (751 reputation)Right there with Babe (751 reputation)Right there with Babe (751 reputation)

Group: General Forum Members
Points: 751 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



Gerald West-477600
Gerald West-477600
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 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.
GilaMonster
GilaMonster
SSC Guru
SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)

Group: General Forum Members
Points: 88959 Visits: 45284
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, MVP, M.Sc (Comp Sci)
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


Blackie-424585
Blackie-424585
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 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.
Malchin Huu
Malchin Huu
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 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,
GilaMonster
GilaMonster
SSC Guru
SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)

Group: General Forum Members
Points: 88959 Visits: 45284
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, MVP, M.Sc (Comp Sci)
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


Luis Heredia
Luis Heredia
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 Visits: 18
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"
VS Raavi
VS Raavi
Grasshopper
Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)

Group: General Forum Members
Points: 16 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
SQLCereal
SQLCereal
Valued Member
Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)

Group: General Forum Members
Points: 60 Visits: 759
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]
andgeo
andgeo
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
Points: 11 Visits: 36
One of the things I change and right after that I got this is the default SQL service I change the login account that is running as.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search