Current location - Quotes Website - Team slogan - How to build a server on the company's computer for other computers to access, including accessing SQL2000 database.
How to build a server on the company's computer for other computers to access, including accessing SQL2000 database.
Hello, connect to the database remotely. Use the server IP and port number to access the following figure. The default port is 1433, and the port number can be omitted.

In addition, if the server is directly connected to the Internet, the above method can be directly connected. If the server is connected to the Internet through routing in the local area network, it is necessary to set the port mirroring of the router, and there will be relevant settings in the router settings, which are roughly set (the specific settings depend on the brand of the router and the ROM version of the router).

1.2.3.4 (external network IP) 1433 (port)

192. 168.0.254 (intranet IP) 1433 (port)

That is, connection? 1.2.3.4 (external network IP) 1433 (port) router to help you transfer? 192. 168.0.254 (intranet IP) 1433 (port)