Managing additional Azure SQL servers

If you're installing an application that requires its own Azure SQL server, you can add an Azure SQL Server to the site.

When you create Azure SQL servers and add databases to them, the databases are automatically synchronized with the Sage Provisioning Portal. The synchronization process automatically starts every hour. You can also synchronize them manually. Because the databases are synchronized, you can use the backup and restore features in the provisioning portal.

Notes:  

  • The Sage Provisioning Portal does not create database elastic pools when creating an Azure SQL Server. Any new database must be created in Azure or by the application that you install.
  • When you delete a site, the Azure SQL server and related databases are not deleted.

Because the databases are not created as part of the site creation process, when you delete the site, these databases are not deleted.

  1. From the Sites list, select the site to open the site details page.
  2. In the Database servers panel, click Add SQL Server.
  3. In the New SQL Server window, enter and confirm the password for the SQL server administrator account.

    The password must meet the following requirements:

    • Between 8 and 128 characters
    • Cannot contain all or part of the login name (part is defined as three or more consecutive characters)
    • Must contain at least one character from three of the following characters:
      • An uppercase letter from the English alphabet
      • A lowercase letter from the English alphabet
      • A number
      • A non-alphanumeric character
  4. The server name and server administrator name are automatically created and cannot be changed.
  5. Click Save.

The Azure SQL Server is added to the Database servers list. Initially the status is Creating, and it will switch to Ready within a few minutes.

  1. From the Sites list, select the site to open the site details page.
  2. In the Database servers panel, in the Name column, click the Azure SQL server name.

    The Azure SQL server details window opens showing the following fields:

    • Name: the URL for the Azure SQL server (You'll need this to connect to the server.)
    • Server admin: administrator account user name
    • Server logins panel: Displays the logins that have been created (For security purposes the default login is not shown.)
    • Databases panel: shows the databases that have been created in the Azure SQL server

    The following buttons are available in the Operations area:

    • Set server admin password: Click to set a new password for the database administrator.
    • Sync databases: Click to manually synchronize the databases in Azure with the Sage Provisioning Portal.
    • Delete server: Click to delete the Azure SQL server. You can delete a server only if it contains no databases.
  1. From the Sites list, select the site to open the site details page.
  2. In the Database servers panel, in the Name column, click the SQL server name. The SQL server details window opens.
  3. In the Server logins panel, click Add Login. The Add Login window opens.
  4. In the Name field, enter a user name.

    Note: The field contains a view-only area with text that is automatically added to the beginning of the user name.

  5. Enter and confirm the password.

    The password must meet the following requirements:

    • Between 8 and 128 characters
    • Cannot contain all or part of the login name (part is defined as three or more consecutive characters)
    • Must contain at least one character from three of the following characters:
      • An uppercase letter from the English alphabet
      • A lowercase letter from the English alphabet
      • A number
      • A non-alphanumeric character
  6. Click Save.

The login account is added to the Server logins panel. Initially the status is Pending while the account is being created. The status will then change to Active.

Tip: Click the Refresh button to refresh the status list.

  1. From the Sites list, select the site to open the site details page.
  2. In the Database servers panel, in the Name column, click the SQL server name. The SQL server details window opens.
  3. In the Databases panel, in the Actions column, click the Manage Logins button. The Manage login accounts window opens.
  4. In the Database users panel, click Assign login. The Assign login account window opens.
  5. In the Login field, select the login.
  6. In the Roles area, select one or more roles for the account.
  7. Click Save.

The login account is added to the Database users panel. Initially the status is Pending. The status will then change to Active when the login account has been added to the database.

  1. From the Sites list, select the site to open the site details page.
  2. In the Database servers panel, in the Name column, click the SQL server name. The SQL server details window opens.
  3. In the Server logins area, in the Actions column, click the Set password button. The Set login password window opens.
  4. Enter and confirm the new password.
  5. Click Save.
  1. From the Sites list, select the site to open the site details page.
  2. In the Database servers panel, in the Name column, click the SQL server name. The SQL server details window opens.
  3. In the Databases panel, in the Actions column, click the Manage Logins button. The Manage login accounts window opens.
  4. In the Database Users panel, in the Actions column, click the Edit button. The Edit database user roles window opens.
  5. In the Roles area, select or clear the role checkboxes as needed to assign or unassign roles.
  6. Click Save.