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: 256

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