Add SQL Server resource provider in Azure stack

Source: Internet
Author: User
Tags mssql hosting ssl certificate server hosting

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.