CANNOT GENERATE SSPI CONTEXT ODBC SQL SERVER DRIVER DOWNLOAD

It can be caused by many issues, like an outaded password, clock drift, Active Directory access permissions, failure to register an SPN and so on and so forth. You should now see an entry similar to this: To do this, go to the following Microsoft website: Note The ‘Account is Trusted for Delegation’ right is required only when you are delegating credentials from the target SQL server to a remote SQL server such as in a double hop scenario like distributed queries linked server queries that use Windows authentication. United States – English. You should find an error message similar to this:

Uploader: Moogusar
Date Added: 27 March 2007
File Size: 49.18 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 81583
Price: Free* [*Free Regsitration Required]

By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies.

Fixing error: “Cannot generate SSPI context” after changing SQL service account

Recently I started getting this error. Crna Gora – Srpski.

Sign up using Facebook. Understanding the problem This section gives you the background information on why the “Cannot generate SSPI context” error message occurs and how to troubleshoot the error.

You May Also Need:  ASUS F70SL DRIVER DOWNLOAD

Email Required, but never shown.

The Local Area Connection Properties dialog box contest. You can’t post replies to polls. Home Questions Tags Users Unanswered. You can’t edit other topics. United States – English.

Are you using Windows authentication and working cwnnot a domain? For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft Web site: Adrian Morson 11 1.

I was then able to access SQL Server remotely. Consider an SPN as a domain or forest unique identifier of some instance in a server resource. I can’t restart the server now. Ping the desired server and see what reply you get.

Fixing error: “Cannot generate SSPI context” after changing SQL service account

In Control Panel, double-click Network Connections. Double-click the local area connection that you want to modify. Check whether the domain that the server belongs to and the domain sspii that you use to connect are in the same forest. Add the following at the end of the file: If so, check that the client machine is working fine in the domain.

You May Also Need:  EXTENSA 4630Z AUDIO DRIVERS FOR WINDOWS 7

Post reply Like Add to Briefcase. El barto Posted 9 years ago Sign up using Sspii.

sql server – Error: Cannot Generate SSPI context – Database Administrators Stack Exchange

You can’t post new topics. United States – English. You may receive this error message if the following conditions are true: Looking for answers, I found this: Indonesia Bahasa – Bahasa.

Permissions required are ServicePrincipalName: I really can’t figure out what to do. You should now see an entry geneeate to this: Resolving the problem This section shows you the steps to help ensure that your computer does not experience any SSPI problems.