Unanswered: Timeout when attempting to view DB List
I am having an issue with Enterprise Manager hanging when I attempt to view the list of databases. Also, Query Analyzer returns "[Microsoft][ODBC SQL Server Driver]Timeout expired" when I attempt to bring up the object browser.
I am able to connect through my application via ODBC, but if I attempt to create a new DSN using the SQL Server native driver, the process will hang after I enter my userID and password and click 'Next'. (In other words, when it is going to the database listing page.)
I also checked and the server shows up when I run OSQL -L, and I can query the databases via OSQL and Query Analyzer.
I bounced the server, but it did nothing for me.
Any ideas? What might I be able to look at to determine what the problem may be?
SQL 2000 Standard on Windows 2000 Server SP4.
SQL Server is upgraded to SP3 with what I believe to be the latest HotFix. (@@version = 8.00.818)
The only major change as of late has been the removal of several databases that were no longer needed.
There are 78 Databases on the server, but I have had this server as high as 90 databases and still been able to view the database list.
Sounds like a network connectivity issue. Did you try terminal servicing to the server and then trying it? You can check the sql error logs to see if there's anything more specific there. Unless, you have this problem after you've upgraded it to .818, then maybe it's an upgrade issue and you'll have to look in microsoft knowledge base.
Hmm... the only other thing I can think of is to detach a few dbs (the bigger ones) and try again... attach one at a time to see if there's a particular db that is causing the problem. I can't think why deleting a few db's will cause this error. You could also try increasing the query & login timeout periods on the server...