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