I need to host a web application in IIS in Azure, if I take a virtual machine with Windows 2012 standard, how do I install SQL Server? Or is there any other option?
0
votes
2 Answers
4
votes
Getting most out of the Azure platform, I would suggest to use Azure Web Apps and Azure SQL Databases for that.
Using VMs only make sense, if you need control over the underlying systems (e.g. OS settings, Advanced SQL Server features like SSRS).
0
votes
If you are going to use AZURE make sure you read a little about what you can and cannot do on AZURE. For example there is no SQL Server Agent or global temp tables. I like the requirement that all tables require a clustered index. You may not.
Here are two articles that list some of the differences but these are an incomplete list: https://blogs.msdn.microsoft.com/azureedu/2016/07/15/what-features-are-not-supported-in-azure-sql-database/
http://www.sqlservercentral.com/articles/Azure+SQL+database/143076/
To install SQL Server on Azure follow this: https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-portal-sql-server-provision
