Posting Yak Master
Posted - 01/03/2013 : 15:10:22
I need some help on configuring this setup:
Host PC: IP Address: 18.104.22.168
host PC has VMWare. This VMWare image has SQL Server 2008 R2 with remote connections and everything enabled.
The VMWare image has the following IP Addresses:
The VMWare image can obviously connect to itself in terms of the database (instance name: SQL2008)
however when trying to connect FROM the host to the VMWare image, I cannot connect. it just says that it could not find the network instance/resource etc...
I can ping successfully from the host to the VMWare image (192.168.106.216) and RDP to it no problem.
any ideas what I am doing wrong? how can I connect my host SSMS to the remote/VMWare SQL Server instance?