How to install SQL Server in WVD personal pooled machines?

%3CLINGO-SUB%20id%3D%22lingo-sub-1426296%22%20slang%3D%22en-US%22%3EHow%20to%20install%20SQL%20Server%20in%20WVD%20personal%20pooled%20machines%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1426296%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20clients%20need%20to%20install%20SQL%20Sever%20in%20their%20WVD%20Personal%20machines.%20I%20didn't%20find%20any%20documentation%20to%20follow%20the%20steps.%20Also%20WVD%20machines%20wont%20have%20a%20public%20IP.%20How%20can%20I%20achieve%20this%3F%20Any%20suggestions%20or%20work%20arounds%20will%20be%20much%20appreciated.%26nbsp%3B%20Please%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1428744%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20install%20SQL%20Server%20in%20WVD%20personal%20pooled%20machines%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1428744%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F557804%22%20target%3D%22_blank%22%3E%40gadmin285%3C%2FA%3E%26nbsp%3BI%20am%20not%20sure%20if%20SQL%20Server%20supports%20Windows%2010%20multi-session%2C%20if%20not%20you%20can%20just%20publish%20a%20normal%20Windows%2010%20dedicated%20VM%20to%20the%20users%20in%20WVD%20and%20install%20it%20the%20way%20you%20would%20do%20on%20any%20other%20desktop.%20WVD%20is%20just%20the%20broker%2C%20Win%2010%20is%20still%20the%20OS.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20for%20the%20internet%20access%20no%2C%20the%20desktop%20must%20be%20accessed%20by%20using%20WVD.%26nbsp%3B%20Not%20sure%20why%20you%20would%20want%20to%20connect%20directly%20to%20a%20public%20IP%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20absolutely%20had%20to%20it%20then%20you%20could%20probably%20use%20Azure%20Load%20Balancer%20of%20Azure%20Firewall%20to%20host%20a%20public%20IP%2C%20then%20forward%20that%20traffic%20to%20the%20private%20IP%20of%20the%20WVD%20Desktop.%20But%20its%20a%20bit%20messy%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1441860%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20install%20SQL%20Server%20in%20WVD%20personal%20pooled%20machines%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1441860%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20Neil%3C%2FP%3E%3CP%3EThanks%2C%20for%20your%20suggestions.%20I%20have%20successfully%20deployed%20SQL%20Server.%20I%20deployed%20WVD%20for%204%20users%20and%20created%20a%20separate%20machine%20which%20I%20later%20domain%20joined%20it%20and%20installed%20a%20SQL%20Server%20in%20this%20machine.%20After%20setting%20this%20up%2C%20we%20installed%20SQL%20Management%20studio%20in%204%20WVD's%20and%20allowed%20the%20SQL%20ports%20in%20NSG.%20Thanks%20for%20your%20reply%20and%20helpful%20suggestions.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F235785%22%20target%3D%22_blank%22%3E%40Neil%20McLoughlin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

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.

2 Replies
Highlighted

@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 :)

 

 

Highlighted

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. @Neil McLoughlin