Cannot generate SSPI context

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Cannot generate SSPI context

Cannot generate SSPI context

Rate Topic

Display Mode

Topic Options

Author

Message

Raghavender

Posted Thursday, July 17, 2008 1:36 PM

Right there with Babe

Group: General Forum Members
Last Login: Monday, March 25, 2013 1:18 AM
Points: 718, Visits: 831

Hi All,

When I tried to connect my SQL Server Enterprise Manager, it is giving error "Could not connect to SQL Server"
Reason: Cannot generate SSPI context

I am using windows authentication.

but when I tried to connect using Sa it is not giving any error and I can connect to the EM successfully.

Please help me regarding this

Thanks in advance

Raghavender Chavva

Thanks and Regards!!

Raghavender Chavva

Post #536283

MannySingh

Posted Thursday, July 17, 2008 2:06 PM

SSChasing Mays

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 1:10 PM
Points: 646, Visits: 729

In the "connect to Server" Dialog Box Click on Options and choose "Named Pipes" from Network Protocols.. click connect.
This is using Windows Authen.
Try this

Maninder
www.dbanation.com

Post #536299

Raghavender

Posted Thursday, July 17, 2008 2:22 PM

Right there with Babe

Group: General Forum Members
Last Login: Monday, March 25, 2013 1:18 AM
Points: 718, Visits: 831

Sorry,

I can't understand you ?

can you please brief it ?

my sql server is named instance which is in my local system only, when I tried to expand the instance the error generated, it is ok till today morning, dont know what happened in between.

Thanks and Regards!!

Raghavender Chavva

Post #536316

Jeffrey Williams 3188

Posted Thursday, July 17, 2008 2:51 PM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Friday, May 17, 2013 11:21 AM
Points: 4,317, Visits: 9,216

First thing you need to do is check the SPN record for that instance of SQL Server. If you do not have access to this, talk to the network folks and have them find the offending SPN record.

If the SPN record is tied to a different account from the account running that instance of SQL Server, then you need to remove the wrong SPN record and add it back in for the correct user.

You can review the following articles for more information:

http://www.sqlservercentral.com/articles/Installation/cannotgeneratesspicontext/929/
http://support.microsoft.com/default.aspx?scid=kb;en-us;811889

Jeffrey Williams
Problems are opportunites brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs

Post #536331

MannySingh

Posted Thursday, July 17, 2008 3:12 PM

SSChasing Mays

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 1:10 PM
Points: 646, Visits: 729

When you try to connect to a SQL Server using SQL Server Management Studio, you get a connect to server window.
In that window there is another button on the Bottom right "options" Click on that and then use Named Pipes Protocol from the Network Prototol Drop Down List.

Maninder
www.dbanation.com

Post #536345

Raghavender

Posted Thursday, July 17, 2008 4:44 PM

Right there with Babe

Group: General Forum Members
Last Login: Monday, March 25, 2013 1:18 AM
Points: 718, Visits: 831

I am using SQL Server 2000 not 2005

Thanks and Regards!!

Raghavender Chavva

Post #536382

The CosmicTrickster

Posted Thursday, July 17, 2008 9:30 PM

SSCrazy

Group: General Forum Members
Last Login: Today @ 2:06 PM
Points: 2,605, Visits: 758

Raghavender (7/17/2008)

I am using SQL Server 2000 not 2005

Then you have posted in the wrong forum. You should have posted here:
http://www.sqlservercentral.com/Forums/Forum5-1.aspx

I would look at the SPN, as mentioned above. If it's not there, get it created.

Scott Duncan

MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare

Post #536431

vidhya sagar

Posted Thursday, July 17, 2008 11:36 PM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, March 19, 2013 2:45 AM
Points: 416, Visits: 521

I agree with Jeffery :).. Setting SPN will solve the problem, coz the connection will use Kerberos authentication.

Regards..Vidhya Sagar
SQL-Articles

Post #536465

« Prev Topic | Next Topic »

Permissions