RVR-MSS-823

1. Issue Summary

   • The error code RVR-MSS-823 indicates that a field required for the connection in the Azure SQL data connector is missing. This error suggests that there's a configuration issue in the connection setup, where mandatory fields might not have been properly filled.

   • This commonly happens when required credentials like Host, Port, Database Name, Username, and Password are not specified or incorrectly provided during the connection setup in Data Integration.

2. Action Steps:

   • Check Connection Fields: Go to your Data Integration account, navigate to the connection settings for Azure SQL, and ensure all fields like Host, Port, Database Name, and Credentials (Username and Password) are properly entered.
   • Verify Whitelisted IPs: Ensure that Data Integration IP addresses are whitelisted in your Azure SQL server configurations. This is necessary to allow Data Integration to communicate with your Azure SQL database.
   • Test Connection: Use the "Test Connection" feature in Data Integration to verify that all setup details work correctly.
   • Save & Retry: After verifying and making any necessary corrections, save the connection settings and attempt to run your river again.

3. External References:

   • For detailed setup guidelines, refer to the Data Integration Azure SQL Connection Documentation.
   • Azure SQL official configuration guidelines might also be helpful: Azure SQL Server Firewall Configurations.

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