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 Rivery. 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 Rivery 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 Rivery's IP addresses are whitelisted on your Azure SQL server. You can configure these under the firewall settings in the Azure portal【4:19†source】.
     3. Use the Test Connection Feature:
        • In Rivery, 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 Rivery for detailed guidance on connection configurations【4:10†source】【4:19†source】.

3. External References:

   • Rivery 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 Rivery.

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