For an overview of supported versions per database type, please refer to the Compatibility Matrix.
- When you connect to a Microsoft SQL Server database server, Identity Director uses SQL Server authentication by default. You can also use Windows authentication.
- You can use protocol encryption to secure communication between the Datastore and the components that connect to it.
- You can configure Microsoft SQL Server to listen on a different port than the default one.
Prerequisites Microsoft Azure SQL Database
- Microsoft Azure account
Before you can create a Datastore in Identity Director, you first need to create a database server on Microsoft Azure SQL Database:
- Log in to your Microsoft Azure Management Portal.
- Click New in the lower left corner.
- In the wizard, select Data Services > SQL Database > Quick Create.
- In the Database Name field, specify the name of a temporary database.
- In the Server field, select New SQL database server.
- In the Region field, select your region (e.g. East US when located in New York, North Europe when located in London).
- Specify a login name and its password.
- The first login that you create is assigned as the Administrator account of the SQL database server.
- The password is case-sensitive and must meet the Azure password complexity rules. 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.
- Click Create SQL Database.
- When the database has been created, open the database dashboard.
- Write down the SQL Database server name (i.e. <servername>.database.windows.net). You need this server name to specify the connections settings in Identity Director.
- Click the link Manage allowed IP addresses to allow the current machine to talk to AZURE SQL SERVER.
- Click ADD TO THE ALLOWED IP ADDRESS.
- Click SAVE.
- Log in to the Setup and Sync Tool.
- At Setup > Datastore, click Create.
- In the wizard, specify the name and credentials of the SQL Database server that you just created on Microsoft Azure SQL Database.
- Complete the remaining steps of the wizard. Any credentials that you create must meed the Azure password complexity rules.
- MySQL DBA credentials
Setup and Sync Tool and Management Portal
- MYSQL ODBC Driver