Unable to connect to localDB in VS2012 – “A network-related or instance-specific error occurred while establishing a connection to SQL Server…”

18
votes

This is strange as I'm able to connect to localDB through SSMS 2008R2 with the same connection string ("Data Source=(LocalDB)\v11.0;Integrated Security=true")

Only C# code is unable to connect, I have tried increasing login time with Connect Timeout=60 but no luck.

I have also tried specifying the database Initial Catalog=&lt;databasename&gt; where the <databasename> is the one I have created on localdb via ssms.

Any pointers as to why is this not connecting?

1
c#sql-serverado.net.net-4.5localdb
First connect your database through sever explorer in VS. After success of connection right click and find the property. There you will get the connection string. Just copy it and paste in the web.config. – Kundan Singh Chouhan
@Kundan I did that but it threw the same error. Server explorer connected successfully, then I copied the connection string from properties as mentioned, but my app still couldn't connect using the same string. – Varun K
Can you just paste the connection string? – Kundan Singh Chouhan

1 Answers

43
votes

Any chance it is because you forgot to double-escape the backslash? Did you try this:

"Data Source=(LocalDB)\\v11.0;Integrated Security=true"

Or even better, you could just use the @ mark to disable character escaping for the entire connection string:

@"Data Source=(LocalDB)\v11.0;Integrated Security=true"