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?
|
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.
|