我们可以在WAN*问Microsoft SQL Server数据库吗？

I just want to ask that can we access Microsoft SQL Server database on WAN like My SQL Database? If so, then kindly guide me how?

我只想问一下,我们可以在WAN*问Microsoft SQL Server数据库,例如My SQL Database吗?如果是这样,那么请指导我怎么样?

Thanks in Advance.

提前致谢。

1 个解决方案

#1

Q: Can you access MSSQL across a WAN?

问:您可以通过WAN访问MSSQL吗?

A: Short answer: Yes.

答:简答:是的。

In theory, you can access MSSQL anywhere across the network, including across a WAN network.

理论上,您可以通过网络访问MSSQL,包括通过WAN网络访问。

All you need are:

你所需要的只是:

1. a route between your client and the MSSQL server, and

   客户端和MSSQL服务器之间的路由,以及

2. the MSSQL port (typically TCP port 1433) to be open.

   要打开的MSSQL端口(通常是TCP端口1433)。

If you can "ping" from your client to the remote host, you've got 1) covered.

如果您可以从您的客户端“ping”到远程主机,那么您已经覆盖了1)。

In order to "open the port", however, you must:

但是,为了“打开港口”,您必须:

a. Configure the MSSQL Server to use TCP/IP (this is not necessarily enabled by default)

一个。配置MSSQL Server以使用TCP / IP(默认情况下不一定启用)

b. Open port 1433 on the MSSQL Server's host

湾在MSSQL Server的主机上打开端口1433

c. Configure the router(s) between your client and the host to open port 1433, and route requests on that port to your MSSQL Server's host

C。在客户端和主机之间配置路由器以打开端口1433,并将该端口上的请求路由到MSSQL Server的主机

d. Configure any firewalls (including your client PC) to allow port 1433

d。配置任何防火墙(包括您的客户端PC)以允许端口1433

Here is a link for opening your Windows firewall:

以下是打开Windows防火墙的链接:

• https://msdn.microsoft.com/en-us/library/cc646023.aspx

Here is a link for configuring your router(s):

以下是配置路由器的链接:

• https://technet.microsoft.com/en-us/library/ms175483%28v=sql.105%29.aspx