RVR-MSS-825

1. Issue Summary

   • The error code RVR-MSS-825 with the description "Connection missing field" indicates that there is an issue with the Azure SQL data connector configuration in Data Integration. This error often arises when important connection fields such as Host, Port, Database, Username, or Password are not correctly specified. This can result in the connector being unable to establish a connection to the Azure SQL database.

2. Action Steps:

   • Verify that all necessary connection fields are filled in within the Data Integration platform:
     1. Connection Setup Verification:
        • Ensure that you have specified the Host, Port, Database, Username, and Password when setting up the connection.
        • Check if you've used the correct authentication method (e.g., Azure Active Directory).
     2. IP Whitelisting:
        • Ensure that Data Integration IP addresses are whitelisted on your Azure SQL server. You can configure these under the firewall settings in the Azure portal.
     3. Use the Test Connection Feature:
        • In Data Integration, use the "Test Connection" feature to verify if the connection settings are correct. This can help identify missing or incorrect field entries.
     4. Review Documentation:
        • For complex setups, refer to Azure SQL-specific documentation from Data Integration for detailed guidance on connection configurations.

3. External References:

   • Data Integration Documentation for Azure SQL Connectors for further setup instructions and troubleshooting specific to Azure SQL and general connection guidelines.
   • Microsoft Azure SQL Authentication Methods for more details on how to set up your Azure SQL environment to accept connections from Data Integration.

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