question

Rav-3376 avatar image
0 Votes"
Rav-3376 asked DSPatrick edited

Networking with sql server

Hi I have an instance of SQL Server running on my host.

I have set up a VM and have a .net app running.

From the VM, I need to connect to the SQL Server on my host.
Can you please point me to the instruction for setting this up.

I would also like to connect from VM to internet and copy/paste from either.

windows-server-hyper-v
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

DSPatrick avatar image
0 Votes"
DSPatrick answered DSPatrick edited

Installing other roles on a hyper-v host can cause conflicts, adds complication and also takes away from licensing. The much simpler / cleaner solution is to create and external vSwitch
https://docs.microsoft.com/en-us/archive/blogs/jhoward/hyper-v-what-are-the-uses-for-different-types-of-virtual-networks

then stand up a dedicated virtual machine for SQL Server and connect it to the external vSwitch. Connect the .Net app virtual machine to same vSwitch.

--please don't forget to Accept as answer if the reply is helpful--






5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.