How To Troubleshoot The Cannot Generate Sspi Context Error Message
Contents |
360 games PC games cannot generate sspi context sql server 2008 r2 Windows games Windows phone games Entertainment All Entertainment the target principal name is incorrect cannot generate sspi context sql server Movies & TV Music Business & Education Business Students & educators the target principal name is incorrect. cannot generate sspi context. (.net sqlclient data provider) Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet odbc sql server driver cannot generate sspi context Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All
Sqlexception (0x80131904): The Target Principal Name Is Incorrect. Cannot Generate Sspi Context.
Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta
System.data.sqlclient.sqlexception: Cannot Generate Sspi Context.
Discuss the workings and policies of this site About Us Learn the target principal name is incorrect. cannot generate sspi context. sharepoint 2013 more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us the target principal name is incorrect cannot generate sspi context c# Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, https://support.microsoft.com/en-us/kb/811889 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 B which is running the SQL Server. I have Googled extensively and all the things http://stackoverflow.com/questions/32309922/the-target-principal-name-is-incorrect-cannot-generate-sspi-context 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=Computers,DC=yyy,DC=local: MSSQLSvc/xxDEVSVR003.yyy.local:1433 MSSQLSvc/xxDEVSVR003.yyy.local Hyper-V Replica Service/xxDEVSVR003 Hyper-V Replica Service/xxDEVSVR003.yyy.local Microsoft Virtual System Migration Service/xxDEVSVR003 Microsoft Virtual System Migration Service/xxDEVSVR003.yyy.local Microsoft Virtual Console Service/xxDEVSVR003 Microsoft Virtual Console Service/xxDEVSVR003.yyy.local WSMAN/xxDEVSVR003 WSMAN/xxDEVSVR003.yyy.local TERMSRV/
Performance Programming Recovery Replication Security Space management SQL Cluster Setup SQL General SQL Query SQL Saturday SQL Server Cluster SQL Server https://mssqlwiki.com/tag/cannot-generate-sspi-context/ Engine SQL Server I/O SQL Server memory SQL Server Setup SQL Server Tools SQLServer SOS SSMS Startup failures Summary Archives January 2014 December 2013 November 2013 September 2013 June 2013 May 2013 April 2013 March 2013 February 2013 January 2013 December 2012 November 2012 October 2012 September 2012 August 2012 July 2012 cannot generate June 2012 May 2012 April 2012 March 2012 February 2012 January 2012 December 2011 July 2011 June 2011 March 2011 February 2011 January 2011 December 2010 November 2010 October 2010 September 2010 August 2010 July 2010 June 2010 May 2010 April 2010 March 2010 February 2010 January 2010 May 2009 April 2009 cannot generate sspi March 2009 February 2009 January 2009 Tags 17883 17884 17887 17888 AllocateUserPhysicalPages AWE Allocator API's Blocking Connectivity CreateFile CreateMemoryResourceNotification Debugging Encrytion error 17883 non yielding Error: 15466 External dump process returned no errors External dump process returned no errors.DoMiniDump () encountered error GetClusterResourceState GetPerformanceInfo GetProcessMemoryInfo GetVolumeInformation Index usage Inside SQLOS Level 16 Linked server LockPagesinMemory LookupPrivilegeValue MapUserPhysicalPages max server memory memory dump memory leak non-yielding Non-yielding IOCP Listener Non-yielding Scheduler OpenCluster OpenClusterResource OpenProcess OSVERSIONINFOEX Overlapped I/O OVERLAPPED structure Performance Process 0:0:0 ( ) Worker appears to be non-yielding on Scheduler Profiler QueryMemoryResourceNotification Query tuning Replication Severity: 16 SOS SQL General SQLOS SQL Query sql scheduler SQL Server 2005 SQL Server 2008 SQLServer Cluster SQLServer CPU SQLServer dump SQL Server management studio sql server maximum server memory SQLServer mdmp sqlserver memory SQL Server memory SQLServer operating system sql server performance SQLServer scheduler SQLServer SOS SQLServer Tools SSMS Stack Dump State: 1. Trace Transactional replication UM