当我尝试连接SQL Server时，我得到以下错误:
在建立与SQL Server的连接时，发生了与网络相关或特定于实例的错误。未找到服务器或无法访问服务器。验证实例名称是否正确，SQL Server是否配置为允许远程连接。(提供商:Named Pipes提供商，错误:40 -无法打开到SQL Server的连接)
当我试图在Visual Studio 2010中将数据库配置为gridview时抛出此错误。我不知道如何调试这个错误。
如何调试此错误?除了错误消息中提到的步骤之外，我还应该采取哪些步骤来确定这里到底发生了什么?
当前回答
总结
要修复在运行本地应用程序与远程数据库时遇到的此问题，请使用SQL Server配置管理器为远程数据库添加别名。
细节
I had run into this problem recently when transitioning from a Windows 7 to a Windows 10 laptop. I was running a local development and runtime environment accessing our Dev database on a remote server. We access the Dev database through a server alias setup through SQL Server Client Network Utility (cliconfg.exe). After confirming that the alias was correctly setup in both the 64 and 32 bit versions of the utility and that the database server was accessible from the new laptop via SSMS, I still got the error seen by the OP (not the OP's IP address, of course).
有必要使用SQL Server Configuration Manager为远程Dev数据库服务器添加别名。把事情都解决了。
其他回答
在做了上面提到的所有事情之后: http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/ 对我来说还是没用。
以下步骤对我很有效:
开始>执行> cmd > sqlcmd -L
它将提示您服务器名。确保此服务器名称与SQL management studio的CONNECT to server框中试图连接的服务器名称相同。
我犯了这个愚蠢的错误，我一直使用MSSQLSERVER而不是使用这个服务器名。
希望这对像我一样犯愚蠢错误的人有所帮助。
谢谢。
我遇到了同样的问题，问题是我在解决方案(Weband Droid)中有几个项目，即使在包管理器控制台中选择了默认项目，它也使用了Droid项目的连接字符串:
PM> update-database -Verbose
Using StartUp project 'Droid'. <-- DROID
Using NuGet project 'Web'. <-- WEB
Specify the '-Verbose' flag to view the SQL statements being applied to the target database.
<!-- BAD TARGET DATABASE -->
Target database is: 'DefaultConnection' (DataSource: .\SQLEXPRESS, Provider: System.Data.SqlClient, Origin: Convention).
System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
[REMOVED TEXT]
ClientConnectionId:00000000-0000-0000-0000-000000000000
Error Number:-1,State:0,Class:20
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
在包管理器控制台设置启动项目到Web和默认项目后，我得到了它的工作。
除了尝试Teo Chuen Wei Bryan建议的所有方法外，还要确保在连接字符串中引用了正确的服务器/实例名称。
如果您在数据库服务器或web上使用主机名/实例的简写形式。配置文件，确保您使用完全限定域名(FQDN)/实例
此外，要从不存在SQL server客户端的服务器测试连通性，
——>创建一个文本文件，并将其扩展名为。udl
右键单击文件，你可以看到连接选项卡。
——>输入服务器名和登录信息，测试连接到数据库服务器。
希望这能有所帮助。
我必须运行SQL Server浏览器服务到SQL Server配置管理器。 如果没有这个，安装就不能发现新创建的服务。
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”，您可能是域名错误，或者您可能有这个问题。
