Microsoft Azure SQL

Supported databases

  • Microsoft Azure SQL

Other prerequisites

Database

  • Microsoft Azure account

Preparations for creating a Datastore on Azure SQL

Before you can connect a Datastore in the Management Portal, you need to create a database server on Microsoft Azure SQL Database:

  1. Log in to your Microsoft Azure Management Portal.
  2. Click New in the lower left corner. This opens a wizard.
  3. Select Data Services > SQL Database > Quick Create.
  4. In the Database Name field, specify the name of a temporary database.
  5. In the Server field, select New SQL database server.
  6. In the Region field, select your region (e.g East US when located in New York, North Europe when located in London).
  7. Specify a login name and its password.
    • The first login that you create is the Administrator account of the SQL database server.
    • The password is case-sensitive and must meet the Azure password complexity rules, otherwise creation fails. The default Azure password complexity rules: minimum length of 8 characters, minimum of 1 uppercase character, minimum of 1 lowercase character, minimum of 1 number.
  8. Click Create SQL Database.
  9. When the database has been created on Microsoft Azure SQL Database, open the database dashboard.
  10. Write down the SQL Database server name (i.e. <servername>.database.windows.net). You need this server name when you specify the connections settings in Ivanti Identity Director.
  11. Click the link Manage allowed IP addresses to allow the current machine to talk to AZURE SQL SERVER.
  12. Click ADD TO THE ALLOWED IP ADDRESS.
  13. Click SAVE.