RVR-MSS-823

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.

Action steps

To resolve the error, follow these 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 Allowlisted IPs: Ensure that Data Integration IP addresses are allowlisted 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.

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.

note

If the issue persists or you need further assistance, open a case with Data Integration Support. In the console sidebar, select Help > Contact Us and follow the instructions.