Deploy Microsoft SQL Server using Blueprint

Updated by Chris Little on Dec 1, 2016

IMPORTANT NOTICE

As of December 1, 2016, the service fees for Microsoft SQL Licensing on CenturyLink Cloud changed from 1 vCPU minimum to a 4 vCPU minimum, and moved from hourly usage based billing to fixed monthly billing. If you have questions about this change or did not receive notifications on this change please contact customer care at [email protected]

Table of Contents

Overview

CenturyLink Cloud customers can procure and deploy Microsoft SQL Server licensing within the Control Portal. Microsoft SQL Server is licensed via the Microsoft SPLA program. By using the CenturyLink Cloud public Blueprint customers have multiple ways to consume and install this business critical database software.

Socket to vCPU Allocation

It is recommended customers review our delivery model for Sockets to vCPU prior to deploying Microsoft SQL Server to be fully aware of the platform default operations when allocating vCPUs for use with the database service.

Prerequisites

  • A CenturyLink Cloud Account
  • ~15 GB Free Storage on C:\
  • Operating System and SQL Server Edition aligns in a supported fashion:
SQL Server Edition Supported Operating Systems
SQL Server 2008 R2 Web Edition 64-bit
SQL Server 2008 R2 Standard Edition 64-bit
SQL Server 2008 R2 Enterprise Edition 64-bit
Windows 2008 R2 Standard 64-bit
Windows 2008 R2 Enterprise 64-bit
Windows 2008 R2 Datacenter 64-bit
Windows 2012 Datacenter 64-bit
Windows 2012 R2 Datacenter 64-bit
SQL Server 2012 Web Edition 64-bit
SQL Server 2012 Standard Edition 64-bit
SQL Server 2012 Enterprise Edition 64-bit
Windows 2008 R2 Standard 64-bit
Windows 2008 R2 Enterprise 64-bit
Windows 2008 R2 Datacenter 64-bit
Windows 2012 Datacenter 64-bit
Windows 2012 R2 Datacenter 64-bit
SQL Server 2014 Web Edition 64-bit
SQL Server 2014 Standard Edition 64-bit
SQL Server 2014 Enterprise Edition 64-bit
Windows 2008 R2 Standard 64-bit
Windows 2008 R2 Enterprise 64-bit
Windows 2008 R2 Datacenter 64-bit
Windows 2012 Datacenter 64-bit
Windows 2012 R2 Datacenter 64-bit
SQL Server 2016 Web Edition 64-bit
SQL Server 2016 Standard Edition 64-bit
SQL Server 2016 Enterprise Edition 64-bit
Windows 2012 Datacenter 64-bit
Windows 2012 R2 Datacenter 64-bit

Exceptions

This KB does not apply to Managed Microsoft SQL Customers.

General Notes

The following are quick tips/notes based on past experiences with customers leveraging this Blueprint

  • It is not possible at the current time to install SQL to a drive other than C:\ via Blueprint. Customers can modify the SQL database, tempdb, log locations post install to other volumes using SQL tools
  • The fee's for Microsoft SQL server will be applied automatically to the customers invoice when using the public Blueprint. These fee's are available in the Pricing Catalog. If you are unsure what these fee's are please contact your account manager.
  • Licensing fee's are adjusted based on number of vCPU allocated to a virtual machine with a minimum of 4 vCPU license fees incurred. Customers billing will be modified as vCPU configurations change.
  • Customers can add features to an existing SQL instance by running the Blueprint multiple times on the same server and only selecting the additional features required.
  • Customers can add new SQL instances by running the Blueprint multiple times on the same server.
  • The Blueprint does not allow for version mobility. Customers who want to change the edition deployed must create a new server and SQL instance with the version desired and migrate their data.

Installing Microsoft SQL Server using Execute Package

  1. Navigate to Orchestration, Scripts in Control.

    servers menu in control portal

  2. Browse to the Group that houses the VM(s) you want to deploy SQL. Select Execute Package.

    select execute package

  3. Search for Install SQL and select the Install SQL Server on Windows (for version 2008/2012/2014) or Install SQL Server 2016 on Windows (for version 2016) script.

    search for SQL and choose script

  4. Select SQL Installation Options.

    • Input the appropriate parameters based on the SQL server requirements for your application.
    • Select the VM(s) in the Group you want to deploy SQL. Customers can choose an individual VM or multiple. (Quick Tip: Only supported Guest Operating Systems will be shown.)

    select installation options

Installing Microsoft SQL Server using Blueprint Library

  1. Navigate to Orchestration, Blueprint Library in Control.

    navigate to Blueprint library

  2. Search for Install SQL and select Install SQL Server on Existing Server (for version 2008/2012/2014) or Install SQL Server 2016 on Existing Server (for version 2016). Select the appropriate Blueprint.

    search menu with Blueprint choices

  3. Select Deploy Blueprint.

    deploy Blueprint

  4. Input the appropriate parameters based on the SQL server requirements for your application and select the Virtual Machine you wish to execute the install against.

    input parameters

  5. Confirm the virtual machine(s), features and select Deploy Blueprint.

    confirm inputs and deploy

Customer Support

Can’t find what you need?
Give us a call.

1.888.638.6771

M – F, 8am to 6pm