Perform the following tasks to deploy SQL Server:
-
Create a virtual machine based on an SQL Server image published in Windows Azure.
When creating the virtual machine, on the Virtual machine configuration page, select the Create a new cloud service option and choose the Virtual Network used by your replica domain controller in Windows Azure.
For more information on how to deploy an SQL Server in Microsoft Azure, see Create SQL Server on a Windows virtual machine in the Azure portal in the Microsoft Azure documentation.
- Join the SQL Server virtual machine to your Active Directory domain.
- Using SQL Server Management Studio, grant the sysadmin fixed server role to the domain user account that will be used as the service account for the Active Roles Administration Service.
- Configure Windows Firewall to allow connections to TCP Port 1433 from computers in your Virtual Network.
Because SQL Server will be accessed from within the Virtual Network, you do not need to create public endpoints in Windows Azure.