Export (0) Print
Expand All

Using SQL Server or MySQL with Windows Azure Pack

Updated: October 17, 2013

Applies To: Windows Azure Pack for Windows Server

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, and SQL Server 2012 SP1.

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

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.

 
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft