Configure SQL Server and MySQL Application databases for tenant use

Use the following information to configure SQL Server and MySQL in Windows Azure Pack. Once you have connected to the SQL or MySQL instances, you can organize your database instances into groups.

Connect to the SQL Server instance

Use the following steps in the management portal for administrators to connect your newly installed SQL instance to Windows Azure Pack.

To connect to SQL Server

1.   In the management portal for administrators, click SQL Servers in the left navigation pane.

2.   At the bottom of the window, click New or Add, and then click Connect to to add the new instance.

3.   Enter the SQL Server instance information: group name, server name, administrator user name (sa), administrator password, and the size of the hosting server (in GBs).

4.   Click Connect.

A message will be displayed at the bottom of the window indicating whether the action succeeded or failed.

5.   Click OK.

The SQL Server instance you just added is now displayed in the list of SQL Servers. Click the instance to view the details. You can confirm the hosting server’s capacity on the Dashboard and the list of databases in the instance on the Databases tab.

Connect to the MySQL instance

Use the following steps in the management portal for administrators to connect your newly installed MySQL instance to Windows Azure Pack.

To connect to MySQL

1.   In the management portal for administrators, click MySQL Servers in the left navigation pane.

2.   At the bottom of the window, click New or Add, and then click Connect to to add the new instance.

3.   Enter the MySQL Server instance information: group name, server name, administrator user name, administrator password, and the size of the hosting server (in GBs).

4.   Click Connect.

A message will be displayed at the bottom of the window indicating whether the action succeeded or failed.

5.   Click OK.

The MySQL Server instance you just added is now displayed in the list of SQL Servers. Click the instance to view the details. You can confirm the hosting server’s capacity on the Dashboard and the list of databases in the instance on the Databases tab.

Create groups

You can use groups to organize your SQL server or MySQL instances.

To create a SQL Server group

1.   On the SQL Servers dashboard, click Add, and then click Create a Group.

2.   Choose the type of group you want to create. You have two choices: Standalone servers or High availability (Always on enabled).

If you want to use the SQL AlwaysOn availability groups feature, as described in Configure SQL AlwaysOn Availability Groups in Windows Azure Pack, choose High availability (Always on enabled).

3.   If you chose to create a standalone server group, enter a name for the group.

4.   If you chose to create a high availability group, enter a name for the group and enter the path to the network file share.

5.   Click Create a group

After the SQL Server group is created, you can add SQL servers to it from the Groups list.

To create a MySQL Server group

1.   On the MySQL Servers dashboard, click Add, and then click Create a Group.

2.   Enter a name for the group.

3.   Click Create a group

After the MySQL Server group is created, you can add MySQL servers to it from the Groups list.