Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

When I try to create a new database connection, the Data Sources (ODBC) programs hangs or takes a very long time to find the list of available SQL Servers.

This only happens when there are other computers on the network, when my machine (a standard Windows 7 laptop) is alone, it works just fine.

ODBC Window - hangs when I try to select SQL Server

My question is: What should I look for in terms of SQL server or ODBC configurations that will take away this random behaviour?

share|improve this question
up vote 1 down vote accepted

It's not direct answer to your question, but in Server field you can write in ServerAddress or ServerAddress\InstanceName:

write address

So when you know this value don't do server discovery (expand the list). List all Sql Servers in (large) network usually takes long time.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .