Therefore, SSPI allows for a computer that is running a Windows operating system to securely delegate a user security token from one computer to another over any transport layer that can transmit raw bytes of data. It’s a bit more involved than newer versions. Verify the domain Verify that the domain to which you log on can communicate with the domain to which the computer that is running SQL Server belongs. This is a very common error with a variety of causes. You can’t post events.
|Date Added:||5 August 2009|
|File Size:||52.45 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
Verify the domain Verify that the domain to which you log on can communicate with the domain to generwte the computer that is running SQL Server belongs.
The ConnectionGetSvrUser function internally calls the gethostbyaddr function.
Marco 3, 3 15 But it doesn’t help me, because they’re working fine until yesterday. You can’t vote in polls.
Our application called three databases on three servers and aside from that was not complicated. The domain account is locked out. You can’t post topic replies.
Everyone knows that it is good practice to use a domain or service account cannto run the SQL service. Locate the Hosts file, and then open the file in notepad. You must make sure that you can successfully log on to Windows by using the same domain account and password as the startup account of the SQL Server service.
Skip to main content.
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. Tell us what we can do to improve the article Submit.
sql server – Error: Cannot Generate SSPI context – Database Administrators Stack Exchange
ODBC SQLState HY Cannot generate SSPI context
This is a very common error with a variety of causes. Add the following at the end of the file: General Forum Members Points: HY ] Error 0: This tool essentially automates the manual steps found in this article. At least now we have verified that the problem is related to the SPN and we are ready to apply the fix.
You should find an error message similar to this:. You can’t edit your own posts.
Fixing error: “Cannot generate SSPI context” after changing SQL service account
Unthreaded, ascending Unthreaded, descending. Further action is only required if Kerberos authentication is required by authentication policies and if the SPN has not been manually registered. If your logon domain differs from the domain of the computer that is comtext SQL Server, check the trust relationship between the domains.
Email Required, but never shown. If so, check that the client machine is working fine in the domain.
Can be one of these things: Post as a guest Name. You can post emoticons.