Has anyone had this problem? We run Windows Server 2003 with SQL 2000 in a mixed Windows 2000 and XP environment. If the users do not use there front end access for sometime they drop out of the sql session and have to reboot. We are using named pipes but t5he error message shows as
Microsoft SQL Login
Connection Failed
Sql State: 'S1000'
SQL Server Error: 0
[Microsoft][ODBC SQL Server Driver]Cannot generate SSPI Context