Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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?

like image 525
Varun K Avatar asked Sep 17 '12 16:09

Varun K


People also ask

Can I use LocalDB in production?

LocalDB is absolutely supported in production. From the performance point of view it is identical to SQL Server Express, as they share the same database engine.


1 Answers

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"

like image 181
Krzysztof Kozielczyk Avatar answered Oct 22 '22 09:10

Krzysztof Kozielczyk