Remote connection problem
Maybe this article helps you have help
How to connect to a computer on a computer connected to a computer via the internet
************** Can connect to several elements of SQL. ********************************
1. First ensure the PING pass (with a firewall to turn off the firewall) 2. Execute it under the command prompt: Telnet
5. If not, configure it in the client's SQL Server client: Start - Program - Microsoft SQL Server - Client Network Utility - Alias - Add - Network Library Select "TCP / IP" - Server alias Enter SQL Server Name - Connection Parameters - Enter SQL Server IP Address in Server Name - If you modify SQL port, deselect "Dynamic Decision Port" and enter the corresponding port number
************ Contact active ********************************************* *************]
- If your two computers have fixed public IP addresses, they are trustworthy. Like a normal LAN.
- If your two computers can only get the dynamic public IP address, with the following method:
To: http://www.comexe.cn/
Register a free domain name, install its dynamic domain resolution software. (Of course, there are many other software to choose from).
************** If your computer is online. Just use port mappings. *************** Repost :
Since the public IP address is limited, many ISPs use multiple intang users through the proxy and gateway routing to share a public IP IP Internet, which limits these users to set up a personal website on their own computer, to be implemented in these The user end housing website, the most critical point is how to map multi-user intranet IP and an IP they only share the Internet! Just like in the local area network or Internet cafe, although you can set up multiple servers and websites, you still have an external IP address, how to map the IP of the external network into the corresponding intranet IP address, This should be the Internet of the Internet of the Internet or the gateway router. It is also our access ISP service provider (China Telecom, China Unicom, Netcom, Tietong, etc.). Provided services, because this technology is implemented for them, and it is more difficult to make us, first of all, you can get the support of the system administrator to be realized. Because all the settings must be done on the proxy server.
To achieve this, you can use Windows 2000 Server port mapping capabilities, in addition to this, WinRoute Pro also has such functions, as well as a variety of enterprise firewalls. For us these ordinary users, I am probably the most convenient use of Windows 2000 Server.
Let's introduce Nat, NAT (Network Address Translation) is a transparent route that maps an IP address domain to another IP address domain technology to provide transparent routes for terminal hosts. NAT includes static network address conversion, dynamic network address translation, network address and port conversion, dynamic network address and port conversion, port mapping, etc. NAT is commonly used in private address domains and public address domains to resolve the IP address shortage. After the NAT is implemented on the firewall, the internal topology of the protected network can be hidden to a certain extent, to a certain extent, improve the network security. If the reverse NAT provides the dynamic network address and port conversion function, it is also possible to realize the function port mapping function such as load balancing allows a machine to provide WWW services in the internal network. This is not to transfer the true IP address directly to the internal providing WWW service. The host, if such, there are two hosted ends, one is internally not safe, because in addition to WWW, external networks can access all functions of this machine through address conversion function; second, when there are multiple machines When this service is provided, you must have the same multi-IP address for conversion, so that the purpose of saving IP addresses is not available. The port mapping function is mapped to a true IP address of a host to a true IP address. When the user accesss a port of the mapping port host, the server will request to transfer to the host of the host, which provides this particular service of this particular service; The port mapping feature also maps multiple ports of a true IP address machine into different ports on the internal different machines. Port mapping features can also complete some specific proxy features, such as protocols such as POP, SMTP, Telnet. In theory, there can be a map of more than 60,000 ports, I am afraid that we will never be used. First, let's introduce the port mapping by using NAT sharing Internet access and utilizing NAT.
1. On Windows 2000 Server, from the management tool to "Rountening and Remote Access" service, right-click on the server, "" Configure and enable routing and remote access "2, points" One step "3, select" Internet Connection Server ", allowing the intranet host to access the Internet through this server. (It is best to configure the NAT sharing, let the intranet host can be online, otherwise, the port mapping will be configured NAT sharing is a bit troublesome, and it is not good to share.) 4, select "Setting" Router with Network Address Translation (NAT) Route Protocol ", do not select" Setting up Internet Connection Sharing (ICS) ". (ICS The difference between NAT is to use the easy degree of use. In order to enable ICS, you only need to select a check box, and in order to enable NAT, more configuration tasks are required. In addition, the reason for ICS is used in small networks is still : For the internal host, it needs to have a fixed IP address range; for communication with external networks, it is limited to a single public IP address; it only allows a single internal network interface.) 5, first talk about me first. Network condition: Internet connection 192.200.200.3 (also an internal address, no way, Tung Tong's network is not very good, the network speed is unhappy, the price is expensive, my life is very bitter) Dormitory connection 192.168.0.1 (there is also the dormitory LAN, a total of 4 computers, one of the web servers installed with Sambar 5.1b5, the web port is 80, and the website will be accessed from the external network (replaced with 192.200.200.55) to access the webpage on this 192.168.0.2:80 This NAT host is opened on the IIS5.0, the port is 80, and the 8081 port is mapped to the 80-port of the internal host 192.168.0.2 with port mapping. 6, select "Internet Connection" in the Routing and Remote Access Server Installation Wizard (that is connected to the Internet), click "Next". 7, select "Finish" until this, the NAT sharing setting is also completed, and the internal host can be internetrated. The network settings of the internal host are as follows: IP address is 912.168.0.2 ~ 192.168.0.254, the subnet mask is 255.255.255.0, the gateway is 192.168.0.1, the DNS is the address given by ISP, we are 211.98.xxx.xxx
Second, use NAT to map port
1. Add a NAT protocol. Right-click "General", "New Routing Protocol" 2, select "Network Address Translation (NAT)" in the "New Routing Protocol", click "OK" 3, so many in "IP routing" A "Network Address Translation (NAT)" 4, right-click "Network Address Translation (NAT)", add "New Interface" 5, select "Internet Connection" in Network Address Translation (NAT) "( That is, connect to the connection to the Internet, don't choose wrong) 6. Select the "public interface connection to the Internet", check "in the Network Address Translation - Internet Connection Properties" Convert TCP / UDP Head (Recommended) "7 Add the start address and end address you need to provide port redirection in the "Address Pool" option table (that is, you have to take all the IP addresses of your port mapping, in general, we can use an IP address, so you can There is no longer exquisite "Address Pool". 8, provide the data connection protocol you need to oriented in the "Special Port" option table (TCP or UDP protocol, such as web and ftp are TCP protocol), selection After "Add" 9, "Add Special Port", here is the core of setting the port mapping, which port which one of the NAT hosts maps to the intranet host is set here, because the "address pool" is provided, so you can Add any address in "Address Pool" in "Public Network Address", which is "192.200.200.3", which is my address, if you have no "address pool" in front, then in this option page "In this address pool item" is not available, you can only choose "In this connection", that is, you only have a public IP address, this is more suitable for only one IP friend, you can use "Address Pool", why Do you have extra settings? If you have any questions, it is not a trouble. "Incoming Port" is the port of NAT server with public IP from the Internet, and is 8080. "dedicated address and out Address "is the IP address of the internal host and a port that provides special services. Here is 8080 ports on 192.200.2 to 80 ports on 192.168.0.2. This is the redirection of the TCP protocol port, as for UDP orientation pages The following figure is the case after adding a port mapping. IV. Test results at 192.200.200.55 Test the web server built on the NAT host and 192.168.0.2 in the intranet, and the results are as follows: (Sorry The middle changed the port number, 8081 port on 192.200.200.3 mapped to 192.168.0.2 80-port)
