PD AWS SQL Server lets you offer Amazon RDS for SQL Server instances through WHMCS, 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 WHMCS first, connect the account that holds your licence, then install PD AWS SQL Server from its Store. Allow the administrator role 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

Add the provider connection under System Settings → Servers, selecting this module for the server record. Assign the appropriate server group to the product. Keep provider credentials on the connection, separate from the product’s resource defaults.

Define what the customer receives

Create a product using PD AWS SQL Server and review its Module Settings and configurable options. Start with Region, Plan, Backing service 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 product 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

Set the product’s automatic-setup behaviour deliberately. If you want provisioning after payment, select that option rather than leaving setup manual. Keep the normal cron running for subsequent status and usage 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 WHMCS module page for the current product details.

AWS SQL Server task guides

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