SQL Agent fails to start

From DocWiki

(Difference between revisions)
Jump to: navigation, search
Jayark (Talk | contribs)
(SQL Agent fails to start)
Newer edit →

Revision as of 05:08, 26 July 2010

SQL Agent fails to start

Problem Summary SQL Agent fails to start and the CCX node restarts mulitiple time finaly SQL Agent serivce is disabled and a red X mark appears next to SQL Agent Service in AppAdmin
Error Message Following error is seen in C:\Program Files\Microsoft SQL Server\MSSQL$CRSSQL\LOG\SQLAGENT.OUT
2009-10-21 09:38:11 - ! [298] SQLServer Error: 6, Specified SQL server not found. [SQLSTATE 08001] 
2009-10-21 09:38:11 - ! [298] SQLServer Error: 11004, ConnectionOpen (Connect()). [SQLSTATE 01000] 
2009-10-21 09:38:11 - ! [000] Unable to connect to server '<hostname>\CRSSQL'; SQLServerAgent cannot start
2009-10-21 09:38:12 - ? [098] SQLServerAgent terminated (normally)

OR 

2010-07-21 08:41:49 - ! [298] SQLServer Error: 1, Cannot generate SSPI context [SQLSTATE HY000] 
2010-07-21 08:41:49 - ! [000] Unable to connect to server 'NGLUCCX2\CRSSQL'; SQLServerAgent cannot start
2010-07-21 08:41:49 - ? [098] SQLServerAgent terminated (normally)

Possible Cause Invalid configuration in SQL Server Client Network Utility
Recommended Action

Run the command *cliconfg.exe* it will launch SQL Server Client Network Utility click on Aliases tab if there is an alias with IP address modify it to use host name and ensure it is using TCP/IP. If you still see issues try using Named Pipes. Go to General tab and enable Named pipes and move it up the order. In the Alias tab, add an alias which uses Named Pipe. Select the Named Pipe radio button from the left, in the Server alias text field type hostname\CRSSQL. All other text fields will get filled automatically. Click OK and close the window. After that try to start the SQL Agent again.

Release Release 7.0(1)
Associated CDETS # None.

Rating: 5.0/5 (1 vote cast)

Personal tools