Current location - Quotes Website - Team slogan - How to modify the remote connection port of sql server
How to modify the remote connection port of sql server
1) Open SQL Server- Configuration Tool -—SQL Server Configuration Manager.

2) Select "Alias" option and right-click "New" to add alias, port number, server name and protocol (note that both alias and server ip should be filled in as IP addresses).

3) Reconnect, and normally fill in the SQL Server server address, user name and password to connect normally.