PD AWS SQL Server lets you offer Amazon RDS for SQL Server instances through Blesta, using AWS. It suits applications that need Microsoft SQL Server, with the resource linked to the customer’s service.

Before you start

Install PD Modules for Blesta first, connect the account that holds your licence, then install PD AWS SQL Server from its Store. Allow the staff group that needs to use it.

You also need an AWS account with the permissions required for the chosen database service. Check the provider account’s permissions, available locations and capacity before enabling automatic provisioning.

Connect the account

In Settings → Company → Modules, find the installed module, choose Manage and add its account connection. Blesta calls this a module row. Keep this provider connection separate from the package settings.

Define what the customer receives

Create a package using PD AWS SQL Server and review its Module Options and configurable options. Start with Region, Plan, Backing service, SQL Server version and Storage. Together these describe the resource requested when a service is provisioned; they are not just labels on the order form.

Select a supported SQL Server instance plan rather than assuming the smallest plan from another engine is available.

Choose which client controls the package exposes. If you offer configurable options, check that their values match the module’s supported choices and that the defaults describe the service you intend to sell.

Put the service into use

Add the package group to the intended order form when it is ready. Blesta creates the service before provisioning completes; check the service state and ensure the normal cron is running for subsequent updates.

Check the first service

Review the instance or cluster state, the connection details and the access controls. A pending resource is not ready for application connections.

Creating a real service creates provider resources and can incur provider charges. Review the configuration first; use your normal controlled test process for the first provisioning rather than making an order solely to browse the settings.

Explore the module

See the PD AWS SQL Server for Blesta module page for the current product details.

AWS SQL Server task guides

• Connect an AWS account to PD AWS SQL Server in Blesta
• Test the AWS connection for PD AWS SQL Server in Blesta
• Configure a SQL Server database package in Blesta
• Choose an AWS region for PD AWS SQL Server in Blesta
• Choose a SQL Server database plan in Blesta with PD AWS SQL Server
• Plan public or private SQL Server access with PD AWS SQL Server in Blesta
• Investigate a pending SQL Server service in Blesta with PD AWS SQL Server
• Start, stop or reboot a SQL Server database in Blesta
• Take a SQL Server database snapshot in Blesta
• Delete an unneeded SQL Server database snapshot in Blesta
• Check SQL Server database CPU, connections and storage in Blesta
• Plan SQL Server database backup recovery for a Blesta service
• Connect SSMS to a PD AWS SQL Server service in Blesta
• Create an application database with PD AWS SQL Server in Blesta