Home > Cannot Generate > Odbc Connection Error Cannot Generate Sspi Context

Odbc Connection Error Cannot Generate Sspi Context


I was also not able to connect to any Windows shares while I had this issue. With the help of SPN the clients which try to connect to the service can easily identify it. You should now be able to connect even when SQL Server is restarted as the SPN is only created once. You cannot post events. have a peek at these guys

In it, you'll get: The week's top questions and answers Important community announcements Questions that need answers see an example newsletter By subscribing, you agree to the privacy policy and terms I never fixed it unfortunately - it went away when I reinstalled windows. share|improve this answer answered Nov 28 '09 at 13:48 gbn 270k40385483 Thank you for your immediate response! 1. Or... https://support.microsoft.com/en-us/kb/811889

Cannot Generate Sspi Context Sql Server 2008 R2

share|improve this answer answered Mar 19 '14 at 12:23 Andrew 5,14442647 add a comment| up vote 4 down vote I had the same issue after changing the user which was running In the CN= AccountName Properties dialog box, click the Security tab. Remove rows in table that have rows with missing values What legal documents are Italian citizens supposed to carry when traveling to Ireland? How to Enable Group Policy Debugging on Windows 7 ...

Avantgarde Technologies IT Support Perth Sunday, January 12, 2014 ODBC SQL Server Driver - Cannot Generate SSPI context On the weekend I responded to an emergency callout regarding a custom Microsoft I think a reboot used to fix it - have you tried that? All Rights Reserved. Cannot Generate Sspi Context Microsoft Sql Server 2012 On the client (Windows 8.1 Pro) i get the following in event viewerthese point to Kerberos, but i know nothing about Kerberos lol A Kerberos error message was received:on logon sessionClient

It did not recognise me - and tthen finally it locked my account. If you test by using a domain administrator account as the SQL Server service account, the SPN is successfully created because the domain administrator-level credentials that you must have to create You can check the syntax in net once. http://www.sqlservercentral.com/Forums/Topic654688-146-1.aspx share|improve this answer edited Jul 16 '15 at 20:16 Tony L. 4,25631933 answered Nov 28 '09 at 13:48 Jeremy McGee 16.8k64286 Thank you, password not expired recently.

His Active Directory credentials had been setup with data reader privileges to the specific database. The Target Principal Name Is Incorrect. Cannot Generate Sspi Context. (.net Sqlclient Data Provider) All was good in our world. What is Service Principal Name (SPN)? You cannot delete other topics.

Cannot Generate Sspi Context Odbc

This seemed to generate some kind of trust that allows MSSQL to connect without this error even after a reboot. Not the answer you're looking for? Cannot Generate Sspi Context Sql Server 2008 R2 Terms of Use. The Target Principal Name Is Incorrect Cannot Generate Sspi Context However, under alias, the name of the computer was there with TCP forced.

Any other apps affected? http://usableflash.com/cannot-generate/odbc-error-0-cannot-generate-sspi-context.php In the CN= AccountName Properties dialog box, click the Security tab. 5. I suspect it has something to do with overflowing the security token that Kerberos uses and have seen similar strange authentication problems for user accounts in a large number of groups. SPN for each service is registered in the Active Directory. Cannot Generate Sspi Context Fix

Join the community Back I agree Powerful tools you need, all for free. You cannot edit HTML code. Exchange 2003 to Exchange 2010 Mailbox Move Failin... ► 2013 (92) ► December (7) ► November (5) ► October (20) ► September (6) ► August (4) ► July (11) ► June http://usableflash.com/cannot-generate/odbc-connection-failed-cannot-generate-sspi-context.php Please help on this.

You cannot post topic replies. Sqlexception (0x80131904): The Target Principal Name Is Incorrect. Cannot Generate Sspi Context. Should I report it? When I looked at the configuration manager, named pipes and shared memory were both enabled (good).

share|improve this answer edited Feb 20 '14 at 22:00 Adi Inbar 6,59893050 answered Dec 7 '12 at 21:29 CuriousDiscer 391 . in connection string dit it. –Berzerk Apr 24

It turns out that his account had an option enabled that was set to ‘Use DES encryption types for this account'. If you still have problems I recommend following the troubleshooting steps in Troubleshooting Kerberos Errors. You cannot vote within polls. The Target Principal Name Is Incorrect Cannot Generate Sspi Context C# This is very simple to check and fix.

Eventually we ran across a set of actions that could cause this: If you change the user that the Sql Server runs as (e.g. SQL, SSPI ← HMO vs. You cannot post or upload images. http://usableflash.com/cannot-generate/nav-odbc-error-cannot-generate-sspi-context.php Rebooting the VM alone did not resolve it.

Connection failed: SQL State:'S1000' SQL Server Error 0 [Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context After investigation this was caused by an incorrect time set on the SQL server. When a service starts, the service tries to create the SPN (if it does not exist already) under the credentials of the service start up account. Lab colleague uses cracked software. What does a -4 above the stave mean?

share|improve this answer answered Oct 14 '13 at 11:19 Mark Ngugi 111 add a comment| up vote 1 down vote This error usually comes when the Windows user account is expired You may get a better answer to your question by starting a new discussion. Go to the error logs and look for the last time that the SQL service was restarted. You cannot delete your own events.

But I was clearly in the domain, able to RDP to servers and access the Intranet in IE. –cdonner Feb 1 '13 at 16:50 add a comment| up vote 0 down You cannot post replies to polls. There are 3 ways to fix the problem: Revert to using the Network Service or Local System account (NOT RECOMMENDED) Assign the domain account to the Domain Admins group (NOT IDEAL Copyright © 2002-2016 Simple Talk Publishing.

Hope this helps!!!!! share|improve this answer answered Nov 29 '09 at 9:26 Prasanna 3152312 add a comment| up vote 0 down vote Had a really weird instance of this; All the web products that comments powered by Disqus current community chat Stack Overflow Meta Stack Overflow your communities Sign up or log in to customize your list. Polyglot Anagrams Cops' Thread more hot questions question feed lang-sql about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life /

Make sure Pricipal is "SELF", Type is "Allow" and "Applied to" is "This Object Only", in Properties section, select the properties below: Read servicePrincipalName Write servicePrincipalName Click OK to apply all This error is shown in the output window (inside VS2008 screen) and the building process failed.