SSMS connection to database - Cannot generate SSPI context

Adam Kawka 0 Reputation points
2025-03-17T08:23:06.4866667+00:00

Hello,

  • I've got a problem with connection to my MSSQL 2019 Standard instance. Some of symptoms:
  • it happens only for one domain account and on one laptop (Windows 11)
  • happens on excel, SSMS
  • when user runs "runas /user:domain\username "ssms.exe localisation"" it works
  • when user runs ssms or excel as a (local) Administrator it also works
  • problem only happens as user opens ssms or excel normally
  • after restart it works normally until a next day, as you open ssms it shows error until computer's restart - after that it works normally

The error:

The target principal name is incorrect. Cannot generate SSPI context

User's image

Also:

I assume SSPIs on the database are correct - verified manually and using Kerberos Configuration Manager + other users don't have connection problems, in this case I think every db user would experience some sort of connectivity issues

Verified domain connection using this command and it shows everything is ok - Test-ComputerSecureChannel -Verbose

SQL Server Database Engine
0 comments No comments
{count} votes

Your answer

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