Using VMware Workstation 15, should I be using host-only for my scenario below?
I need to access SQL Server, hosted on a Windows 10 host, from a Windows 10 Guest VM, without giving the Guest VM access to the internet/resources on the physical network in which the host machine is situated.
Currently unable to access SQL Server on the Host from SQL Server Management Studio in the Guest VM. I am able to ping Host➡️Client, and not Host⬅️Client.
Guest VM's Network Adapter set to Host-only. Tried disabling the firewall on both host and guest and still unable to connect. Bridge and NAT seem to give internet access to the Guest VM. Thus I did not use it.
If there is a duplicate post for this, will greatly appreciate having the link posted here.
Thanks in advance