Workaround for SQL Server cannot connect remotely because the virtual machine and host ping are not available

One, the configuration of the virtual machine network

Here are just a list of your own configurations:

1. Edit---The virtual network editor to set up

2. Set up the corresponding system

3. Or ping, and finally shut down the Windows Firewall inside the virtual machine, you can ping, it seems that net mode is not ping through.

Second, SQL Server cannot connect

Next, install SQL Server inside the virtual machine and the firewall is down

telnet virtual machine IP SQL Server port from host, prompting Port to close

1. Exclude Firewalls

2. See if Windows allows remote connections

It's already been checked.

3. Open SQL Server Configuration Manager, enable TCP/IP and Named pipes ... You can have it.

Workaround for SQL Server cannot connect remotely because the virtual machine and host ping are not available