Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

This seemed to have happened after a server restart and a server restart seems to temporarily solve the problem. Everyone's database does not crash at the same time. Mine may be working while someone elses is down. When it is down a test run from SQL in ODBC fails. I am not very familiar with SQL, but the error logs look fine. There is a Peachtree database on the same server. It was having an issue as well that was solved by adding the server to the hosts file. I'm not sure if the problems are directly related. Thank you.

Server 2003 with SQL 2000 Windows 7 workstations, but is happening on a Vista Machine Database is Access based. We are using Access 2007 and 2010.

share|improve this question
1  
os and sql versions info would be helpful. –  tony roth Jan 13 '12 at 16:45
    
...you mean that you have several databases on the one server, and you're having problems where individual databases act up, not the actual database server...but restarting the server fixes it? –  Bart Silverstrim Jan 13 '12 at 16:54
    
SQL 2000 on Server 2003, windows 7 workstation, Database is based on Access. SQL seems to be running fine on the server. It seems like something is interfering with that data once it leaves SQL (I don't see any errors), yet before it gets to the workstation datbase(ODBC test fails). I tried turning off firewalls and antivirus. Both Peachtree pervasive and sql are on this server. Pervasive may have crashed because peachtree was open during the restart. I'm not sure if tehy are related. Thanks. –  steve Jan 13 '12 at 17:03
    
Note, it happens if the database is being used or if it is idle. When it works, it is definately slower than normal. –  steve Jan 13 '12 at 17:13

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.