Reputation: 3
I need to setup SSRS on an Azure VM to use an Azure Database as the data source. Can I use SQL Server Web edition on the VM or do I need standard/enterprise edition?
Upvotes: 0
Views: 390
Reputation: 81454
Based upon your description, NO.
The answer depends. If you require remote and non-SQL data source support then NO. If you only need to access the local Web Edition SQL Server then YES.
You will find that the Web Edition is very limited in its support and is intended for local SQL Server support.
This link provides a table of supported configurations.
Reporting Services Features Supported by the Editions of SQL Server 2016
Upvotes: 1