Forum Discussion

gadmin285's avatar
gadmin285
Brass Contributor
May 29, 2020

How to install SQL Server in WVD personal pooled machines?

Hi 

 

My clients need to install SQL Sever in their WVD Personal machines. I didn't find any documentation to follow the steps. Also WVD machines wont have a public IP. How can I achieve this? Any suggestions or work arounds will be much appreciated.  Please help.

  • virtualmanc's avatar
    virtualmanc
    Iron Contributor
    May 30, 2020

    gadmin285 I am not sure if SQL Server supports Windows 10 multi-session, if not you can just publish a normal Windows 10 dedicated VM to the users in WVD and install it the way you would do on any other desktop. WVD is just the broker, Win 10 is still the OS. 

     

    As for the internet access no, the desktop must be accessed by using WVD.  Not sure why you would want to connect directly to a public IP??

     

    If you absolutely had to it then you could probably use Azure Load Balancer of Azure Firewall to host a public IP, then forward that traffic to the private IP of the WVD Desktop. But its a bit messy 🙂

     

     

    • gadmin285's avatar
      gadmin285
      Brass Contributor
      Jun 05, 2020

      Hey Neil

      Thanks, for your suggestions. I have successfully deployed SQL Server. I deployed WVD for 4 users and created a separate machine which I later domain joined it and installed a SQL Server in this machine. After setting this up, we installed SQL Management studio in 4 WVD's and allowed the SQL ports in NSG. Thanks for your reply and helpful suggestions. virtualmanc 

Resources