Cchetty: 1 revision

2011-09-14T15:57:32Z

1 revision

← Older revision

Revision as of 15:57, 14 September 2011

Jayark: /* SQL Agent fails to start */

2010-07-26T05:08:32Z

SQL Agent fails to start

New page

== SQL Agent fails to start==

{| border="1"
|-
! '''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
<pre>
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)

</pre>
|-
! '''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.
|-
|}

[[Category:Unified CCX, Release 7.0]]

SQL Agent fails to start - Revision history

Cchetty: 1 revision

Jayark: /* SQL Agent fails to start */