Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Cannot generate SSPI context


Cannot generate SSPI context

Author
Message
Raghavender
Raghavender
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1024 Visits: 1201
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
MannySingh
MannySingh
SSChasing Mays
SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)

Group: General Forum Members
Points: 649 Visits: 776
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
Raghavender
Raghavender
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1024 Visits: 1201
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
Jeffrey Williams 3188
Jeffrey Williams 3188
SSCarpal Tunnel
SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)

Group: General Forum Members
Points: 4461 Visits: 9829
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 opportunities brilliantly disguised as insurmountable obstacles.

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

MannySingh
MannySingh
SSChasing Mays
SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)SSChasing Mays (649 reputation)

Group: General Forum Members
Points: 649 Visits: 776
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
Raghavender
Raghavender
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1024 Visits: 1201
I am using SQL Server 2000 not 2005

Thanks and Regards!!

Raghavender Chavva
thecosmictrickster@gmail.com
thecosmictrickster@gmail.com
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3336 Visits: 932
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

vidhya sagar
vidhya sagar
SSC-Addicted
SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)SSC-Addicted (418 reputation)

Group: General Forum Members
Points: 418 Visits: 620
I agree with Jeffery Smile.. Setting SPN will solve the problem, coz the connection will use Kerberos authentication.

Regards..Vidhya Sagar
SQL-Articles
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search