Adding a Sage 100 SQL site in the Sage Provisioning Portal

Use this procedure to add a Sage 100 SQL site in the Sage Provisioning Portal.

To add a Sage 100 SQL site

  1. In the Sage Provisioning Portal, select Organizations > Customers.
  2. On the Customers page, select the customer you're adding a site for.
  3. On the Customers details page, click the Environment tab to view existing sites and users for the customer.
  4. In the Sites section, click Add site.
  5. In the Add the new site to [customer] window, on the Site information page:
    1. Enter the site name and short name.
    2. Select Sage 100 SQL for the product.
    3. Select 2023pu1_sql_202401 (Full version) for the product version.
    4. Select the Azure subscription and applicable time zone, and then click Next.
  6. On the Environment page:
    1. Switch off the Platform suggested size.
    2. Select custom size Large Standard_B8ms for the virtual machine, and then click Next.
  7. On the Users page:
    1. Enter the default administrator for the site.
    2. Add additional users if necessary.
    3. Click Finish.

The site status is set to Pending Acceptance. An email is sent to the administrator selected on the Users page. The email contains a link the administrator must click to accept the terms and conditions for the site.

After the administrator accepts the terms and conditions, the site will be provisioned. When the provisioning process is complete, the site status changes to Ready.

Note: The Sage 100 SQL site defaults to use the Pay As You Go option for the SQL server license in the Azure portal. To change the license option:

  • In the Sage Provisioning Portal, take note of the short name at the Internal name field in the Infrastructure section for the Sage 100 SQL site
  • Open the Azure portal and select the short name for the SQL virtual machine, and then select Settings > Configure to select the SQL server license option.