通过no-ip like站点远程访问SQL Server。 [英] accessing remotely SQL Server via no-ip like sites.

问题描述

我想在没有静态IP的情况下远程访问sql server。但是没有ip-like网站。但我不知道做这一切的程序。是否有任何一步一步的文章。

I want to access sql server remotely without static ip. but with no-ip like site. But I don't know the procedure to do all that. Is there any step by step article.

推荐答案

如果您使用no-ip或dyndns之类的服务，您可能有类似adsl的连接，并且您拥有动态IP地址。你可能有一个adsl-modem可能与路由器结合使用。现在，您必须确保以下内容：

0）如果您根本没有任何真实的IP地址，请忘记它。

1）设置固定的本地IP对于你的服务器，不要使用dhcp。

2）你必须保持你的动态名称记录是最新的。您的调制解调器/路由器可以执行此操作，或者您必须使用动态DNS提供程序从服务器提供的软件工具执行此操作。当你没有任何路由器时也是如此。

3）这些路由器为你做NAT，并包含防火墙。您必须配置SQL Server以使用特定端口并在Windows防火墙和路由器上的防火墙上打开该端口（请参阅此处的端口设置：http://technet.microsoft.com/en-us/library/ms175043.aspx [ ^ ]）

4）如果你有NAT，你必须做端口转发：你必须将网络外部的端口转发到服务器上的端口（请参阅上面的链接）。您不需要从外部拥有相同的端口，但在这种情况下，您必须在连接字符串中指定端口。

5）您还可以移动（在某些路由器上）您的服务器DMZ，但请注意，您的服务器将受到各种攻击。在这种情况下，您应该强化您的服务器防火墙。



这就是全部。不过，这实际上取决于你的确切架构。

If you use a service like no-ip or dyndns you probably have an adsl like connection and you have dynamic ip address. And you probably have an adsl-modem probably combined with a router. Now, you have to ensure following:
0) If you don't have any real IP address at all, than forget it.
1) Set up fixed local ip for your server, don't use dhcp for it.
2) You have to keep your dynamic name record up to date. Your modem/router can either do this, or you have to do it with the software tool provided by the dynamic dns provider from your "server". This is the case also when you don't have any router.
3) Those routers do NAT for you, and have firewall included. You have to configure SQL server to use a specific port and open that port on both the windows firewall and the firewall on the router (see port settings here: http://technet.microsoft.com/en-us/library/ms175043.aspx[^])
4) If you have NAT, you have to do port forwarding instead: you have to forward ports from outside your network to the ports (see link above) on the server. You don't need to have the same ports from outside, but in that case, you have to specify port in the connection string.
5) You could also move (on some routers) your server in a DMZ, but be aware, that your server will be exposed to all sort of attacks. In this case you should harden your server firewall.

That's much all. Still, it really depends on you exact architecture.

你根本不知道你在问什么。 NOTHING'按名称'连接。名称只是映射到IP地址的人类可读值。 NOTHING连接到CodeProject.com，它使用该名称来查找它连接到的IP地址，例如。



您可以使用图层来映射静态IP到动态IP。但是，您的服务器需要一个IP地址，以便代码通过互联网找到它。

You have no idea about what you're asking. NOTHING connects 'by name'. A name is just a human readable value that maps to an IP address. NOTHING connects to CodeProject.com, it uses that name to find out the IP address that it connects to, for example.

You can use a layer to map a static IP to a dynamic one. But, your server needs an IP address, for code to find it over the internet.

这篇关于通过no-ip like站点远程访问SQL Server。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！