December 14, 2015 at 10:07 am
I cannot get the SQL Agent to start. Every attempt ends with it starting and immediately stopping. Contents of SQLAGENT.OUT are below. No errors in any event log.
2015-12-14 12:02:56 - ? [100] Microsoft SQLServerAgent version 11.0.5058.0 (X64 unicode retail build) : Process ID 7216
2015-12-14 12:02:56 - ? [495] The SQL Server Agent startup service account is USA\USA-CL-DBPROD$.
2015-12-14 12:02:56 - ? [393] Waiting for SQL Server to recover database 'msdb'...
2015-12-14 12:02:56 - ? [000] Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install. [SQLSTATE 01000] (Message 15457)
2015-12-14 12:02:56 - ? [101] SQL Server USA-CL-DBPROD version 11.00.5058 (0 connection limit)
2015-12-14 12:02:56 - ? [102] SQL Server ODBC driver version 11.00.5058
2015-12-14 12:02:56 - ? [103] NetLib being used by driver is DBNETLIB; Local host server is
2015-12-14 12:02:56 - ? [310] 8 processor(s) and 14336 MB RAM detected
2015-12-14 12:02:56 - ? [339] Local computer is USA-CL-DBPROD running Windows NT 6.2 (9200)
2015-12-14 12:02:56 - ? [432] There are 12 subsystems in the subsystems cache
2015-12-14 12:02:56 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent
2015-12-14 12:02:56 - ? [129] SQLSERVERAGENT starting under Windows NT service control
2015-12-14 12:02:56 - ! [298] SQLServer Error: 22022, Usage: EXECUTE xp_sqlagent_notify 'A', NULL, NULL, <alert_id>, <action type> [SQLSTATE 42000]
2015-12-14 12:02:56 - ! [442] ConnConnectAndSetCryptoForXpstar failed (0).
2015-12-14 12:02:56 - ? [000] Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install. [SQLSTATE 01000] (Message 15457)
2015-12-14 12:02:56 - ? [098] SQLServerAgent terminated (normally)
Gordon Pollokoff
Wile E. is my reality, Bugs Bunny is my goal - Chuck Jones
Walking on water and developing software from a specification are easy if both are frozen. - E. Berard
Doing more things faster is no substitute for doing the right things. - S. R. Covey
Any sufficiently advanced bug is indistinguishable from a feature.- R. Kulawiec
December 15, 2015 at 7:45 am
December 15, 2015 at 7:53 am
Thank you for your response. However, the KB refers to SQL Server 2008 or SQL Server 2008R2 and I am having this issue with SQL Server 2012 SP2.
Gordon Pollokoff
Wile E. is my reality, Bugs Bunny is my goal - Chuck Jones
Walking on water and developing software from a specification are easy if both are frozen. - E. Berard
Doing more things faster is no substitute for doing the right things. - S. R. Covey
Any sufficiently advanced bug is indistinguishable from a feature.- R. Kulawiec
December 15, 2015 at 7:58 am
This isn't a SQL Express install by any chance is it?
December 15, 2015 at 8:30 am
Enterprise Edition. Agent was working until we changed the service account.
Gordon Pollokoff
Wile E. is my reality, Bugs Bunny is my goal - Chuck Jones
Walking on water and developing software from a specification are easy if both are frozen. - E. Berard
Doing more things faster is no substitute for doing the right things. - S. R. Covey
Any sufficiently advanced bug is indistinguishable from a feature.- R. Kulawiec
December 15, 2015 at 8:32 am
How did you change the service account?
Services.msc or SQL Server Configuration Manager?
December 15, 2015 at 8:34 am
I've tried both, unsuccessfully.
Gordon Pollokoff
Wile E. is my reality, Bugs Bunny is my goal - Chuck Jones
Walking on water and developing software from a specification are easy if both are frozen. - E. Berard
Doing more things faster is no substitute for doing the right things. - S. R. Covey
Any sufficiently advanced bug is indistinguishable from a feature.- R. Kulawiec
December 15, 2015 at 8:40 am
Did you change the accounts back to the original service account prior to doing different ways?
IE if you used services.msc first, did you then go straight to SSCM or did you change back to the original account via services.msc?
Sound permissions based where the new service account doesn't have rights to MSDB.
If you add the account explicitly via SSMS as a sysadmin does the agent start?
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply