Cannot Generate Ssp1 Context Error Message
Contents |
Al - MSFTMay 10, 20151 0 0 0 Introducing the problem scenario Yet another Kerberos authentication failure troubleshooting scenario. This scenario never stops paying me a visitevery now and then. Same type of symptoms. SQL Server named cannot generate sspi context instance configured to listenon a static port. Logged on user (in a
Cannot Generate Sspi Context Sql Server 2008 R2
client machine) and the SQL server machine are on two different domains. A domain controller has been upgradedto 2012. the target principal name is incorrect. cannot generate sspi context Domain trust has been the same as it was before SPNs exists as before, in the working scenario. Yet, when the user tries to connect to SQL Server instance cannot generate sspi context fix from SQL Server Management Studio, they get the familiar Kerberos authentication failure error message: "The target principal name is incorrect. Cannot generate SSPI context" Environment Details User: DomainA\userA Server: xxxxx.DomainB.com (this is a standalone SQL Server) SQL Server Instance: xxxxx\SQLx (version 2014) SQL Server Domain: DomainB Current Windows Server for Domain Controllers (Windows Server 2012). This was an
Cannot Generate Sspi Context Vpn
upgrade. This is the only change. Let us collect some data to see what went wrong As I typically do, after verifying the error message from SSMS, I first wanted to make sure, we have the correct SPNs. So I ran the command (in SQL Server machine, we have the tool so it was ok to run here): SETSPN -L
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers cannot generate sspi context (microsoft sql server) or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x cannot generate sspi context 2012 Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it
Cannot Generate Sspi Context Sql Server 2008 Windows Authentication
only takes a minute: Sign up Cannot create SSPI context up vote 19 down vote favorite 4 I am working on a .NET application where I am trying to build the database scripts. While building the project, I am getting https://blogs.msdn.microsoft.com/meer_alam/2015/05/10/the-target-principal-name-is-incorrect-cannot-generate-sspi-context/ an error "Cannot create SSPI context.". This error is shown in the output window (inside VS2008 screen) and the building process failed. Please help on this. SQL Server is configured to work on Windows authentication & running as network service (these two things are must for my project). Please help on this. This error is not seems to be consistent. It was fixed in the past by restarting the machine, changing the system time to match the domain time and http://stackoverflow.com/questions/1812541/cannot-create-sspi-context some suggestions in the net. Please help on this. sql sql-server security sspi share|improve this question edited Nov 9 '15 at 14:01 Brian Webster 17.3k37115199 asked Nov 28 '09 at 13:41 Prasanna 3052312 1 I got this error after I had changed my default DNS server addresses under my Network Adapter's IPv4 Properties. When I changed my DNS server back to default, it went away. –James McCormack Jul 19 '13 at 10:02 add a comment| 14 Answers 14 active oldest votes up vote 12 down vote accepted It's quite a common error with a variety of causes: start here with KB 811889 What version of SQL Server? And Windows on client and server? Local or network SQL instance? Domain or workgroup? Provider? Changing password Local windows log errors? Any other apps affected? share|improve this answer answered Nov 28 '09 at 13:48 gbn 267k40374480 Thank you for your immediate response! 1. SQL Server 2008 2. Windows Xp 3. Network instance 4. Domain 5. not changed password for a while 6. Logs only show this error 7. I could nt able to log in from my applicaation, thats it. I can able to log in directly in SQL –Prasanna Nov 28 '09 at 17:12 3 Fixing App pool user/password did it for me. –SAM I AM Jun 24 '15 at 13:36 add a comment| up vote 13 down vote It sounds like your PC hasn't contac
here for a quick overview of the site Help Center Detailed answers to any http://stackoverflow.com/questions/32309922/the-target-principal-name-is-incorrect-cannot-generate-sspi-context questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow cannot generate is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up The target principal name is incorrect. Cannot generate SSPI context up vote 1 down vote favorite I am struggling to get a SQL Server connection from machine A to machine cannot generate sspi B which is running the SQL Server. I have Googled extensively and all the things I have found have not worked. Nor do they lead you step by step through the process of solving this. We are not using Kerberos, but NTLM where configured. The machines involved are (xx is used to obscure some of the machine name for security purposes): xxPRODSVR001 - Windows Server 2012 Domain Controller xxDEVSVR003 - Windows Server 2012 (This machine is generating the error) xxDEVSVR002 - Windows Server 2012 (This machine is running SQL Server 2012) The following SPN's are registered on the DC (xxPRODSVR001). I have obscured the domain with yyy for security purposes: Registered ServicePrincipalNames for CN=xxDEVSVR002,CN=Computers,DC=yyy,DC=local: MSSQLSvc/xxDEVSVR002.yyy.local:49298 MSSQLSvc/xxDEVSVR002.yyy.local:TFS RestrictedKrbHost/xxDEVSVR002 RestrictedKrbHost/xxDEVSVR002.yyy.local Hyper-V Replica Service/xxDEVSVR002 Hyper-V Replica Service/xxDEVSVR002.yyy.local Microsoft Virtual System Migration Service/xxDEVSVR002 Microsoft Virtual System Migration Service/xxDEVSVR002.yyy.local Microsoft Virtual Console Service/xxDEVSVR002 Microsoft Virtual Console Service/xxDEVSVR002.yyy.local SMTPSVC/xxDEVSVR002 SMTPSVC/xxDEVSVR002.yyy.local WSMAN/xxDEVSVR002 WSMAN/xxDEVSVR002.yyy.local Dfsr-12F9A27C-BF97-4787-9364-D31B6C55EB04/xxDEVSVR002.yyy.local TERMSRV/xxDEVSVR002 TERMSRV/xxDEVSVR002.yyy.local HOST/xxDEVSVR002 HOST/xxDEVSVR002.yyy.local Registered ServicePrincipalNames for CN=xxDEVSVR003,CN