How to enable remote connections and modify ports in MSSQL

As early as 2007, I came into contact with the MSSQL2000 version. At that time, I wanted to enable the SQL service for accounting students so that they could take the exam to practice. Later in, I learned and used it until now. Today we will show you how to enable the mssql server remote connection and how to modify the mssql server port.

1. Start -- program -- Microsoft SQL Server 2005 -- Configuration tool -- SQL Server peripheral application configurator -- service and connected peripheral application configurator -- Database Engine/remote connection -- local connection and remote connection connect to/to use TCP/IP -- Application/OK -- restart the service

2. Start -- program -- Microsoft SQL Server 2005 -- Configuration tool -- SQL Server Configuration Manager -- SQL Server 2005 network Configuration/MSSQLSERVER protocol -- enable TCP/IP (www.111cn. Net)
If you want to modify the remote port, refer to this article: Double-click the TCP/IP to switch to the IP address page -- find IPALL 1433 and modify the port number you want. If it is a multi-IP address, enable it as needed, if five IP addresses are not necessarily enabled for remote access, you can select one. In addition, select "yes" in "activity" and "enabled.

3. Open SQL Server Management Studio -- connect -- right-click (SQL Server 9.0.1399 ***) properties
1. Security-Server authentication/SQL Server and Windows authentication mode
2. Login review/failure and successful login
3. Allow remote connection to this server and set the timeout value. The default value is 600 seconds. Set as needed
4. In some versions, you must enable or allow remote connection to this server.
5. After completing the preceding steps, restart the MSSQLSERVER service.

4. Add port 1433 to the firewall. If you have modified the port, enter your modification.

V. Closing check
1. Check whether TCP/IP filtering is enabled for Windows or earlier operating systems. If yes, add the port as follows.
Start -- set -- network connection -- right-click the local connection attribute -- Internet Protocol (TCP/IP) attribute -- advanced -- option attribute -- Add the port to only the allowed TCP port.

2. Check whether there are other security software on the server. If yes, set the port to trust.

3. If the data center has restrictions, open the port to the data center (this case is rare ).

Success! Now, try to see if it can be remote.

This sharing applies to MSSQL2000/2005, and MSSQL2008 may change slightly.