myLittleTools Community Forum

Welcome Guest Search | Active Topics | Members | Log In | Register

"Timeout expired' error connecting to database Options · View
dj
Posted: Friday, April 11, 2008 7:49:24 PM

Rank: Newbie
Groups: Member

Joined: 4/11/2008
Posts: 1
Points: 0
Location: Boston, MA
When attempting to connect to a database (dsn-less), the connection times out with a "Timeout Expired" error. Included in the error message is the query "Select name from master.dbo.sysdatabases where has_dbaccess(name)=1 AND name NOT IN ('master', 'tempdb', 'msdb', 'model') ORDER BY NAME"
This would normally produce a list of all the databases hosted on the SQL Server, but isn't what I would expect when attempting to connect to a single database.
Most of the time if I click the OK button below the error, try to connect again, it's successful.

I've tested with some other databases, and it happens with some of the others as well, but not all.

ideas?

elian
Posted: Friday, April 11, 2008 8:23:10 PM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
This happens when the count of dbs on the server is very high. The query to retrieve the db list times out.

A patch is available so that the user has the ability to enter the name of the db he wants to manage in the login page.

Send us an email at support@mylittletools.net with your order number so that we can send you this patch.
Users browsing this topic
Guest


You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Main Forum RSS : RSS

Theme created by myLittleTools
Powered by Yet Another Forum.net version 1.9.1.8 (NET v2.0) - 3/29/2008
Copyright © 2003-2008 Yet Another Forum.net. All rights reserved.