the target principal name is incorrect cannot generate sspi context

Question

the target principal name is incorrect cannot generate sspi context

LearningDBA

SSCertifiable

Points: 6609
More actions
December 1, 2016 at 7:07 pm

#315391

I am able to login and access the DB when I login into the server but when I use SSMS which is installed on my machine, I get this error "the target principal name is incorrect. Cannot generate sspi context. Any help on this please?
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
Forum Etiquette: How to post Reporting Services problems

[/url]

Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]

How to Post Performance Problems - by Gail Shaw
[/url]

Sue_H SSC Guru Points: 90860 More actions · Answer 1

New Born DBA (12/1/2016)
I am able to login and access the DB when I login into the server but when I use SSMS which is installed on my machine, I get this error "the target principal name is incorrect. Cannot generate sspi context. Any help on this please?

That error is typically a Kerberos authentication issue. Often not too fun to troubleshoot. This MS blog walks through many of the steps you can use to troubleshoot the error:

https://blogs.msdn.microsoft.com/meer_alam/2015/05/10/the-target-principal-name-is-incorrect-cannot-generate-sspi-context/

Sue

mister.magoo SSC-Forever Points: 47174 More actions · Answer 2

Another useful resource for this : https://support.microsoft.com/en-gb/kb/811889

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);