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

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

cannot generate sspi context

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :Sql Server

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.

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.

Here we go, "Cannot generate SSPI Context"

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.  

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 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?



Creating Sites/Lists/List Items under Current User Context in SharePoint By Using SPUserToken

Usually we do this by performing the action under RunWithElevatedPrivileges method and updating the listitem using SPListItem.SystemUpdate() method (see here). but this approach has its own flaws like (RunWithElevatedPrivileges will run under system account, we cannot use SystemUpdate for SPSite,SPWeb,SPList, since it runs under system we will "CreatedBy" by as SystemAccount).

Generate thumbnails on the fly

There are many posts how to generate thumbnails using ASP.NET. Some good some less. Be sure to get distance from the versions that use Image.GetThumbnailImage method.

Generate Random Numbers

SQL Server has a built-in function that generates a random number, the RAND() mathematical function. The RAND math function returns a random float value from 0 through 1.

Generate rss feed with HTTPHandler





I'm looking for link/tutorials/code samples on How to create HttpHandler for generating rss feeds for a website.




ASP.NET Designer - How Do I generate this Design-Time Markup?


I want to generate this:
    <x:MyControl id="a" runat="server">
            <x:MyScript .. />

WCF The Security Support Provider Interface (SSPI) negotiation failed


I am using a wcf service that I created, when both hosting machine and the client machine are on the same domain everything works just fine. When I publish the client app to the webserver in the DMZ I am getting the following error:

SOAP security negotiation with '' for   
'' failed. See inner exception  
for more details.The Security Support Provider Interface (SSPI) negotiation failed.

Here is my service main where I set up the service


 Uri baseAddress = new Uri("Http://");
      ServiceHost selfHost = new ServiceHost(typeof(QBService), baseAddress);


How to generate large pdf's?


Hi all,

I am using rdlc reports in my appln. Am trying to generate a huge pdf file which almost consists of 1500 - 2000 pages.
I have used ReportViewer and am adding datasource (Generic collection) to report. But am getting system out of Memory exception as it is a huge file.
Can any one suggest me how to generate large pdf files in asp.net c#

Cutting Edge: Context-Sensitive Feedback with AJAX


Beyond progress bars: talking to server-side apps with ASP.NET AJAX.

Dino Esposito

MSDN Magazine July 2007

Cutting Edge: Context-Sensitive PictureBox Controls


Great ideas are timeless. A long time ago in Microsoft Systems Journal Paul DiLascia demonstrated a neat trick to display context-sensitive tooltips floating over pictures. As the user moved the mouse over the picture, the tooltip control updated its text to reflect the name of the pointed figure.

Dino Esposito

MSDN Magazine July 2006

Toolbox: Generate Office Documents, Monitor Event Logs, and More


Most data-driven Web sites are used as interfaces to collect, process, and summarize information. Reports that summarize the data can be presented to the user in a variety of formats-the most common way is to display the report directly in a Web page.

Scott Mitchell

MSDN Magazine June 2006

UI on the Fly: Use the .NET Framework to Generate and Execute Custom Controls at Run Time


Creating UI controls on the fly can be accomplished via run-time code generation. And there are lots of reasons to do so. Generating these controls once and then reusing them as needed is more efficient than generating the controls each time. Read on.

Morgan Skinner

MSDN Magazine December 2005

Stay Alert: Use Managed Code To Generate A Secure Audit Trail


In today's security-conscious environments, a reliable audit trail is a valuable forensic tool The Windows Server 2003 operating system provides features that let you enable a wide range of applications to make use of auditing functionality. This article looks at auditing from the operating system perspective and describes a sample managed code implementation that will allow you to add auditing to your own server applications.

Mark Novak

MSDN Magazine October 2005

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