February 25, 2003 at 10:38 am
I installed SP 3 on a SQL 2000 machine. Now when I try to connect to that server using NT authenication through ODBC I get the HY000 (S1000) Error: Cannot generate SSPI context. SP 3 install MDAC 2.7, so I installed MDAC 2.7 on my client machine, but I still get the error.
Any ideas?
February 25, 2003 at 11:53 am
Tried rebooting the client? Does it work ok with sql login?
Andy
February 25, 2003 at 12:01 pm
It does work with a SQL login. A reboot didn't help.
February 25, 2003 at 12:52 pm
Can you check whether connections over named pipes is succeed and see if there are name resolution issues?
February 25, 2003 at 1:05 pm
I changed the client configuration to use Named Pipes instead of TCP/IP and it goes through. I will have to see if that works for the end user.
February 25, 2003 at 1:21 pm
What type service account does your SQL Server run? Are you using Windows 2000 Active directory?
February 27, 2003 at 1:31 am
hi,
install "Client network utility" on all client machines ...
and enable "Named Pipes" and "TCP/IP"
and see ...
if not work .. change user account passwords(or sa passwords)on SQL to the same password
if not work change protocol on connect to server to "Named Pipes" instead of "TCP/IP"
hope this help u
bye
Alamir Mohamed
Alamir Mohamed
Alamir_mohamed@yahoo.com
February 27, 2003 at 6:53 am
I used to do this as well (install Client Config Utility only from SQL Server). However, a client (of all people) showed me that the very same could be done by running cliconfg.exe from Start / Run. Cliconfg.exe comes with MDAC ( and is updated in MDAC 2.7 SP1).
February 27, 2003 at 7:41 am
We are using a Windows 2000 Active Directroy login for the service account and user accounts.
Using Named Pipes the end user can connnect fine.
Thanks for your help.
February 27, 2003 at 8:58 am
Check this article. It is quite useful.
http://www.sqlservercentral.com/columnists/cmiller/cannotgeneratesspicontext.asp
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply