Cannot Generate Sspi Context Sql Server 2008 Error
Contents |
360 games PC games cannot generate sspi context sql server 2008 r2 Windows games Windows phone games Entertainment All Entertainment cannot generate sspi context sql server 2008 r2 management studio Movies & TV Music Business & Education Business Students & educators
Sql Server 2008 Cannot Generate Sspi Context Fix
Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet
Cannot Generate Sspi Context Sql Server 2000
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 server 2014 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 about hiring developers or
Cannot Generate Sspi Context Sql Server 2005
posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss cannot generate sspi context sql server network interfaces the target principal name is incorrect Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes cannot generate sspi context sql server 2012 a minute: Sign up Cannot create SSPI context up vote 19 down vote favorite 4 I am working on a .NET application where I am trying to build the database scripts. While building the project, I am getting an error https://support.microsoft.com/en-us/kb/811889 "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, changing the system time to match the domain time and some suggestions in http://stackoverflow.com/questions/1812541/cannot-create-sspi-context 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 3052312 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 12 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 24 '15 at 13:36 add a comment| up vote 13 down vote It sounds like your PC hasn't contacted an authenticating domain controller for a litt
log in tour help Tour Start 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 http://dba.stackexchange.com/questions/93389/error-cannot-generate-sspi-context about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site http://www.sqlservercentral.com/Forums/Topic1265396-1550-1.aspx for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question cannot generate Anybody can answer The best answers are voted up and rise to the top Error: Cannot Generate SSPI context up vote 3 down vote favorite 1 When someone tries to connect to a SQL Server instance, the error shows up: It's not possible do generate SSPI context. Yesterday we had a blackout (don't know how to say this expression in English) and I had to shut down our servers. Looking cannot generate sspi for answers, I found this: SQL Server 2008 connectivity issue : cannot generate SSPI context But it doesn't help me, because they're working fine until yesterday. I don't want to change anything. But if a have to, I will change it. Obs: I can't restart the server now. Edit: Since I my answer, we haven't had any errors. sql-server sql-server-2008 authentication errors connectivity share|improve this question edited Aug 30 '15 at 13:06 Paul White♦ 29.2k11163262 asked Feb 20 '15 at 11:14 Rafael Piccinelli 1,471629 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... Although thats my particular case, you can try =). –Nelson Casanova Feb 20 '15 at 11:37 Hello. Thats the problem. I can't restart the server, we have more than 500+ users online. I really can't figure out what to do. There's nothing usefull on the internet. –Rafael Piccinelli Feb 20 '15 at 12:04 1 Set the group policy from the server itself to automatically change the time for the users. If you dont want to restart the server to force the changes in the group policy you can use
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2008 » SQL Server 2008 Administration » Cannot Generate SSPI Context Cannot Generate SSPI Context Rate Topic Display Mode Topic Options Author Message sql server developersql server developer Posted Monday, March 12, 2012 11:12 AM SSC-Enthusiastic Group: General Forum Members Last Login: Thursday, January 14, 2016 10:18 AM Points: 158, Visits: 469 Hi,I'm receiving the below error when trying to connect to SQL Server 2008 R2 from a remote computer on the network using windows authentication. But i was able to connect with SQL Server authentication."Cannot Generate SSPI Context"Thanks, Post #1265396 Roy ErnestRoy Ernest Posted Monday, March 12, 2012 1:57 PM SSCrazy Group: General Forum Members Last Login: Yesterday @ 11:55 AM Points: 2,381, Visits: 6,849 The MSDN website has a step by step procedure to trouble shoot this. Take a look at this URL. -Roy Post #1265543 sql server developersql server developer Posted Monday, March 12, 2012 2:31 PM SSC-Enthusiastic Group: General Forum Members Last Login: Thursday, January 14, 2016 10:18 AM Points: 158, Visits: 469 Thanks Roy! The following fixed the issue.1. Switched the sqlserver service logon account to ‘Local System’2. Rebooted the server3. Switched the sqlserver service logon account to ‘Domain/Account’ 4. Rebooted the server Post #1265565 anthony.greenanthony.green Posted Tuesday, March 13, 2012 2:28 AM SSCertifiable Group: General Forum Members Last Login: Thursday, September 1, 2016 2:56 AM Points: 5,969, Visits: 6,067 I've also seen this also happens when SQL starts before AD.In an old job, the AD servers took ages to come up after testing a scheduled power outage, say they took 10 minutes to boot, but SQL only took 5 minutes, just a simple restart of the SQL services resolved it for us once AD was back up and running, just incase you ever run into something like this. Want an answer fast? Try hereHow to post data/code for the best help - Jeff ModenWhen a question, really isn't a question - Jeff SmithNeed a string splitter, try this - Jeff ModenHow to post performance problems - Gail ShawCrossTabs-Part1 & Part2 - Jeff ModenSQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola HallengrenManaging Transaction Logs - Gail ShawTroubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger Post #1265736 sql server developersql server developer Posted Tuesday, March 13, 2012 7:29 PM SSC-Enthu