Avoiding connection timeouts on first connection to LocalDB edition of SQL Server Express
Posted
by Greg Low
on SQL Blog
See other posts from SQL Blog
or by Greg Low
Published on Wed, 30 Nov 2011 02:52:00 GMT
Indexed on
2011/11/30
10:20 UTC
Read the original article
Hit count: 297
Filed under:
When you first make a connection to the new LocalDB edition of SQL Server Express, the system files, etc. that are required for a new version are spun up. (The system files such as the master database files, etc. end up in C:\Users\<username>\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\LocalDBApp1) That can take a while on a slower machine, so this means that the default connection timeout of 30 seconds (in most client libraries) could be exceeded. To avoid this hit on the...(read more)
© SQL Blog or respective owner