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

c# sql-server ado.net .net-4.5 localdb
Varun K picture Varun K · Sep 17, 2012 · Viewed 47.4k times · Source

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?

Answer

Krzysztof Kozielczyk picture Krzysztof Kozielczyk · Sep 17, 2012

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"

Related questions

Call a stored procedure with parameter in c#

I can do a delete, insert and update in my program and I try to do an insert by call a created stored procedure from my database. This a button insert I make work well. private void btnAdd_Click(object …

Read More
Connection timeout for SQL server

Can I increase the timeout by modifying the connection string in the web.config?

Read More
Calling stored procedure with return value

I am trying to call a stored procedure from my C# windows application. The stored procedure is running on a local instance of SQL Server 2008. I am able to call the stored procedure but I am not able to retrieve …

Read More