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:

• Install and configure the SQL Server and MySQL resource providers.

• Install separate instances of SQL Server and MySQL for tenant use. These instances are in addition to the SQL instances used by Windows Azure Pack or the Web Sites service. (Scroll down for instructions, if you have not previously installed SQL Server or MySQL.)

• Configure SQL Server and MySQL Application databases for tenant use. This makes the instances available for use with the Web Sites service or for standalone use.

• Optionally create groups to organize your servers.

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:

• Manage logins, users, and schemas

• Create a full database backup

• Shrink a database

• Delete data or log files from a database

• Add data or log files to a database

• Update information about the data in tables and indexes

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.