How to use Azure SQL services in Cayosoft Administrator SQL provisioning rules

Summary: This article contains step-by-step instructions on how to configure the Azure SQL Database and then use it in the Cayosoft Administrator SQL provisioning rules such as:

• Import SQL Data | Create Office 365 Users

• Import SQL Data | Update Office 365 Users

• Import SQL Data | Suspend Microsoft 365 Users

• Import SQL Data | Create Office 365 Guest Users

Applies to: Cayosoft Administrator Service 7.3.0 or later

Configuration

1. Sign-in to Microsoft Entra ID Portal - SQL Databases.

2. Click SQL Databases and select the database that you want to use in Cayosoft Administrator SQL provisioning rules. For example, TEST_DB:

   

3. Click Connection Strings and copy ADO.NET (SQL authentication) settings:

   

   Example:

   Server=tcp:azuresql-cayotest.database.windows.net,1433;Initial Catalog=TEST_DB;Persist Security Info=False;User ID=julia;Password={your_password};MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;

4. In the Cayosoft Administrator Console, navigate to Configuration > Connected Systems Extensions > Utils.

5. Check database settings. In the Firewall settings, set Allow Azure services and resources to access this server to No:

   

    

   

6. Open the SQL Server section:

   1. Instance: paste Server value from the connection string that was copied from Azure SQL Database (tcp:azuresql-cayotest.database.windows.net,1433).

   2. Database: paste the Initial Catalog value from the connection string that was copied from Azure SQL Database.

   3. Credentials: specify User ID and password.

      

   4. Click Check Settings to be sure that settings are correct.

Now you can use this database in SQL provisioning rules.

Related articles

• Connecting to Microsoft SQL Server data source