Being able to create a linked SQL server between two VM images on same VM host.
I have two images residing on the same VM Ware Workstation Pro host. I can ping both machines from each other. However when I go into SSMS and try to connect one to another I get the message that the server cannot be found. What do I need to do to conect these two SQL instances. I need to create a linked server from one to another. Right now there is no domain. Is it a question of setting the DNS addresses?
ASKER
It has been a while since I have done that. My old notes have:
ethernet0.present = "TRUE"
ethernet0.virtualDev = "vmxnet"
ethernet0.features = "0"
ethernet0.addressType = "generated"
ethernet0.connectionType = "bridged"
ethernet0.startConnected = "TRUE"
isolation.tools.guestIniti
in which file would I put these commands? This is VM Workstation Pro 15.
ethernet0.present = "TRUE"
ethernet0.virtualDev = "vmxnet"
ethernet0.features = "0"
ethernet0.addressType = "generated"
ethernet0.connectionType = "bridged"
ethernet0.startConnected = "TRUE"
isolation.tools.guestIniti
in which file would I put these commands? This is VM Workstation Pro 15.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry, old habits are hard to break. All is well now. Thanks.
Glad all working.
Please don't forget to select a solution.
Please don't forget to select a solution.
ASKER
Thanks, it all helps to open a port for SQL.
if so use Bridged.