LAN connection SQL Server database configuration

First make sure that the two machines are on the same LAN, and then open the Configuration tool →sql Server Configuration Manager to configure. The TCP/IP (IP1) of the protocol that will be MSSQLSERVER. IP2) TCPPort changed to 1433, enabled instead of Yes.

Server name : Enter IP

Login name : Enter the database account number

Password: Enter the password of the database account number

description : Using Remote Desktop Connection does not have any relationship, but is associated with a system firewall. You must either pass SQL Server or shut down the firewall altogether.

LAN connection SQL Server database configuration