The target princial name is incorrect. Cannot generate SSPI context.

• jessymcjessface

  SSC Enthusiast

  Points: 193

  More actions

  August 15, 2023 at 3:44 pm

  #4261861

  I've just created new certs, new SPNS and applied via SSCM. Within AD I've ticked trust this user for delegation, use kerberos only to all of my new SPNS.

  SQL starts fine & I can logon locally but get the above error logging on from a different machine (therefore attempting kerberos).

  I'm sure I've done all this correctly BUT i'm going a bit bozzeyed now.

  Ideas gratefully accepted.

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  August 16, 2023 at 4:10 pm

  #4262784

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• ratbak

  Ten Centuries

  Points: 1358

  More actions

  August 16, 2023 at 4:29 pm

  #4262788

  Duplicate of https://www.sqlservercentral.com/forums/topic/the-target-princial-name-is-incorrect-cannot-generate-sspi-context

• rothj

  Hall of Fame

  Points: 3407

  More actions

  August 23, 2023 at 4:12 pm

  #4269299

  Maybe install the Kerberos diag tool and see if it checks out:  https://www.microsoft.com/en-US/download/details.aspx?id=39046

  The SSPI error is usually associated with missing SPNs.

• July 28, 2024 at 9:45 am

  This was removed by the editor as SPAM