20

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?

Improve this question
3
  • 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
    Commented Sep 17, 2012 at 16:18
  • @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
    Commented Sep 17, 2012 at 16:34
  • Can you just paste the connection string?
    – Kundan Singh Chouhan
    Commented Sep 17, 2012 at 16:36

1 Answer 1

Reset to default
47

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"

Improve this answer
5
  • Ah, this is really the trick. Why does it require double \\? really strange .. Thanks! it worked.
    – Varun K
    Commented Sep 17, 2012 at 17:01
  • 1
    it seems \v is a special character!
    – Varun K
    Commented Sep 17, 2012 at 17:07
  • 5
    Exactly! Without the double-escape the \v is considered a single (and special) character. You could also use @ (in C#) to avoid escaping whatsoever, I had updated my answer to reflect it.
    – Krzysztof Kozielczyk
    Commented Sep 17, 2012 at 19:34
  • 1
    Also, it should be noted the escape character will prevent SSMS from making the connection to LocalDb.
    – Andrew Laughlin
    Commented Jun 5, 2017 at 17:52
  • @J.AndrewLaughlin Exactly! Just use the @ to disable escaping and make copy-pasting involve less thought :D
    – DrCopyPaste
    Commented Jun 23, 2017 at 13:58

Not the answer you're looking for? Browse other questions tagged or ask your own question.