使用IP地址连接到远程SQl服务器 [英] Connecting to remote SQl server using IP address

问题描述

大家好，我在SQL Server方面没有太多经验.我正在尝试通过IP地址连接到SQL Server2005.我的连接字符串为


数据源= 117.213.4.155,1433；网络库= DBMSSOCN；初始目录= PostDB；用户ID =;密码=")

我收到此错误.


建立与服务器的连接时发生错误.连接到SQL Server 2005时，此故障可能是由于以下事实导致的:在默认设置下，SQL Server不允许远程连接. (提供者:TCP Provider，错误:0-无法建立连接，因为目标计算机主动拒绝了它.)

我已使用Surface配置工具启用了TCP/IP连接，但现在没有防火墙.

那么我该如何解决呢?并且请给我一些有关在远程SQL Server中存储和检索数据的建议和见解.我没有其他办法可以澄清这个问题.
预先谢谢您.

Hi all ,I dont have so much experience in SQL server. I''m trying to connect to an SQL Server 2005 via IP address.My connection string is


"Data Source=117.213.4.155,1433;Network Library=DBMSSOCN;Initial Catalog=PostDB;User ID=;Password=")

I''m getting this error.


An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)

I have enabled TCP/IP connection using Surface Configuration tool and I dont have a firewall now.

So how can I solve this? And please give me some advice and insights about storing and retrieving data in remote SQL server. I have no other way to clarify this issue.
Thank you in advance.

推荐答案

此错误表示已找到您要连接的服务器，但由于某种原因拒绝了客户端访问.客户端正试图通过无效端口进行连接，或者它不允许远程连接或防火墙问题.

在这里查看完整的详细说明:
错误消息:TCP提供程序.分辨率 [ ^ ]
^ ]


如果需要，请按照以下说明排除故障: ^ ]

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..[^]

请chk ur sql配置管理器.查看是否启用了tcp/ip，使用了哪个端口.检查所有这些详细信息后，请重新启动ur sql.

pls chk ur sql configuration manager . see, whether tcp/ip is enabled, what port is used. kindly restart ur sql after checking all these details.

请参阅http://www.codeproject.com/Articles/382261/Database-Backup-and-Restore

see to http://www.codeproject.com/Articles/382261/Database-Backup-and-Restore

这篇关于使用IP地址连接到远程SQl服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！