Share via

SQL Server login with SSMS

2956 1 Reputation point
2022-01-13T21:38:00.563+00:00

I have a new SQL Server 2019 installed on a server. However, I can not logon using SSMS on my local machine but without a problem from the server. The error message is:
The target principal name is incorrect. Cannot generate SSPI context. Any clue to figure it out? Thanks.

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 22,431 Reputation points Microsoft External Staff
    2022-01-14T02:05:16.087+00:00

    Hi @2956 ,

    You can use Kerberos Configuration Manager tool, this Microsoft Tool is like Magic. Run it, connect it to the SQL server, and click Fix. It will save your time. Refer to MS document Kerberos Configuration Manager for SQL Server is available.

    There is a long discussion with some insights can be found from this similar thread The target principal name is incorrect. Cannot generate SSPI context. Hope this could help you.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Was this answer helpful?

    0 comments
  2. Ronen Ariely 15,221 Reputation points
    2022-01-13T22:19:20.46+00:00

    Hi,

    Please go over this document: How to troubleshoot the "Cannot generate SSPI context" error message

    https://support.microsoft.com/en-us/topic/how-to-troubleshoot-the-cannot-generate-sspi-context-error-message-03d15ff2-e062-e023-272c-d5cd413c37b3

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.