Current location - Quotes Website - Collection of slogans - How to modify MSSQL default port
How to modify MSSQL default port
For security reasons, the default port needs to be modified.

MSSQL default port: 1433. In all versions of MSSQL, the modification method is the same:

-open MSSQL-SQL Server configuration manager.

-expand SQL Server network configuration: protocol of MSSQLSERVER -TCP/IP.

-Open the TCP/IP-IP address and modify "1433" in the TCP port.

Restart SQL Server service after modification -SQL Server (MSSQLSERVER), and right-click to restart.