Home > Cannot Generate > Odbc Error Cannot Generate Sspi Context

Odbc Error Cannot Generate Sspi Context


You cannot delete your own posts. Here is the error message with which it was failing. If the service is configured to start using a domain user account, the SPN is created under the user account in Active Directory. Not the answer you're looking for? http://usableflash.com/cannot-generate/odbc-error-0-cannot-generate-sspi-context.php

I never fixed it unfortunately - it went away when I reinstalled windows. The ADSIEdit tool is included in the Windows Support Tools 2. As I mentioned earlier, from the error message it was clear that the issue was a result of errors with the SPN. This is very simple to check and fix. https://support.microsoft.com/en-us/kb/811889

Cannot Generate Sspi Context Sql Server 2008 R2

In the Advanced Security Settings dialog box, make sure that SELF is listed under Permission entries. Can I substitute decaf coffee for espresso How do I deal with my current employer not respecting my decision to leave? Fixed. 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 is a unique identifier for each service that is running on servers. You cannot delete other topics. Many thanks, Kindest Regards,Nick Post #654688 Khwaja ArshaduddinKhwaja Arshaduddin Posted Wednesday, February 11, 2009 6:17 AM SSC Journeyman Group: General Forum Members Last Login: Wednesday, December 8, 2010 3:57 AM Points: The Target Principal Name Is Incorrect. Cannot Generate Sspi Context. (.net Sqlclient Data Provider) The content on this site reflects my own personal opinion and does not represent the views of any other individual or organization.

As seen here… http://www.mskbarticles.com/index.php?kb=319723 Reply ↓ Pingback: Something for the Weekend - SQL Server Links 09/09/11 col September 19, 2012 at 8:28 pm If you need to run the SQL Server The Target Principal Name Is Incorrect. Cannot Generate Sspi Context Sql 2012 still working on that now but the priority is changing and I'm not sure we're going to continue work on this problem so I wanted to post something in case this Permissions required are ServicePrincipalName: Read ServicePrincipalName: Write We will use the 3rd option to fix the error. http://www.sqlservercentral.com/Forums/Topic654688-146-1.aspx So other than the time on their watches, check the time zones as well.

You cannot post topic replies. Cannot Generate Sspi Context Microsoft Sql Server 2012 You cannot edit your own topics. setspn –A MSSQLSvc/ accountname After the correct SPN was created, SQL Server service started successfully. it was only 2005).

The Target Principal Name Is Incorrect. Cannot Generate Sspi Context Sql 2012

By creating an account, you're agreeing to our Terms of Use, Privacy Policy and to receive emails from Spiceworks. Email Reset Password Cancel Need to recover your Spiceworks IT Desktop password? Cannot Generate Sspi Context Sql Server 2008 R2 Windows 8.1 Internet Explorer 11 - This page can't... Cannot Generate Sspi Context Odbc why rdsk is not available in linux?

Resetting it to Local System Account solved the problem. http://usableflash.com/cannot-generate/odbc-connection-error-cannot-generate-sspi-context.php Is just a cover error for any underlying Kerberos/NTLM error. You should now see an entry similar to this: Date                    10/17/2013 10:53:58 AM Log                       SQL Server (Current - 10/17/2013 10:54:00 AM) Source                Server Message The SQL Server Network Interface library successfully Add Cancel × Insert code Language Apache AppleScript Awk BASH Batchfile C C++ C# CSS ERB HTML Java JavaScript Lua ObjectiveC PHP Perl Text Powershell Python R Ruby Sass Scala SQL Cannot Generate Sspi Context Fix

You cannot edit your own events. The error still occurs when a) A new job is created b) When the user running the job is changed. more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed http://usableflash.com/cannot-generate/nav-odbc-error-cannot-generate-sspi-context.php Swapped it to Local System, rebooted, swapped it to domain user, rebooted, bam -- worky worky.

Can a text in Latin be understood by an educated Italian who never had any formal teaching of that language? The Target Principal Name Is Incorrect. Cannot Generate Sspi Context. Sharepoint 2013 Why "silver-tongued" for someone who is convincing? Should I report it?

Our admin guy doesn't like Vista and likes to blame everything on Vista (refuses to let us test Windows 7)...

Do humans have an ethical obligation to prevent animal on animal violence? Cannot generate SSPI context Hot Network Questions Why is Professor Lewin correct regarding dimensional analysis, and I'm not? Terms of Use. Sqlexception (0x80131904): The Target Principal Name Is Incorrect. Cannot Generate Sspi Context. Issue for me was my AD account was locked out between login to machine and login to SSMS. –Brent Jun 3 '14 at 15:27 Bam, this is what was

Windows Xp 3. This is an informational message. Creating your account only takes a few minutes. news Running ipconfig /release and ipconfig /renew from command prompt, and restarting Visual Studio solved this issue for me. –Robotnik Dec 14 '15 at 0:57 add a comment| up vote 4 down

RESOLUTION: You need to reset SPN. So, we set things back to Local System and bam it worked. 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. 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

A month goes by and a power strip fries causing the server to have an unexpected shutdown.