SQL Server 2000 error message

By cathytbz ·
The company has a accounting software - Exact Globe that works with SQL 2000. Thre are 10 users of whicj 2 users keep on loosing connection to the SQL server after 5 minutes of not working on the program. Sometimes while they are working this also happens. The users then need to shut down their PC's as the program then terminates and if they try to logon again without restarting the PC a message " logon failed" appears.
The message that is giving me problems is displayed as follows:

[Microsoft][ODBC SQL Server Driver] Cannot generate SSPI context
SQL State: S1000
DB error 1364
EDL Error: An error has occurred in the execution of the ODBC function.

I have made sure that 'named pipes' and TCP/IP settings are enabled as well as 'force protocol' When this did not work I removed TCP/IP and only worked with 'named pipes'and visa verse. However this did not fix the problem. I then created and DB alias, but even this does not work. All the other workstation don't have this problem. Please could someone assist.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Have a look at a working and a none working client

by Tony Hopkinson In reply to SQL Server 2000 error mes ...

Check versions out for the SQL ODBC driver and MDAC, etc.

Are these two PCs getting to the server on a different network route.

Does it say anything in the SQL server's log file?

Short of this obvious stuff , you may find this useful.

Collapse -


by mbarry1977 In reply to SQL Server 2000 error mes ...

Maybe SQLSERVER Was Lock The User Check Current Activity And See Lock Object See If the User Was Appear Then Kill Process

Related Discussions

Related Forums