119 questions
SSMS connection to database - Cannot generate SSPI context
Adam Kawka
0
Reputation points
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
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
Sign in to answer