Cannot generate SSPI context

• Art-251407

  Right there with Babe

  Points: 768

  More actions

  June 16, 2008 at 6:06 am

  #72127

  Hi,

  Saw this error on sql server agent log:

  [165] ODBC Error: 0, Cannot generate SSPI context [SQLSTATE HY000][382] Logon to server 'servername' failed (ConnAttemptCachableOp)

  My sql jobs, which is running osql using nt authentication, are failing because of this.

  Please help how to resolve this one.

  Many thanks,

  Art

• Rudyx - the Doctor

  SSC-Forever

  Points: 43695

  More actions

  June 17, 2008 at 4:02 pm

  #830103

  Check out this post:

  http://www.sqlservercentral.com/Forums/Topic400504-146-1.aspx

  RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."