“Cannot Generate SSPI Context” error message, more comments for SQL Server

Kerberos Delegation with SQL Server Reporting Services and SQL Server

Brian Kelley — Wed, 05 Apr 2006 22:52:40 GMT

I've been dealing with Kerberos delegation setup with respect to
Microsoft's CRM 3.0 product and while...

“Cannot generate SSPI context” error message, when connect to local SQL Server outside domain

SQL Protocols — Wed, 10 May 2006 02:15:51 GMT

The “Cannot generate SSPI context” issue is described by http://support.microsoft.com/?id=811889 in general....

re: “Cannot Generate SSPI Context” error message, more comments for SQL Server

udit b halla — Sat, 27 May 2006 22:39:38 GMT

I had an accidental shut down of my system.
(my sql server and client are on the same machine).
Due to which i m unable to connect to the sql server.
it is showing me the "cannot generate sspi context" message.
please help.

thanks

re: “Cannot Generate SSPI Context” error message, more comments for SQL Server

Matt Neerincx [MSFT] — Sun, 28 May 2006 20:06:45 GMT

Key things I would do is download the setspn tool from link above. Insure your SQL Server service is started. Next try to delete all the SPNs you see for this instance of SQL using the setspn tool (read KB article 811889 to determine how to do this). If you cannot delete the SPNs, then the SPNs are assigned to some domain user account and you need a domain administrator to delete it. Delete all SPNs for the SQL Server instance, then stop and restart SQL. Next, use the setspn tool to see if the SPN is re-created. If the SPN is recreated, then everything should work fine at this point. If the SPN is not created at this point, you will need to contact the domain admin and have him or her create the SPN under the account that the SQL Server service is running under.

re: “Cannot Generate SSPI Context” error message, more comments for SQL Server

Mahesh Manik — Wed, 07 Jun 2006 16:37:44 GMT

I have a saparate test machine to test the new
updation for my programmes.Therefore i have the client and server on the same machine and it was working fine till yesterday.Suddenly i got the above message "Cannot generate SSPI Context" error message when i expanded my local server.

re: “Cannot Generate SSPI Context” error message, more comments for SQL Server

SQL Protocols — Thu, 08 Jun 2006 05:44:32 GMT

Hi, Mahesh

Can you describe more specifically about your problem?

Try the solution that Matt Neerincx suggested above.

Thanks!
Ming.

re: “Cannot Generate SSPI Context” error message, more comments for SQL Server

elf — Mon, 20 Nov 2006 13:37:09 GMT

Hy,

i have the same problem and in my case the probelm was the antivirus (Trend Micro - OfficeScan). I desable the antivirus firewall and it works perfectly.

PS.

Sorry for my english.

Understanding Kerberos and NTLM authentication in SQL Server Connections

SQL Protocols — Sun, 03 Dec 2006 11:59:27 GMT

In this post, I focus on how NTLM and Kerberos are applied when connecting to SQL Server 2005 and try

"Cannot Generate SSPI Context" error message, Poisoned DNS

SQL Protocols — Tue, 02 Jan 2007 11:18:27 GMT

Incorrect DNS can lead to various network connectivity issues. In this post, I explain how it affects

re: “Cannot Generate SSPI Context” error message 0x80004005.

jamshad — Wed, 10 Jan 2007 09:46:20 GMT

how come i resolve thiz Problem in SQL 2000 ON XP MACHINES......

Error message......0x80004005.

Description..........Can't generate SSPI CONTEX......

re: “Cannot Generate SSPI Context” error message, more comments for SQL Server

RichardB — Fri, 09 Mar 2007 23:45:31 GMT

Got the same message with my local server when logging in with my windows account(admin on the machine). I finally simply logged in as "sa", then exited cleanly. It did it. Everything is fine now.

Sample searching query in MS-Sql Server

Billy — Fri, 13 Apr 2007 08:32:33 GMT

//Create Procedure for searching data's

create proc batchShip_Search(@bId int,@dtFrom datetime,@dtTo datetime)

as begin

if(@bId=' ' and @dtFrom=' ' and @dtTo!=' ') begin

select bId,custName,dt from batchShip1 where dt<=@dtTo order by dt end

else

if(@bId=' ' and @dtFrom!=' ' and @dtTo=' ') begin

select bId,custName,dt from batchShip1 where dt>=@dtFrom order by dt end

else

if(@bId=' ' and @dtFrom!=' ' and @dtTo!=' ') begin

select bId,custName,dt from batchShip1 where dt>=@dtFrom and dt<=@dtTo order by dt end

else

if(@bId!=' ' and @dtFrom=' ' and @dtTo=' ') begin

select bId,custName,dt from batchShip1 where bId=@bId order by bId end

else

if(@bId!=' ' and @dtFrom=' ' and @dtTo!=' ') begin

select bId,custName,dt from batchShip1 where bId=@bId and dt<=@dtTo order by bId end

else

if(@bId!=' ' and @dtFrom!=' ' and @dtTo=' ') begin

select bId,custName,dt from batchShip1 where bId=@bId and dt>=@dtFrom order by dt end

else

if(@bId!=' ' and @dtFrom!=' ' and @dtTo!=' ') begin

select bId,custName,dt from batchShip1 where bId=@bId and dt>=@dtFrom and dt<=@dtTo order by dt end

end

//Given data's which is searching

batchShip_Search '1','2007-12-01','2007-12-30'

re: “Cannot Generate SSPI Context” error message, more comments for SQL Server

taz_ues@hotmail.com — Tue, 01 May 2007 02:50:51 GMT

hi i have the same problem but i did everithing that read in google, other idea thanks

re: “Cannot Generate SSPI Context” error message, more comments for SQL Server

atul — Tue, 22 May 2007 11:38:59 GMT

I had an accidental shut down of my system.

(my sql server and client are on the same machine).

Due to which i m unable to connect to the sql server.

it is showing me the "cannot generate sspi context" message.

please help.

re: “Cannot Generate SSPI Context” error message, more comments for SQL Server

SQL Protocols — Tue, 22 May 2007 20:25:46 GMT

Can you check my another post? Your issue could be DNS related.

http://blogs.msdn.com/sql_protocols/archive/2007/01/02/cannot-generate-sspi-context-error-message-poisoned-dns.aspx

re: “Cannot Generate SSPI Context” error message, more comments for SQL Server

Zohaib — Wed, 01 Aug 2007 11:55:49 GMT

Sql works fine on other windows enviroment but it sometimes gives the error on only WinXp machines on my Network. Kindly

re: “Cannot Generate SSPI Context” error message, more comments for SQL Server

Xinwei Hong — Wed, 01 Aug 2007 19:23:55 GMT

Please post a question on our forum: http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=87&SiteID=1

Use the guideline at:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=362498&SiteID=1

Then, we can find out what's the root cause.

re: “Cannot Generate SSPI Context” error message, more comments for SQL Server

Chris — Mon, 14 Jan 2008 22:57:38 GMT

I've been trying to debug this error for days now on my test servers. I have IIS on a webserver, then SQL Server 2005 on a second server. They are not part of a domain and are stand alone servers as these is usual for a web application. Both servers are 2k3.

I have duplicate users on both servers. The servers are directly connected to each other with no AD running. Currently I am testing with them directly connected, but will be placing a firewall between them on the production set up.

Now, if both servers are part of the same domain, this works fine, but who wants a web server in your domain?

As it is extremely unsecure to house a sql server on your web server and not firewall off the sql server, one would think that this type of set up would have been made a little more simple to accomplish.

I'm basically beyond frustrated with this.

I am no longer sure where to start over at. I'd reformat and reinstall both servers if I'd think that that would help, but I don't because it's never worked. LOL

re: “Cannot Generate SSPI Context” error message, more comments for SQL Server

SQL Protocols — Tue, 15 Jan 2008 03:13:51 GMT

Can you please check my other blog and try the step? http://blogs.msdn.com/sql_protocols/archive/2007/05/12/connecting-to-sql-server-from-a-workgroup-using-windows-authentication.aspx

If you have firewall between two machines, you have to open port for NP(SMB, file sharing) and TCP (tcp port, for SQL Auth).

re: “Cannot Generate SSPI Context” error message, more comments for SQL Server

Jeremie — Tue, 01 Apr 2008 17:08:23 GMT

Thanks for the post. It's just to bad this wasn't on the Microsoft posting I found first.

re: “Cannot Generate SSPI Context” error message, more comments for SQL Server

PJ — Fri, 09 May 2008 06:25:15 GMT

I dont want to beat a dead horse with this issue, but I just cant seem to find the answer....

Environment:

Server 2003 SP2 R2 - simple Office 2007 setup with SQL server 2005

Clients - Winxp SP2

When I logon to windows from a client pc - all is well can connect to SQL on the server. 10 to 15 minutes later the connection is dropped, and I get the "Cannot generate SSPI context" (Outlook) or "SQL server does not exist, service has stopped, or Access denied" (Accounting)

I have ensured that SQL service is running and set to auto on server and client pc's

net config server /AUTODISCONNECT:-1

on server and pc's

No firewall's

TCP and namepipes enabled on all

Any help would be appreciated.....

PS. - by default Office 2007 business Contact Manager seems to install the SQL server 2005 on all client pc's .... is that a problem ?

Thanks !

cannot generate sspi context

cannot generate sspi context — Tue, 20 May 2008 16:34:59 GMT

PingBack from http://kimora.freemusiconlineindia.info/cannotgeneratesspicontext.html

re: “Cannot Generate SSPI Context” error message, more comments for SQL Server

Karim — Thu, 05 Jun 2008 21:47:21 GMT

I was about to reinstall SQL Server on my server.

This article saved us hours of extra work.

Thanks

Here are the steps I took for our server (SQL server 2005 x64 bit SP2; OS: Windows 2003 x64 bit)

1. Shut down sqlserver service.

2. Switch the sqlserver service logon account to ’Local System’

3. Start up sql server service

4. Checked connection to sql server from my workstation (worked)

5. Shutdown sqlserver service

6. set SQLserver and sqlagent services to manual

7. Switch the sqlserver service logon account to ‘domain/loginid’ (DO NOT START THE SERVICE)

8. Rebooted the server

9. Started SQL service manually

10. Checked connection to sql server from my workstation (worked)

11. Switched SQL Server and SQL Agent services to automatic.

re: “Cannot Generate SSPI Context” error message, more comments for SQL Server

madhuri — Tue, 15 Jul 2008 09:23:45 GMT

hi all,

I got the same problem "Cannot Generate SSPI Context" when I was trying to run the application. This problem araised when the managment studio was newly installed in my system . so I tried to connect our server to the new management studio and now it is working fine :).

Thank you

madhuri

SSPI Error | keyongtech

SSPI Error | keyongtech — Thu, 22 Jan 2009 09:18:33 GMT

PingBack from http://www.keyongtech.com/2860107-sspi-error