On premise SQL server Licencing

Question

Hi Team ,

Currently , We have an on-premise prod VM with SQL server along with BI tools (SSRS). Now, we are planning to provision two azure vm's for prod and dev environment on cloud. We are planning to use Azure SQL MI to host the Report databases.

My question:

Do we need two SQL server licenses one for SSRS reporting server setup , another one for Azure SQL MI on Prod Azure VM ?
OR Is it Possible to use same on premises SQL server license for both activities on prod Azure VM ?

Answer 1

Hi @Thyagarajulu B M ,

This is a community forum for technical questions & issues.

For questions regarding pricing / licensing, please get in touch with a Microsoft sales partner or licensing expert.

Call (1-800-426-9400), Monday through Friday, 6:00 AM to 6:00 PM PST, to speak directly to Microsoft licensing specialist.

https://www.microsoft.com/en-us/sql-server/sql-server-2019-pricing

-----

My answer (without any legal advice!)

For your DEV & PROD environment => you are deploying an Azure SQL MI (which is already licensed)
For your SSRS/SSIS in DEV => you are deploying a marketplace item VM with an image of (e.g.) Windows 2022 and SQL Server 2022 Developer Edition, so you are only paying for the OS licenses

For SSRS/SSIS in Prod (and you want to use a VM and not any other service), then have to deploy a marketplace item VM with SQL Server and "Bring your own license" => you might use your on-premise SQL Server licenses IF you have an active SA on it.

Answer 2

Hi @Thyagarajulu B M
I agree with BjoernPeters. I'm not particularly aware of issues regarding licenses. If you would like more information, please contact a Microsoft Licensing Specialist.
Best regards,
Aniya