建立与SQL Server的连接时发生与网络相关或特定于实例的错误。服务器未找到或无法访问。验证实例名称是否正确并且... [英] 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...
问题描述
建立与SQL Server的连接时发生与网络相关或特定于实例的错误。服务器未找到或无法访问。验证实例名称是否正确并且SQL Server配置为允许远程连接
我已完成下面提到的所有设置
1.尝试使用管理工作室从服务器连接sql server。如果您使用Windows身份验证连接sql server然后将您的应用程序池标识设置为服务器管理员。
2.如果您使用sql server身份验证，请检查Web中的连接字符串您的Web应用程序的.config并设置允许您登录的SQL Server的用户ID和密码。
3.如果您的数据库在其他服务器中（访问远程数据库） ）然后首先从sql server管理工作室启用sql server sql server属性的远程访问，并启用TCP / IP表单sql server配置管理器。
4. after doing所有这些东西，你仍然无法访问数据库，然后检查服务器窗体的防火墙，你试图访问数据库，并在防火墙中添加一个规则，以启用SQL Server的端口（默认情况下sql server使用1433，检查端口sql server你需要检查sql server配置管理器网络协议TCP / IP端口）。
5.如果你的sql server是ru在命名实例上然后你需要用sql serer名称编写端口号，例如117.312.21.21/nameofsqlserver,1433。
仍然不能为我工作。有没有其他方法来获得结果
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
I have done all the settings below mentioned
1.Try to connect sql server from your server using management studio . if you use windows authentication to connect sql server then set your application pool identity to server administrator .
2.if you use sql server authentication then check you connection string in web.config of your web application and set user id and password of sql server which allows you to log in .
3.if your database in other server(access remote database) then first of enable remote access of sql server form sql server property from sql server management studio and enable TCP/IP form sql server configuration manager .
4.after doing all these stuff and you still can't access the database then check firewall of server form where you are trying to access the database and add one rule in firewall to enable port of sql server(by default sql server use 1433 , to check port of sql server you need to check sql server configuration manager network protocol TCP/IP port) .
5.if your sql server is running on named instance then you need to write port number with sql serer name for example 117.312.21.21/nameofsqlserver,1433 .
still its not working for me. Is there any other way to get the result
推荐答案
基本上，当您无法连接到SQL Server时，问题可能是：
1）网络问题，
2）SQL Server配置问题。
3）防火墙问题，
4）客户端驱动程序问题，
5）应用程序配置问题。
6）身份验证和登录问题。
Basically, when you failed to connect to your SQL Server, the issue could be:
1) Network issue,
2) SQL Server configuration issue.
3) Firewall issue,
4) Client driver issue,
5) Application configuration issue.
6) Authentication and logon issue.
检查这些
解决SQL连接问题的步骤 [ ^ ]
SQL Server 2005连接问题疑难解答 - 第一部分 [ ^ ]
解决SQL Server 2005中的连接问题 - 第二部分 [ ^ ]
解决SQL Server 2005中的连接问题 - 第III部分 [ ^ ]
编辑
------------- ---
要检查的7件事要解决网络相关或实例建立与SQL Server的连接时发生特定错误... [ ^ ]
Check these
Steps to troubleshoot SQL connectivity issues[^]
SQL Server 2005 Connectivity Issue Troubleshoot - Part I[^]
Troubleshoot Connectivity Issue in SQL Server 2005 - Part II[^]
Troubleshoot Connectivity Issue in SQL Server 2005 - Part III[^]
EDIT
----------------
7 things to check to resolve "A network-related or instance-specific error occurred while establishing a connection to SQL Server…"[^]
我遇到同样的问题。
我的案例解决方案：
我们必须将白名单列入白名单主Sql服务器中的客户端Sql服务器IP地址。
我的情况我将数据从一个客户端SqlServer传输到Master Sql server机器..那个时候从问题来了....
我们通过白名单对客户端机器IPAddress进行排序..
I have the same issue.
Solution for my case:
We have to whitelist the Client Sql server IP Address in the Main Sql server.
My case i am transferring data from one client SqlServer to Master Sql server machine.. that time from the issue came....
We sort it out by white listing the client machine IPAddress..
Hi Sukirti，
您是否尝试在sql server configuraiton manager中启用远程服务器中的所有端口（第3点） - >客户端协议 - >启用所有的端口？
如果你已经这样做已经忽略了这个。
希望这个帮助你一点
问候，
RK
Hi Sukirti,
Have you tried enabling all the port in the remote server(3rd point) in sql server configuraiton manager --> Client protocols --> enable all the Ports in that?
If you have done that already ignore this.
Hope this helps you a bit
Regards,
RK
这篇关于建立与SQL Server的连接时发生与网络相关或特定于实例的错误。服务器未找到或无法访问。验证实例名称是否正确并且...的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
