Product Documentation

Microsoft SQL Services

Jun 05, 2015
Citrix CloudPortal Services Manager supports hosting Microsoft SQL Server 2005 and 2008. Multiple SQL databases can be provisioned to a customer and the customer can then assign users to the databases.

The customer's databases can be provisioned to different SQL servers or instances, depending on the resource configuration. Additionally, the SQL servers and instances that form resellers' SQL service offerings can be configured.

To provision the SQL service to resellers

  1. From the Services Manager menu bar, click Customers and select the reseller for whom you want to provision the Microsoft SQL Server Hosting service.
  2. Under Customer Functions, select Services. The reseller's Customer Services page appears.
  3. From the services list, select Reseller.
  4. Select the Microsoft SQL Server Hosting check box and then select the Microsoft SQL Server Hosting service name. The Reseller Service Setup page appears.
  5. Under Servers and Resources, expand the server collection tree and select the database servers and instances that the Reseller can offer its customers.
    Note: When you expand the database server node, the available instances appear. If an instance has been provisioned already to a customer, the instance cannot be selected for provisioning.
  6. In the Customer Plan table, select the check box for each customer plan the reseller can offer its customers.
  7. Under Resource Configuration, configure the following resource limits for the reseller:
    • In Instance Limit, enter the number of SQL databases the reseller can offer.
    • In Database Disk Limit (MB), enter the total amount of database storage allotted to the reseller.
  8. Click Apply Changes to save your selections.
  9. Click Provision to enable the reseller to offer Microsoft SQL Server hosting services.

To provision the SQL service to customers

Before provisioning the Microsoft SQL Server Hosting service, database resources must be configured for the customer. If you attempt to provision the service without configuring resources, the following error appears:

"No SQL server instances are available for the selected customer plan. Please select a different package or contact your service provider for server access."

  1. From the Services Manager menu bar, click Customers > Customer Services.
  2. In Customer Search, find the customer for whom you want to provision the Microsoft SQL Server Hosting service.
  3. In the services list, select Microsoft SQL Server Hosting configure resources and perform the following actions:
    1. On the Service Setup page, under Servers and Resources, expand the server collection tree and select the check boxes for the servers and instances that can be allocated to the customer.
    2. Click Save to save your selections.
  4. In the services list, select Microsoft SQL Server Hosting create an instance The Microsoft SQL Server Hosting Service Instance page appears.
  5. In Instance Name, enter a name that does not contain spaces or special characters and then click Create. The Instance Setup page appears.
  6. Under Service Package Configuration, in Customer Plan, select the template to assign to the customer.
    Note: The customer plan defines the initial size of the database, the database's maximum size, and the grow sizes of the database and log files. The plan also specifies the servers hosting the database.
  7. Under SQL Server Hosting Configuration, in Database Server Instance, select the instance to assign to the customer. If only one instance is enabled, this field appears dimmed.
  8. Click Advanced Settings and perform the following actions:
    1. Under User Plans, enable or disable the levels at which the customer can provision users.
    2. Under Maximum Users, select the Enabled check box and enter the maximum number of users the customer can provision.
    3. Under Billing, ensure the Enabled check box is selected so the service generates charges to the customer.
  9. Click Provision to enable the customer to provision users.