There must also be correct name resolution in the domain. By using our site, you acknowledge that you have read and understand our Cookie Policy , Privacy Policy , and our Terms of Service. Tell us what we can do to improve the article Submit. If your logon domain differs from the domain of the computer that is running SQL Server, check the trust relationship between the domains. First, it is good practice to verify that the problem is actually due to permission issues.

Uploader: Tygolkree
Date Added: 3 December 2010
File Size: 43.46 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 20566
Price: Free* [*Free Regsitration Required]

Khwaja Arshaduddin Posted 9 years generrate Reply from Dynamic IP: 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, collect the following information and open a Microsoft Customer Support CSS case.

At least now we have verified that the problem is related to the SPN and we are ready to apply the fix. You can’t edit other topics. This will help you.

How to troubleshoot the “Cannot generate SSPI context” error message

Our application called three databases on three servers and aside from that was not complicated. The error still occurs when a A new job is created b When the user running the job is changed. Right there with Babe. You can’t delete other events. 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 – Error: Cannot Generate SSPI context – Database Administrators Stack Exchange

Tell us what we can do to improve the article Submit. Switching to the LocalSystem under Built-in worked for me. You can’t delete other topics. You can’t delete your own posts.

There must also be correct name serrver in the domain. Look at the Microsoft Kerberos Configuration Manager tool.

Windows domain administrator accounts or Windows Server domain administrator accounts can use the utility geenerate control the SPN that is assigned to a service and an account. However, this hotfix is intended to correct only the problem that is described in this article.

You can’t post replies to polls.

Cannot generate SSPI context. Apply this hotfix only to systems that are experiencing dontext specific problem. Racer SQL 2, 4 23 Keep up to date – daily newsletter:.

Consider an SPN as a domain or forest unique identifier of some instance in a server resource. You can’t post new topics. You can’t delete your own topics. Hope it helps someone. You can’t edit other posts. You should now see an entry similar to oxbc. I don’t want to change anything.


General Forum Members Points: Log in to the server where you SQL Instance is running. The explanation, as given by Microsoft in this KB article. Therefore, whatever resides in the EAX register becomes the return value.

You can’t edit your own events. Marco 3, 3 15