Table of Contents
- Supported Versions
- Supported Editions
- Supported Operating Systems
- Installation Features
- Deploying Managed MS SQL
The foundation of Microsoft’s comprehensive data platform, SQL Server delivers breakthrough performance for mission-critical applications – and it gets even better with CenturyLink Cloud Application Manager and our Managed Microsoft SQL service.
Cloud Application Manager’s Managed Services Anywhere allows customers to deploy workloads and delegate the management of the workload to CenturyLink, relieving themselves of the burdens of day to day monitoring, patching and Operational activities. Through Cloud Application Manager, a customer can provision a new VM instance with MS SQL within their AWS provider and chose to have CenturyLink manage both the Operating System and MS SQL.
- Microsoft SQL Server 2008 R2
- Microsoft SQL Server 2012
- Microsoft SQL Server 2014
- Standard Edition
- Enterprise Edition
Supported Operating Systems
- Managed Microsoft Windows Server 2008 R2
- Managed Microsoft Windows Server 2012
- Licensing for AWS and Azure deployments are provided by the Cloud Provider. The cost for MS SQL server and the VM it is deployed upon will be reflected within the customer's cloud provider bill, or under the cloud provider's section in the CenturyLink consolidated bill for customers that have elected to utilize CenturyLink's consolidated billing feature.
- CenturyLink DCC-Foundation supports a bring your own license (BYOL) model. Customers can enter an activation key at deployment for a Managed MS SQL instance deployed on DCC-Foundation.
- Prepare Server for Application Service (OS Specific Parameters)
- Install Microsoft SQL Server (including available options and features)
- Install applicable Microsoft SQL Server Service Packs
- Harden Microsoft SQL Server to CenturyLink Standards
- Install CenturyLink Monitoring
- Perform Quality Assurance against Microsoft SQL Server Installation/Hardening
- Create/Configure Microsoft SQL Server service accounts and SPNs
- Configure Login Auditing
- Configure Database Encryption using TDE
- Configure CenturyLink Monitoring
- Configure CenturyLink approved and provided Database Backups and Maintenance Jobs
- SQL Server Log Monitoring
- Restart/Stop/Start Services
- Update managed servers with all recommended security patches, service packs and hot-fixes upon customer request
- Coordinate patching with Customer during maintenance hours
- Support for Microsoft SQL Server Analysis Services (SSAS)
Deploying Managed MS SQL
Deploying Managed MS SQL to your AWS provider with CenturyLink Cloud Application Manager:
- In Boxes, Deployment Policies, search for “SAMPLE”
- Select SAMPLE Managed MS SQL Deployment Policy
- Select the Configure (Gear) dropdown
- Select “Clone”:
- Modify the Cloned Deployment Policy with your details (Icon, Name, Description)
- Select Save
- Edit your new Deployment Policy with your environment specific details (Resource, Placement and Network) and Save.
NOTE: The CenturyLink recommended Instance type is selected in the SAMPLE Managed MS SQL deployment. Modification of this Instance type may result in significant performance issues.
Disk configuration settings should remain as configured in SAMPLE Managed MS SQL deployment policy.
- In Boxes, Deployment Policies, search for “CenturyLink Managed SQL Server”
- Select CenturyLink Managed SQL Server Script Box
- Select Deploy
- Update the Details of the instance that is to be deployed, selecting the appropriate Deployment Policy for your desired environment.
- Select Deploy