Add SQL Server resource provider in Azure stack

Tag: Cloud Platform for Cloud computing

Add SQL Server resource provider in Azure stack

In the previous blog post, we deployed a node Azure Stack POC and uploaded the server image to the library. In the next section, we will deploy the MSSQL and MySQL resource providers.

Here's a high-level checklist we're going to complete:

Deploying the MSSQL Resource Provider

Verifying the MSSQL Resource provider deployment

MSSQL Resource Provider

Overview

The MSSQL resource provider (RP) is discussed first. By deploying this, we will be able to provide our tenant SQL database as a service. The RP can connect to multiple SQL Server instances on the backend to meet the tenant's database needs without having to start their own virtual machines running SQL Server

The resource provider consists of three parts, as follows:

Form	Details
SQL RP Adapter VM	The server hosts the small database required by the RP process and the RP State. It can also be used as an example SQL hosting server.
Resource provider	The RP is responsible for processing any SQL configuration requests and exposing our database resources to the tenant for use.
SQL Hosting Server	These servers run SQL Server and provide the database capacity for our tenants.

Deploying the MSSQL Resource Provider

Log on to the POC host using azurestack \ Azurestackadmin credentials.

Download the MSSQL RP Installer from here and run it to unzip the file to C:\SQL\

After the download is complete, unzip it as shown below:

Note: This script will do the following

Installing the Azurerm.bootstrapper module

Installs the 2017-03-0 version of the Azurerm module for computers, storage, networking, key vault, etc.

Install the PowerShell module that is specific to Azure stack

Download and extract the Azurestack tool from GitHub

Import the azure Stack connect PowerShell module for the tools downloaded above and add the Azurestack environment

Get the tenant ID of the AAD directory

Create and store the local Administrator credential object for the SQL VM you are about to launch

Create and store a credential object for an AAD directory user

Run the Deploysqlprovider.ps1 script using the information provided above

Installing the SQL Server resource provider

To run PowerShell as an administrator:

CD C:\SQL

. \deploysqlprovider.ps1

Enter the azure Stack Admin Management URL:

Enter the azure Stack Tenant Management URL:

Enter the local user name and password for the Sqladapter VM:

Enter Tenant Directory ID:

To set the SSL certificate password:

Enter the name of the Sqladapter resource group:

Enter the SQL virtual machine name:

Enter the login name and password for Azure Stack admin:

Start deployment:

Deployment Complete:

Add SQL Server Hosting Servers

Click "Resource Provider"-"Sqladapter":

Click "SQL Hosting Servers"-"ADD":

Enter "SQL Server Name", "Username", "Password", "Size of Hosting Server in GB", "Click SKUs":

Click "Create New SKU" and enter "Name", "Family", "Tire", "Edition":

Click Add:

Add complete as shown in:

Add SQL Server resource providers in Azure stack