当我尝试连接SQL Server时，我得到以下错误:
在建立与SQL Server的连接时，发生了与网络相关或特定于实例的错误。未找到服务器或无法访问服务器。验证实例名称是否正确，SQL Server是否配置为允许远程连接。(提供商:Named Pipes提供商，错误:40 -无法打开到SQL Server的连接)
当我试图在Visual Studio 2010中将数据库配置为gridview时抛出此错误。我不知道如何调试这个错误。
如何调试此错误?除了错误消息中提到的步骤之外，我还应该采取哪些步骤来确定这里到底发生了什么?
当前回答
尝试在连接字符串的末尾添加一个和一个端口号(如1433)。
其他回答
尝试在连接字符串的末尾添加一个和一个端口号(如1433)。
我使用的是SQL Server 2016和windows 10。
首先是允许远程连接到SQL Server。 我所做的就是键入sqlservermanager13。在开始菜单打开SQL Server配置管理器。确保TCP/IP状态为启用状态。
双击TCP/IP协议名称，检查TCP端口号。通常默认值是1433。
以下步骤通过使用Microsoft管理控制台(MMC)管理单元配置Windows防火墙的高级安全。高级安全Windows防火墙只配置当前配置文件。
To open a port in the Windows firewall for TCP access On the Start menu, click Run, type WF.msc, and then click OK. In the Windows Firewall with Advanced Security, in the left pane, right-click Inbound Rules, and then click New Rule in the action pane. In the Rule Type dialog box, select Port, and then click Next. In the Protocol and Ports dialog box, select TCP. Select Specific local ports, and then type the port number of the instance of the Database Engine, such as 1433 for the default instance. Click Next. In the Action dialog box, select Allow the connection, and then click Next. In the Profile dialog box, select any profiles that describe the computer connection environment when you want to connect to the Database Engine, and then click Next. In the Name dialog box, type a name and description for this rule, and then click Finish.
另一个需要配置的东西。
To open access to SQL Server when using dynamic ports On the Start menu, click Run, type WF.msc, and then click OK. In the Windows Firewall with Advanced Security, in the left pane, right-click Inbound Rules, and then click New Rule in the action pane. In the Rule Type dialog box, select Program, and then click Next. In the Program dialog box, select This program path. Click Browse, and navigate to the instance of SQL Server that you want to access through the firewall, and then click Open. By default, SQL Server is at C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Binn\Sqlservr.exe. Click Next. In the Action dialog box, select Allow the connection, and then click Next. In the Profile dialog box, select any profiles that describe the computer connection environment when you want to connect to the Database Engine, and then click Next. In the Name dialog box, type a name and description for this rule, and then click Finish.
看看微软的文档 配置Windows防火墙访问数据库引擎
对我来说，解决方案是调用互联网提供商开放端口1433。
出于某种原因，他们阻塞了端口，我甚至无法ping数据库服务器(托管在Azure上)。100%的数据包丢失。
他们打开港口后，一切又恢复了正常。
我将使用Entity Framework的项目设置为启动项目，然后运行update-database命令，解决了这个问题。
验证用于为SQL Server实例创建会话的帐户。
