我的SQL Server无法从远程连接访问
问题描述：
大家好.
我的SQL Server无法从远程连接访问
我启用了允许在连接时进行远程连接的功能，但是
我无法从网络上的另一台计算机访问sql server
请帮助我
hi every body.
my sql server cant be access from remote connetion
i enabled allow remote connetion at connetion and but
i cant access to sql server from a other computer at network
please help me
答
建立与SQL Server的连接时发生了与网络相关或特定于实例的错误.服务器未找到或无法访问.验证实例名称正确，并且已将SQL Server配置为允许远程连接. (提供者:TCP提供程序，错误:0-无法建立连接，因为目标计算机主动拒绝了该连接.
此错误意味着找到了您尝试连接的服务器，但是由于某种原因拒绝了客户端访问.客户端正试图通过无效端口进行连接，或者它不允许远程连接或防火墙问题.
在这里查看完整的详细说明:
错误消息:TCP提供程序.分辨率 [ ^ ]
^ ]
如果需要，请按照以下说明排除故障: ^ ]
更新:
无法打开连接...
通常，这是表面积配置错误或 sql服务配置问题.请查看此线程的潜在原因和解决方法: ^ ]
如果需要，请在此处参见设置外围应用配置的步骤. .
在这里，请查看以下与之相关的博客条目:
在默认设置下，SQL Server不允许远程连接 [ ^ ]
它说:
I.确保在外围应用配置器"工具中启用了远程连接"
二.检查是否在SQL Server配置管理器中启用了TCP/IP协议
三，确保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 that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.
This error means, the server you are trying to connect is found, but for some reason denying the client access. Client is trying to connect through an invalid port or it does not allow remote connections or a firewall issue.
Look here for full detailed explanation here:
Error message: TCP Provider.. - Cause & Resolution[^]
MSDN Blog: (provider: TCP Provider, error: 0 - No connection..[^]
If needed, troubleshoot more following this: MSDN Blog: TCP Provider: No connection could be made because..[^]
UPDATE:
Could not open connection...
Generally, it is surface area configuration error or sql service configuration issue. Have a look at this thread for potential reasons and resolutions: Resolving A network-related or instance-specific error occurred while establishing a connection to SQL Server[^]
If needed, See steps for setting up Surface area configuration here..
Here, look at the following blog entries related to the same:
Under the default settings SQL Server does not allow remote connections[^]
It says:
I. Make sure that Remote Connections are enabled in Surface Area Configuration tool
II. Check Whether TCP/IP protocol is enabled in the SQL Server Configuration Manager
III. Make sure that SQL server Browser service is running