Post reply

HY0000 & S1000 Errors in ODBC after SP 3 Install

  • February 25, 2003 at 10:38 am

    #101393

    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

    #449720

    Tried rebooting the client? Does it work ok with sql login?

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

    Andy
    Connect with me on LinkedIn

  • February 25, 2003 at 12:01 pm

    #449722

    It does work with a SQL login. A reboot didn't help.

  • February 25, 2003 at 12:52 pm

    #449732

    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

    #449738

    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

    #449743

    What type service account does your SQL Server run? Are you using Windows 2000 Active directory?

  • February 27, 2003 at 1:31 am

    #449844

    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@yahoo.com

    Alamir Mohamed


    Alamir Mohamed
    Alamir_mohamed@yahoo.com

  • February 27, 2003 at 6:53 am

    #449879

    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

    #449893

    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

    #449926

    Check this article. It is quite useful.

    http://www.sqlservercentral.com/columnists/cmiller/cannotgeneratesspicontext.asp

Viewing 10 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply