如何通过WAN连接SQL Server数据库 [英] How to connect sql server database over the WAN

问题描述

我想通过WAN访问sql服务器数据库.我几乎不知道我们可以为此使用命名管道，但是我不确定.
如果可能的话，那么我应该在防火墙中进行哪些设置.

请提出建议.

thanx.

I want to access sql server database over the WAN.I got little idea that we can use Named pipe for this but I am not sure.
If its possible then what settings I should do in my firewall.

please suggest..

thanx.

推荐答案

如果要通过WAN与SQL Server通信，请使用TCP \ IP，因为命名管道仅在本地子网中使用.您必须在SQL Server 2005/2008安装中启用该功能.为了连接SQL客户端，您必须在托管SQL Server的一侧打开端口1433(TCP/IP的标准SQL Server端口)以用于入站流量.客户端必须打开端口1433才能进行出站通信.

希望对您有所帮助！

问候，

Manfred

If you will be communicating over a WAN with your SQL server, please use TCP\IP as named pipes are only of use in a local subnet. You''ll have to enable that on your SQL Server 2005/2008 installation. In order for the SQL clients to connect, you''ll have to open up the port 1433 (standard SQL Server port for TCP/IP) for inbound traffic on the side hosting the SQL server. The client''s side will have to have port 1433 opened up for outbound traffic.

Hope that helps!

Regards,

Manfred

您是否提到Windows窗体??

如果是这样，请在打开正在使用的TCP/IP端口或正在使用的命名管道的同时，在SQL Server计算机上使用公共IP，并启用对SQL Server的远程访问.实际上，无论您尝试通过Web模块还是通过Wind Forms应用程序访问都无关紧要.但是性能实际上很重要.

Are you mentioning about Windows forms???

If so, use public IP on SQL server machine while opening the used ports of TCP/IP or named pipes you are using and enable remote access of sql server. It does not matter actually wheather you are trying to access thru web module or Wind forms app. But performence actually matters.

这篇关于如何通过WAN连接SQL Server数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！