April 20, 2016 at 7:54 am
I reboot my Sql server, and now SQL Server Agent shows not started in Management Studio, red, with "Agent XPs Disabled".
BUT
I ran this:
EXEC SP_CONFIGURE 'Agent XPs',1
RECONFIGURE
And sp_configure shows '1' in config_value & run_value.
SQL Agent shows "started" through Windows Services.
I have restarted everything several times
I did change the "sa" password yesterday EDIT: This was the cause, but why ?
Ideas ??
April 20, 2016 at 8:01 am
What does it say in SQLAGENT.OUT?
John
April 20, 2016 at 8:08 am
John Mitchell-245523 (4/20/2016)
What does it say in SQLAGENT.OUT?John
Nothing useful now after rebooting, but seems it was the "sa" password change, not sure why.
April 20, 2016 at 8:16 am
If you look in the SQL errorlog, do you have failed login attempts for sa? If you look at the Properties of SQL Server Agent and go to the Connection tab, is it set up to connect with sa?
John
April 20, 2016 at 9:32 am
SQL Agent uses Windows Authentication.
Looking at Windows-Services, it shows SQL Server Agent using MyDomain\Administrator
I don't see any "sa" related errors in the various error logs
April 20, 2016 at 12:40 pm
Maybe I was hallucinating ?? I changed the "sa" password the next day, and restarted SQL Agent, and it's fine ....
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply