Concept explanation: Port 1433 is the default port of SQL Server, and the SQL Server service uses two ports: TCP- 1433 and UDP- 1434. Among them, 1433 is used for SQL Server to provide external services, and 1434 is used to return which TCP/IP port SQL Server uses to the requester. So how to change the default port 1433 of SQL SERVER database to another port?
Many people say that when configuring SQL Server, the port 1433 should be changed, so it is not easy for others to know what port to use. Unfortunately, it is easy to know what TCP/IP port is used by SQL Server through the UDP probe of Microsoft's undisclosed port 1434.
However, Microsoft has considered this issue. After all, opening and opening ports will cause unnecessary trouble. Select the properties of TCP/IP protocol in the instance properties. Select hide SQL Server instance. If the SQL Server instance is hidden, it will be prohibited to respond to broadcasts from clients trying to enumerate existing SQL Server instances on the network. So others can't use 1434 to detect your TCP/IP port (unless you use port scanning).
The security of 1433 port is not very high, and it is often easily compromised by hackers. Therefore, it is necessary to change the default port of SQL Server 1433. There are many viruses catching broilers on the Internet at 1433 port. Moreover, they often use sa weak passwords, so it is more complicated to set sa passwords. Do not use sa users for database connection in database link files such as conn.
In addition, port 1433, if only the local web links to the local database, there is no need to open port 1433, which is used for remote link.
There is no need to open the port 1433 or the mapping port in the daily use of the TZOJET T+ software, so even if TZOJET T+11software is used in the public network, hackers cannot attack our database through the port 1433. The steps to modify port 1433 in SQL 2008 R2 database are as follows:
1. Click Start-All Programs -“Microsoft SQL Server 2008 R2”- Configuration Tools -“SQL Server Configuration Manager.
2. In the opened SQL Server Configuration Manager window, select SQL Server network configuration-"MSSQL Server Protocol" in the tree window on the left, click TCP/IP on the right, and then right-click Properties to open the TCP/IP properties window.
(1) Click the IP Address tab, change the TCP port in IP 1 and IP2 to be empty, change the TCP port in IP ALL to 1444, and click OK after modification.
(2) Select "VIA" and right-click "Disable".
3. Click Start-Run and enter cliconfg.exe.
4. In the SQL Server Client Network Utility window that opens, on the General tab, double-click to enable TCP/IP in the protocol in sequence, change the default port to 1444, and then click OK. In this way, we have completed the change of the database port from 1433 to 1444.
5. Click Start-Run, enter "CMD" to enter the DOS window, then enter net stop mssqlserver to stop the database service, and then enter net start mssqlserver to start the database service, as shown in the figure:
6. Check whether the modified port is connected: click Start-Run, enter "CMD" to enter the DOS window, and then enter telnet127.0.0.1kloc-0/444.
7. Return to the blank window below, indicating that the 1444 port is unblocked. T+ software can be accessed directly without other settings.