C # How to remotely connect to SQL Server 2000 database Server (2)
Source: Internet
Author: User
Some people have said that it is insecure to remotely connect to SQL Server 1433 through port 2000 of the external service provided by SQL Server. Indeed, there are many tools on the Internet to catch port 1433, then we can find a way to modify the default port number 1433, which is generally divided into five steps;
Step 1: for example, use the SQL Server 2000 Server network utility to modify the default port number of SQL Server 2000;
Step 2: for example, use the client network utility provided by SQL Server 2000 to modify the default port number;
Step 3: Stop the SQL Server 2000 Service Manager and restart it;
Step 4: Enter netstat-an in the server's dos to check whether the listener is listening on port 7188. (The port 1433 is replaced by port 7188, the status of port 7188 is LISTEING (listener, listener ));
Step 5: for example, enter the telnet server IP address 7188 under the dos of a client (the cursor flashes, indicating that the remote login is successful)
Step 6: start writing the connection string in the code
String strConn = server = Server IP address, 7188; database = Name of the SQL server 2000 database Server on the server; uid = Account; pwd = password;
Check the red font. Because the default port number of SQL Server 2000 is changed to 1433, you need to add "," and the new port number after the modification. Remember ", "not": ";
Although this small modification does not completely address the security of remote connection to SQL Server 2000, it can be improved a little at least. This chapter only explains how to modify the default port number of SQL Server 2000, security is not discussed in depth;
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.