sql server on azure virtual desktop

Question

sql server on azure virtual desktop

eg1995 1,156

dears,

i have a requirement to install on azure virtual desktop a windows server with an sql server.
can u advise if this is feasible or if sql is supported on wvd? i cant find any documentation on that

its very urgent
thanks

Accepted answer

3 additional answers

Your answer

Answer 1

Justin Verstijnen 211

Best practice would be to implement an separate VM with Server 2019 or 2022 in the same virtual network in Azure and let the application connect to that server. This would increase performance andere availability, especially when users are using Microsoft Teams or other resource-intensive applications on their remote desktop Hoste.

Answer 2

Olaf Helper 47,436

Current SQL Server versions are supported on Windows Server x64, and it doesn't matter if it's a virtual or physical machine.

eg1995 1,156 Reputation points

2021-09-22T14:04:12.043+00:00

@Olaf Helper i am asking if it is supported on azure virtual desktop solution. I know that sql can be installed on either physical or virtual machine but im checking if it can be integrated with azure virtual desktop

Answer 3

TravisCragg-MSFT 5,696 Microsoft Employee Moderator

@eg1995 This might be possible, but my first question would be why do you want to do this? Azure Virtual Desktop is designed to be a RDS environment for users to log into and have a remote workspace. The servers and instances are brought up and down on demand or as users log in and off, which is not a good environment for a database.

Typically SQL databases are deployed in Azure SQL, or on a Virtual Machine. It might be that WVD users need access to a SQL database, but I would HIGHLY suggest reviewing this requirement to make sure that this is the desired scenario.

eg1995 1,156 Reputation points

2021-09-23T05:03:49.107+00:00

Hi @TravisCragg-MSFT , the requirement is to have a sql server running on a windows server deployed in azure and that 10 users are being able to access this server remotely at the same time. It's either to deploy RDS terminal services on an azure vm or to suggest azure wvd if it is feasible even though i am not able to find any documentation regarding that

the additional thing is also when i quote wvd on azure calculator i cant choose sql licenses to add it on top so i am bit confused because eventually i will have to quote for a sql license

any ideas?
TravisCragg-MSFT 5,696 Reputation points Microsoft Employee Moderator

2021-09-23T22:48:48.343+00:00

Although it is possible to deploy a SQL server in your WVD environment, I would highly recommend deploying it on a separate SQL server in a VM in the same VNET.

When using the pricing calculator, make sure to select 'SQL Server' The SQL Server images come included with a SQL license.

Answer 4

Limitless Technology 39,916

Hello Eg1995,

Yes, this is possible. You can read in this 2 forums posts about it:

https://techcommunity.microsoft.com/t5/azure-virtual-desktop/what-can-we-install-in-wvd/m-p/1298114
https://techcommunity.microsoft.com/t5/azure-virtual-desktop/how-to-install-sql-server-in-wvd-personal-pooled-machines/m-p/1426296

--If the reply is helpful, please Upvote and Accept as answer--

Share via

sql server on azure virtual desktop

3 additional answers

Your answer