Showing posts with label sspi. Show all posts
Showing posts with label sspi. Show all posts

Wednesday, March 7, 2012

ODBC SQL Server driver-Canot generate SSPl context

Dear all,

I am getting the message "Canot generate SSPI context",while i am working in a client system.I hope this is something related to networking.How to solve the problem.I can not connect to SQL Server once i got above mentioned message.

Please give your advice to understand and rectify the problem.

regards
Gracesoncheck this link here (http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B267588)|||make sure your NT account has a windows auth login to the SQL Server.|||Check out KB811889
http://support.microsoft.com/default.aspx?scid=kb;EN-US;811889

ODBC SQL Server Driver

Good Afternoon,
I had a mistake when I tried to connect to query analyser with an NT authentication, the message was: "Cannot generate SSPI context." I tried to connect to another machine, and it's been connected.
Can anyone help me?
Thanks.
ConceioWhich version of sql server are you using (including service pack) ?|||Originally posted by rnealejr
Which version of sql server are you using (including service pack) ?

Our SGBD is SQL Server 2000, service pack 2.|||Check your services for the following and verify that it is running (on the client attempting to make the connection) -

NT LM Security Support Provider