CODEWITHSUNDEEP
c#sql-serverado.net.net-4.5localdb
Varun K
Varun K

Reputation: 3638

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?

Upvotes: 20

Views: 59609

Answers (1)

Krzysztof Kozielczyk
Krzysztof Kozielczyk

Reputation: 5937

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"

Upvotes: 47

Related Questions