sql server on azure virtual desktop

eg1995 1,146

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

Justin Verstijnen 201 Reputation points

2022-05-25T18:25:14.587+00:00

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.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

3 additional answers

Olaf Helper 45,096 Reputation points

2021-09-22T13:57:22.583+00:00

Current SQL Server versions are supported on Windows Server x64, and it doesn't matter if it's a virtual or physical machine.
Please sign in to rate this answer.
eg1995 1,146 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
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
TravisCragg-MSFT 5,681 Reputation points Microsoft Employee

2021-09-22T22:17:17.427+00:00

@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.
Please sign in to rate this answer.
eg1995 1,146 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,681 Reputation points Microsoft Employee

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.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Limitless Technology 39,671 Reputation points

2021-09-23T09:29:07.41+00:00

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--
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

sql server on azure virtual desktop

3 additional answers

Your answer