当我尝试连接SQL Server时，我得到以下错误:
在建立与SQL Server的连接时，发生了与网络相关或特定于实例的错误。未找到服务器或无法访问服务器。验证实例名称是否正确，SQL Server是否配置为允许远程连接。(提供商:Named Pipes提供商，错误:40 -无法打开到SQL Server的连接)
当我试图在Visual Studio 2010中将数据库配置为gridview时抛出此错误。我不知道如何调试这个错误。
如何调试此错误?除了错误消息中提到的步骤之外，我还应该采取哪些步骤来确定这里到底发生了什么?
当前回答
似乎您的localdb实例没有运行。 要在计算机启动时启动它，添加到您的开始菜单\启动文件夹BAT文件与以下行
sqllocaldb start name_of_instance
其中name_of_instance是要启动的localdb实例的名称。 您可以使用sqllocaldb i在命令行中列出可用的实例。
例如，如果您正在使用SQL Server Management Studio并连接到服务器名称(localdb)\v11.0，那么您的BAT文件将如下所示
sqllocaldb start v11.0
其他回答
为什么这个错误是如此烦人和嘈杂，只是因为它可以发生在不同的情况。
我已经做了上面所有的方法，但还是很糟糕。所以，在向下浏览之前，确保你和我做了同样的事情。
也许我不能立即解决你的问题，但我可以给你指明一个方向或思路(最后滑下来的那个人)。我已经开始思考我的运行程序的错误发生后，我确保实例名是明确正确的，并设置我的数据库，以允许远程控制以下的方法。之后，我怀疑我的SQL连接代码片段发生了错误。
我的问题解决方案:
检查我的sqlconnection函数
单击以查看其配置
新建连接
选择你的服务器名
对我来说，思考在联系的过程中到底发生了什么是有效的。希望我的想法能引导你改正错误。
I had the same issue after upgrading my Windows to Windows Pro 10 21H2. I have two SQL instances - 2014 and 2019 and I was not able to connect only to 2019 one. I restarted the computer, restarted all SQL related services. Two of the services were showing errors (SQL Server and SQL Server agent) and I was not able to start them. I could not also start these two services from C:\Windows\SysWOW64\SQLServerManager15.msc In the logs (C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER01\MSSQL\Log) I saw these lines:
Initializing the FallBack certificate failed with error code: 15, state: 29, error number: 0.
Error: 17190, Severity: 16, State: 1.
Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.
Error: 17182, Severity: 16, State: 1.
TDSSNIClient initialization failed with error 0x80092004, status code 0x80. Reason: Unable to initialize SSL support. Cannot find object or property.
Error: 17182, Severity: 16, State: 1.
TDSSNIClient initialization failed with error 0x80092004, status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. Cannot find object or property.
Error: 17826, Severity: 18, State: 3.
Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
Error: 17120, Severity: 16, State: 1.
SQL Server could not spawn FRunCommunicationsManager thread. Check the SQL Server error log and the operating system error log for information about possible related problems.
原来在升级后，服务的“Log On”属性(服务属性上的第二个选项卡)被设置为NT AUTHORITY\NETWORK SERVICES。当我将其更改为“本地系统帐户”时，我能够启动服务并连接到MS SQL 2019实例。
这个msdn论坛的帖子帮助我找到了这个。
I got this error after working at distance (VPN) for a few years. At some point in time I must have changed my DNS settings to the IP address of my home router. Now I was (again) in the same network as the server, and got the error above. the solution was to open "Network status" / "Change adapter options" and right click the active internet connection (Ethernet in my case) to get to the properties of IPv4. Under "Use the following DNS server addresses" I entered the local IP address of my server, and what do you know...! The computer contacted the domain (on the server) and SQL Server opened up.
要检查是否有相同的问题，打开cmd并输入 夜间电报/ dsgetdc:域名 [用域名交换"domainname"] 如果您得到一条消息说“获取DC名称失败:Status = 1355 0x54b ERROR_NO_SUCH_DOMAIN”，您可能是域名错误，或者您可能有这个问题。
我将使用Entity Framework的项目设置为启动项目，然后运行update-database命令，解决了这个问题。
如果以上解决方案都不起作用(对我来说都不起作用)，那么只需重新启动计算机，您就可以连接到sql server (localhost)。
