Using SQL Server or MySQL with Windows Azure Pack


Applies To: Windows Azure Pack

You can add one or more Microsoft SQL Server or MySQL Server instances for tenants to deploy and use. Tenants also use these databases with the Web Sites service.

Use the following information to make databases available for tenants:

If you are using SQL Server, you can use SQL AlwaysOn Availability Groups with Windows Azure Pack. This enables you to provide a highly available database service to your tenants. See Configure SQL AlwaysOn Availability Groups in Windows Azure Pack for information.

Install SQL Server

Windows Azure Pack supports SQL Server 2008 SP3, SQL Server 2008 R2 SP2, SQL Server 2012 SP1, SQL Server 2014. and SQL Server 2016.

If you have not previously installed SQL Server, follow the instructions in the SQL Server TechNet library to install it: Installation for SQL Server 2016.

SQL Server management tasks

Here are some links to common SQL Server management tasks:

Install MySQL

You can install MySQL Windows 5.1 from the Microsoft Web Platform Installer. Use the following steps:

To install MySQL

  1. In the Web Platform Installer, search for MySQL Windows 5.1.

  2. In the search results, click Add next to MySQL Windows 5.1, and then click Install.

  3. In the Prerequisites window, enter a password for the default database admin account (root). Type the password again to confirm it, and then click Continue.

  4. Review the list of software to be installed, and then click I Accept.

    MySQL is downloaded and installed.

  5. Click Finish to close the install window.

  6. Next, ensure that MySQL is accessible:

    • Test IP connectivity and name resolution.

    • Open TCP 3306 Inbound in Windows Firewall for each computer running MySQL.

    • Enable remote access to MySQL.