Do the system event logs give you any indication of what's happening? Sounds
like an authentication issue to me. Make sure that the service is being
started with the correct authority (username/password). Type them in again
if necessary at the services.msc applet, after you have verified that they
work of course. It's easy to verify, just use "runas /user:<domain\login>
cmd" from a command window.
If you get a new cmd window, the username/password pair is valid.

-----Original Message-----
From: Laurie Snell
[mailto:mssqldba-ezmlmshield-x61107137.[Email address protected]
Sent: Friday, 30 November 2007 3:29 PM
To: LazyDBA Discussion
Subject: SQL Server Agent (Agent XPs disabled)

On SQL 2005 sp 2
SQL Server agent will not stay running
no error logs created

If you use sp_configure to set AgentXPs to 1 it changes back to 0 again

any ideas???

thanks

============================================================================
=======

CONFIDENTIALITY NOTE:

This e-mail and any attachments are confidential and may be protected by
legal privilege. If you are not the intended recipient, be aware that any
disclosure, copying, distribution, or use of this e-mail or any attachment
is prohibited. If you have received this e-mail in error, please notify us
immediately by returning it to the sender and delete this copy from your
system



Thank you for your cooperation.



P.F. Chang's China Bistro and Pei Wei Asian Diner

============================================================================
=======






---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba
job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.html



MS Sql Server LazyDBA home page