Install and configure the SQL Server and MySQL resource providers


Applies To: Windows Azure Pack

The SQL Server and MySQL resource providers enable provisioning Microsoft SQL and MySQL databases for tenant use. These resource providers are installed by default if you deploy the express configuration on a single system; if you deploy the distributed configuration, you need to install the resource providers manually.

You can install these resource providers on the same computer where you installed the Admin Service Management API or on separate computers.

If you are installing the resource providers on a separate computer from Windows Azure Pack, ensure that you have installed the Microsoft Web Platform Installer.

Use the following steps to install the resource providers.

To install the SQL Server or MySQL resource provider

  1. Log into the computer where you want to install the resource provider.

  2. Open the Web Platform Installer.

  3. Click the Products tab, and then click Windows Azure. Click Add next to Windows Azure Pack: SQL Server Extension or Windows Azure Pack: MySQL Extension, and then click Install.

  4. Review the software to be installed. You can view the privacy information for the extension by clicking Privacy Terms.

    Accept the terms and conditions on the Prerequisites page by clicking I Accept. The installation will begin.

  5. When the installation is complete, ensure that all Internet Explorer windows are closed, and then click Continue in the Web Platform Installer to launch the Configuration site.

  6. The Configuration site (https://localhost:30101) will open in Internet Explorer. If the security certificate warning page is displayed, click Continue to this website (not recommended).

  7. On the Database Server Setup page, enter the name of the database server. This is the database server that was configured when you installed the Windows Azure Pack core components.

  8. Select the type of authentication to use – SQL Server or Windows.

    If you choose SQL Server authentication, enter the database server admin user name (sa) and password.

  9. Enter the passphrase for the Configuration Store (this passphrase was configured when the core components were installed), and then click the next arrow.

  10. Indicate whether you want to participate in the Customer Experience Improvement Program (CEIP) and whether you want to use Microsoft Update to keep the resource provider up to date. Click the next arrow.

    The CEIP collects information about how customers use Microsoft programs, as well as the problems you encounter. This information is used to improve our products and features.

    Participation in CEIP is voluntary. If you choose to participate in CEIP, your computer automatically sends information to Microsoft about how you use this product.

  11. Review the features to be configured, and then click the check mark.

Next, configure the resource providers in the management portal for administrators. See Configure SQL Server and MySQL Application databases for tenant use.