在 VS2012 中无法连接到 localDB –“与 SQL Server 建立连接时发生与网络相关或特定于实例的错误..." [英] Unable to connect to localDB in VS2012 – "A network-related or instance-specific error occurred while establishing a connection to SQL Server..."

问题描述

这很奇怪，因为我能够通过 SSMS 2008R2 使用相同的连接字符串 ("Data Source=(LocalDB)v11.0;Integrated Security=true") 连接到 localDB

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")

只有 C# 代码无法连接，我尝试使用 Connect Timeout=60 增加登录时间，但没有成功.

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

我还尝试指定数据库 Initial Catalog=<databasename> 其中 <databasename>是我通过 ssms 在 localdb 上创建的.

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

关于为什么不连接的任何指针?

Any pointers as to why is this not connecting?

推荐答案

有没有可能是因为你忘记了双转义反斜杠?你试过这个吗:

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

"数据源=(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"

这篇关于在 VS2012 中无法连接到 localDB –“与 SQL Server 建立连接时发生与网络相关或特定于实例的错误..."的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！