Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Posts
    660

    Unanswered: connection failed

    I have a sql server database and access as front end. Everybody except one user works on this database is fine. When this user open the database. It showed error message"
    connection failed: SQLState:'s1000'
    SQL Server Error: 0
    [Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context.

    Actually he worked fine before. Just today, it didn't work.
    Can you help me how to solve this problem?
    Many thanks.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    99% of the time, this is a networking problem, and most of those times it is simply Kerberos ticketing getting itself out-of-whack. I usually just power down the workstation (as in power off, not a Windows restart). Once it comes back up, the problem is usually gone.

    -PatP

  3. #3
    Join Date
    Mar 2004
    Posts
    660
    Thanks. Yes, i think it is network problem. Can you explain to me what you mean power down the workstation. It is not mean restart the server? I did restart the user's computer, but it still didn't work. Thank you.

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I used the term "power down" instead of restart to avoid confusion. Different things happen when a machine (specifically its network interface) powers down (it is turned off, or better yet unplugged) than what happens when Windows is simply restarted. When the machine powers back up and the hardware is re-initialized, that seems to clear most of these problems for me.

    -PatP

  5. #5
    Join Date
    Mar 2004
    Posts
    660
    Thank you very much for your explaination.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •