SQLServer default port 1433 modification method _ MySQL

The default port 1433 of SQLServer is not very secure. you need to change the default port of SQLServer. before changing the port, let's first understand what port 1433 is. 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 provide external services to the requester. the default port 1433 of SQL Server is not very secure. you need to change the default port of SQL Server, let's first understand what port 1433 is.

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 sa passwords are more complex and do not use sa users to connect to databases in database 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 for hackers to intrude into the server is to scan the server port and check whether there are any vulnerabilities. as we all know, there are many mssql vulnerabilities. although mssql 2000 sp4 is good, to increase security, it is better to change the default port 1433. how can I modify the default port 2000 of SQL server in 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 on the default port of SQL Server?

Set oConn = Server. createObject ("ADODB. connection ") sConn =" Driver = {SQL Server}; Server = Server address; 3314; Database = Database; UID = username; PWD = password; "oConn. open sConn Response. write oConn