.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Here we go, "Cannot generate SSPI Context"

Posted By:      Posted Date: September 13, 2010    Points: 0   Category :Sql Server
When trying to register a SQL Server in my SSMS on my desktop, I get the error.  My AD account is in the SQL Server as sysadmin.  When I go to the box, I can connect from SSMS with my AD account.  I dont see how its DNS, cause I can ping it by name from my desktop.  Any other ideas? remote connections are allowed enabled TCP/IP and Named Pipes In the server Event Viewer>Security, I get Failure Audit, user: system, Reason: Unknown user name or bad password BUT, I also get a Success Audit with my domain account.  

View Complete Post

More Related Resource Links

Cannot Generate SSPI context, strange?

I recently put into affect some applications for data entry and searches connecting to a SQL 2008 database. When a user logs in and starts the application they are able to enter data. The data save to the database fine, then randomly we get crashes saying: "Unhandeled exception while running screen" its a SSPI error.... strangley enough if i log out and log back in, it again allows the program to enter into the database.... but surely enough after a few entries it gives me the error again. We are a small company, and the server we run AD on is pretty slugish, so loging out and back in... can to say the least take some time. This makes our productivity alot lower. If anyone has a fix or has any suggestions id gladly take them. Both Servers we use have Server 2008R2.

Cannot generate SSPI context. (.Net SqlClient Data Provider)


I have upgraded SQL SERVER 2000 standard edition server to SQL server 2008 with SP1 standard edition. No errors noticed. OS is Windows server 2003 with sp2, Service accounts are configured using domain user account, and mixed mode authentication is enabled.

Both windows and SQL authentications are working fine from the local (server), able to access all SQL server resources.

Server is accessible remotely using SQL authentication, but unable to connect with windows authentication, though user has local admin and SQL admin rights on the server.

Let me know any solutions for this. Appreciate your support

cannot generate sspi context


when connect to SQL 2000 sp3 on windows 2003 sp2 from SSMS 2008, get "cannot generate sspi context", but can connect to other SQL2000 server instances.

this one uses Windows authentication only, and I am using windows authentication to connect.

Cannot Generate SSPI Context Error - SQL 2000


Hi, We are still on SQL Server 2000 and just changed our internet provider which also changed some DNS' internally. We have Microsoft Access programs that connect to our local SQL Server to operate. The server we are trying to connect to is on the local network. I am constantly getting "Cannot Generate SSPI Context" errors and any of the fixes I find are completely greek to me. Some help would be much appreciated.


Thank You Very Much.

Error " cannot generate SSPI Context Sql Server Network interfaces"


Hi all,

I am getting an error while creating OLEDB connection in SSIS Package as following

test connection failed because of an error in initializing provider.Cannot generate SSPI context Sql server network interfaces: the local security authority cannot be contacted.

I have SQL server 2008 R2 version running on local server. I am able to connect to the SQL server using Windows authentication. But when i try to create OLEDB connection in SSIS package i am getting above error.

SQL Browser is running.

I have even checked SQL server configuration and Named pipes are enabled. But still i am getting the same error.

Any idea where to look would be of great help?



ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend