Communications link failure #0

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Scott McDonald (sdgmcdon_at_yahoo.com)
Date: 03/01/05 

Date: Mon, 28 Feb 2005 18:04:53 -0800

We are intermittently getting this error on our SQL server. The front end is
access and this happens every so often causing the users to have to exit out
of access and reconnect. I'm by no means a SQL expert, and our programmer
who manages this database isn't sure what it is either, he says it's like
the server is just "forgetting his password" and dumping the ODBC
connection...

Any ideas/help would be appreciated.

Thanks!

Scott

Relevant Pages

  • RE: sql server traffic shut down internet
    ... Have you tried Profiler to see what SQL Server is doing? ... what is NOT causing the problems. ... user base. ... Once all users were inputing data, ...
    (microsoft.public.sqlserver.server)
  • Re: generating sql scripts of stored procedures
    ... What could be causing this ... > Whenever I build a new stored procedure into my database I specifically ... > at the end of the script. ... All my settings in sql server and database ...
    (microsoft.public.sqlserver.programming)
  • Re: The SQL Server cannot obtain a LOCK resource
    ... What I did after running it several times was ro reboot the subscriber. ... It seems that there were several tasks that were causing the problem. ... >> The SQL Server cannot obtain a LOCK resource at this time. ... >> to check the SQL Server lock and memory configuration. ...
    (microsoft.public.sqlserver.replication)
  • Weird Locking Issue
    ... I develop on an Access Database that is a Front End to SQL Server. ... our customers are starting to have weird locking problems. ... seeming passthru queries are causing Table Locks. ...
    (microsoft.public.sqlserver.connect)
  • Weird Locking Issue
    ... I develop on an Access Database that is a Front End to SQL Server. ... our customers are starting to have weird locking problems. ... seeming passthru queries are causing Table Locks. ...
    (microsoft.public.sqlserver.server)