RVR-MSS-824

1. Issue Summary

   • The error code RVR-MSS-824 indicates that a required field is missing when attempting to connect to an Azure SQL database using Data Integration platform. This is often related to not providing one or more necessary connection parameters in the connection configuration.

2. Action Steps:

   • Verify Connection Parameters: Ensure that all required fields are filled out in the Data Integration connection setup for Azure SQL. These typically include Host, Port, Database, Username, and Password.
   • Authentication Method: Depending on whether you're using SQL Server Authentication or Azure Active Directory, ensure that corresponding credentials and configurations are provided.
   • Whitelist IPs: Make sure that Data Integration IPs are whitelisted in your Azure SQL server settings.
   • Check for typos or missing entries in the connection configuration screen.
   • Test the Connection: Use the "Test Connection" feature within Data Integration to verify if the connection details are correct and communication is established.

3. External References:

   • Data Integration documentation on setting up Azure SQL connections: Data Integration Azure SQL Connection Setup
   • Microsoft Documentation on Azure SQL Database Connectivity: Azure SQL Connectivity Architecture

If the issue persists or you need further assistance, please open a ticket with Data Integration support.