I don’t want to change anything. You can’t post or upload images. 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: However, once you do the right thing and change the SQL Service account, you may start getting the following error message when attempting to connect to the sql server:. Windows domain administrator accounts or Windows Server domain administrator accounts can use the utility to control the SPN that is assigned to a service and an account. Can be one of these things:
|Date Added:||5 October 2005|
|File Size:||19.4 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
How to troubleshoot the “Cannot generate SSPI context” error message
Understanding the problem This section gives you the background information on why the “Cannot generate Canont context” error message occurs and how to troubleshoot the error. You can’t edit your own posts. You should find an genrate message similar to this: But it doesn’t help me, because they’re working fine until yesterday. I’ve had this problem sorted by forcing a time reset from the server, all machines in the group policy span will go back to server time and then error its gone Log in to the server where you SQL Instance is running.
Skip to main content. Many thanks, Kindest Regards, Nick. 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 can’t vote in polls. There’s nothing usefull on the internet.
However, once you do the right thing and change the SQL Service account, you may start getting the following error message when attempting to connect to the sql server: SQL Server connectivity issue: Skip to main content. You can’t xspi your own posts. First, it is good practice to verify that the problem is actually due to permission issues.
The password of the account was changed. United Kingdom – English. I had a similar issue. This identifies the general class of service. Collect information to open a Microsoft Customer Support CSS case If you cannot obtain the cause of the problem by using the troubleshooting steps in this article, serveg the following information and open a Microsoft Customer Support CSS case. Switching to the LocalSystem under Built-in worked for me.
ODBC SQLState HY Cannot generate SSPI context
You can’t post or upload images. This will help you.
United States – English. Everyone knows that it is good practice to use a domain or service account to run the SQL service. 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.
Fixing error: “Cannot generate SSPI context” after changing SQL service account
Log in to the server running your Active Directory service and execute the following steps: General Forum Members Points: Further action is only required if Kerberos authentication is required by authentication ssoi and if the SPN has not been manually registered. For a complete list of Microsoft Customer Support telephone numbers and information about support costs, go to the following Microsoft website: Post as a guest Name.
United States – English. For a complete list of Microsoft Customer Service and Support telephone ocntext or to create a separate service request, visit the following Microsoft Web site: