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 Cayosoft Administrator SQL provisioning rules such as:

• Import SQL Data | Create Office 365 Users rule
• Import SQL Data | Update Office 365 Users rule
• Import SQL Data | Suspend Office 365 Users rule
• Import SQL Data | Create Office 365 Guest Users rule

 Applies to: Cayosoft Administrator 7.3.0 or later  

ID: KB20200831-1

---

Configuration

1. Sign-in to Microsoft Azure Portal
2. Click SQL Databases and select the database that you want to use in Cayosoft Administrator SQL provisioning rules. In this articl let it be TEST_DB:
3. Click Connection Strings and copy ADO.NET (SQL authentication) settings: 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 Cayosoft Admin Console navigate to Home > Configuration > Connected Systems Extensions > Utils
5. Check database settings. In Firewall settings set Allow Azure services and resources to access this server to No:
6. Open 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 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