ODBC SQLState HY000 Cannot generate SSPI context

• El barto

  Ten Centuries

  Points: 1072

  More actions

  February 11, 2009 at 5:40 am

  #130929

  Hello everyone,

  When running scheduled jobs from SQLAgent all jobs fail with the error message.

  [Microsoft SQL-DMO (ODBC SQLState: HY000)] Error 0: [Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context

  There server has been rebooted, and I have confirmed connectivity to the box from various machines. The error still occurs when a) A new job is created b) When the user running the job is changed.

  Any advice?.

  Many thanks,

  ---

  Kindest Regards,

  Nick

• Khwaja Arshaduddin

  SSC Eights!

  Points: 843

  More actions

  February 11, 2009 at 6:17 am

  #942044

  This will help you.

  http://www.sqlservercentral.com/Forums/Topic10251-106-1.aspx