How to modify the default port 1433 of SQLServer

What is port 1433, port 1433, is the default port of SQLServer, SQLServer service uses two ports: TCP-1433, UDP-1434. 1433 is used to provide external services for SQLServer, and 1434 is used to return the TCPIP port used by SQLServer to the requester. Many people say that port 1433 should be changed when configuring SQLServer.

What is port 1433 port 1433, which is the default port of SQL Server, the SQL Server service uses two ports: TCP-1433, UDP-1434. Among them, 1433 is used for SQL Server to provide external services, and 1434 is used to return to the requester which TCP/IP Port is used by SQL Server. Many people say that port 1433 should be changed when configuring SQL Server.

What are port 1433?

Port 1433 is the default port for SQL Server, and the SQL Server service uses two ports: TCP-1433, UDP-1434. Among them, 1433 is used for SQL Server to provide external services, and 1434 is used to return to the requester which TCP/IP Port is used by SQL Server.

Many people say that port 1433 should be changed when configuring SQL Server, so that others cannot easily know which port to use. Unfortunately, it is easy to know what TCP/IP Port is used by SQL Server through the UDP detection of port 1434 that is not publicly published by Microsoft.

However, Microsoft still considered this issue. After all, open and open ports will cause unnecessary troubles. Select the TCP/IP protocol attribute from the instance attributes. Select to hide the SQL Server instance. If the SQL Server instance is hidden, it is prohibited to respond to broadcasts from clients that attempt to enumerate existing SQL Server instances on the network. In this way, no one else can use 1434 to detect your TCP/IP Port (unless using Port Scan ).

Security reasons for port 1433

Port 1433 is not very secure and is often easily attacked by hackers. Therefore, it is necessary to change the default port 1433 of SQL Server. There are a lot of animations on the Internet for port 1433 bots. However, they often use weak sa passwords. Therefore, you must note that the sa password is more complex and do not use the sa user for connection in connection files such as conn.

In addition, port 1433 is used for remote connection if only the local web connection to the local database is enabled.

The first step of hacker intrusion is to scan the port and check whether there are any vulnerabilities. As we all know, there are many mssql vulnerabilities. Although mssql 2000 sp4 is good, in order to increase security, it is better to change the default port 1433. How can I modify the default port 2000 of ms SQL server 1433? After the modification, how should the corresponding website connect to the mssql database?

Open Microsoft SQL Server -- Server network utility -- enabled protocol -- TCP/IP -- properties -- default port

Client connection method:
Open Microsoft SQL Server -- client network utility -- alias and add

How does asp connect to and modify the sql2000 database with the default port?
Set oConn = Server. CreateObject ("ADODB. Connection ")
SConn = "Driver = {SQL Server}; Server = Server address, 3314; Database = Database; UID = user name; PWD = password ;"
OConn. Open sConn
Response. Write oConn