Query Analyzer doesn''t list any databases

Question

Query Analyzer doesn''t list any databases

Gerald Crockett

SSC Rookie

Points: 29
More actions
September 17, 2007 at 4:01 am

#180842

When I start up Query Analyzer, I get an error - [Microsoft][ODBC SQL Server Driver][SQL Server]Lock request timeout period exceeded. I click Ok, but then in the object browser I no longer have a list of databases on the server. Also, the drop-down list of databases on the toolbar no longer shows a listing. Everything else seems to still work ok, but a few of our testers have complained saying they can't easily debug stored procedures as they are gone from the object browser.
Does anyone have any idea on what I can do to resolve this?
Thanks,
Gerald

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Ian Yates SSCoach Points: 19738 More actions · Answer 1

You might have some databases on which SQL Server is trying to perform recovery steps - the list of databases is being delayed (and thus timing out) because of this.

Do all users of SQL Server (eg administrators) have this problem?

Have you tried running SQL Profiler when this problem occurs to see if there's a particular SQL statement being executed by QA that's timing out?

If you click on the server in the tree and hit F5 to refresh it's databases, etc, do you get the timeout again or does it work?

Gerald Crockett SSC Rookie Points: 29 More actions · Answer 2

Thanks for the reply... The problem is experienced by anyone trying to connect to the server using QA. I've run SQL Profiler when it happens but nothing is timing out. The time between initiating a connection to the server and getting the timeout message is only a second or two, so there isn't even a delay. Also, when I try and refresh the list I get the timeout message again.

There is one development, though. Sometimes when I open QA I get the list of databases show in the object browser, even though I still get the timeout message. But if I try and use the database drop-down menu on the toolbar I get nothing, it is blank. If I then refresh thh object browser, the timeout message pops up and the list of databases disappears.

Norene Malaney SSCommitted Points: 1896 More actions · Answer 3

Is there something wrong with the database that is assigned as the "default database" assigned to the user that you are logging into Query Analyzer?

Have a good day,

Norene Malaney

Gerald Crockett SSC Rookie Points: 29 More actions · Answer 4

I can't find any problems with any of the databases. The issue was occurring for any user opening Query Analyzer. I have managed to get around the problem by rebooting the server, but it would be good to know what caused the problem as I can't be rebooting the server too often. Hopefully it was just a temporary glitch...