Error 0 Cannot Generate Sspi
Contents |
360 games PC games cannot generate sspi context fix Windows games Windows phone games Entertainment All Entertainment
Cannot Generate Sspi Context Ssms
Movies & TV Music Business & Education Business Students & educators
Cannot Generate Sspi Context Sql Server 2008 R2
Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet
Cannot Generate Sspi Context. (.net Sqlclient Data Provider) Sql 2008
Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All cannot generate sspi context sql 2012 Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more cannot generate sspi context sql 2005 about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users cannot generate sspi context sql 2000 Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping the target principal name is incorrect. cannot generate sspi context each other. Join them; it only takes a minute: Sign up Cannot create SSPI context up vote 20 down vote favorite 4 I am working on a .NET application where I am trying to build the database scripts. https://support.microsoft.com/en-us/kb/811889 While building the project, I am getting an error "Cannot create SSPI context.". This error is shown in the output window (inside VS2008 screen) and the building process failed. Please help on this. SQL Server is configured to work on Windows authentication & running as network service (these two things are must for my project). Please help on this. This error is not seems to be consistent. It was fixed in the past by restarting the machine, http://stackoverflow.com/questions/1812541/cannot-create-sspi-context changing the system time to match the domain time and some suggestions in the net. Please help on this. sql sql-server security sspi share|improve this question edited Nov 9 '15 at 14:01 Brian Webster 17.3k37115199 asked Nov 28 '09 at 13:41 Prasanna 3102312 1 I got this error after I had changed my default DNS server addresses under my Network Adapter's IPv4 Properties. When I changed my DNS server back to default, it went away. –James McCormack Jul 19 '13 at 10:02 add a comment| 14 Answers 14 active oldest votes up vote 13 down vote accepted It's quite a common error with a variety of causes: start here with KB 811889 What version of SQL Server? And Windows on client and server? Local or network SQL instance? Domain or workgroup? Provider? Changing password Local windows log errors? Any other apps affected? share|improve this answer answered Nov 28 '09 at 13:48 gbn 267k40374480 Thank you for your immediate response! 1. SQL Server 2008 2. Windows Xp 3. Network instance 4. Domain 5. not changed password for a while 6. Logs only show this error 7. I could nt able to log in from my applicaation, thats it. I can able to log in directly in SQL –Prasanna Nov 28 '09 at 17:12 3 Fixing App pool user/password did it for me. –SAM I AM Jun
account to run the SQL service. I’m sure you do too! However, once you do the right thing and change the SQL https://cmatskas.com/fixing-error-cannot-generate-sspi-context-after-changing-sql-service-account/ Service account, you may start getting the following error message when attempting to connect to the sql server: “The target principal name is incorrect. Cannot generate SSPI context.” The explanation, as given by Microsoft in this KB article If you run the SQL Server service under the LocalSystem account, the SPN is automatically registered and Kerberos authentication interacts successfully with cannot generate the computer that is running SQL Server. However, if you run the SQL Server service under a domain account or under a local account, the attempt to create the SPN will fail in most cases because the domain account and the local account do not have the right to set their own SPNs. When the SPN creation is not successful, cannot generate sspi this means that no SPN is set up for the computer that is running SQL Server. If you test by using a domain administrator account as the SQL Server service account, the SPN is successfully created because the domain administrator-level credentials that you must have to create an SPN are present. There are 3 ways to fix the problem: Revert to using the Network Service or Local System account (NOT RECOMMENDED) Assign the domain account to the Domain Admins group (NOT IDEAL – due to the elevated permissions) Fix the problem by giving the domain account just the appropriate permissions in Active Directory. Permissions required are ServicePrincipalName: Read ServicePrincipalName: Write We will use the 3rd option to fix the error. First, it is good practice to verify that the problem is actually due to permission issues. Log in to the server where you SQL Instance is running. Go to the error logs and look for the last time that the SQL service was restarted. You should find an error message similar to this: Date 10/17/2013 9:29:50 AM Log