How to modify the MSSQL Port

Start -- program -- Microsoft SQL Server -- Server network utility

-- Enabled protocol -- delete other protocols -- retain only TCP/IP -- attribute -- default port

-- TCP/IP -- Property -- default port -- enter 123

Restart the SQL Service and connect to SQL.

-- 2. view the SQL Authentication Mode

Enterprise Manager -- Right-click SQL instance -- properties -- Security -- authentication -- display the currently selected "windows only"

-- 3. Modify the SQL Authentication Mode

Enterprise Manager -- Right-click SQL instance -- properties -- Security -- authentication -- select "SQL Server and Windows" -- OK -- prompt to restart SQL -- OK

The connection fails.

-- 4. Modify the client Configuration

Start -- program -- Microsoft SQL Server -- client network utility

-- Alias -- add

-- Select "TCP/IP" for the network library -- enter the SQL server name as the server alias

-- Connection parameter -- enter the SQL Server IP address in the server name

-- If you have modified the SQL port, deselect "dynamically determine port" and enter the corresponding port number: 123.

Connection again, successful