RVR-MSS-827

Issue summary

The error code RVR-MSS-827 relates to a missing field in the connection setup for Azure SQL in Data Integration. This error indicates an issue with the configuration of the connection parameters or the retrieval of necessary metadata during connection establishment. The problem is due to incomplete or incorrect connection details such as missing host, port, database name, username, password, and so on., necessary for establishing a secure connection to Azure SQL.

Action steps

To resolve the error, follow these steps:

1. Verify Connection Details:

   • Ensure all necessary fields such as Host, Port, Database, Username, and Password are properly filled in your connection setup.
   • If using Azure Active Directory for authentication, confirm all relevant credentials are accurate and have the required permissions.

2. Review Permission Settings:

   • Confirm that the user has the necessary permissions to access the Azure SQL database. Ensure that any firewalls or network security settings allow traffic from Data Integration’s IPs.

3. Test Connection:

   • Use the "Test Connection" feature in Data Integration to verify if your setup is correct and the connection can be successfully established.

4. Review Logs and Errors:

   • Check the logs for any additional error messages that might provide more context or point out specific missing fields or misconfigurations.

External references

• For more detailed guidance regarding Azure SQL connections, refer to Data Integration Connection Setup topic.
• For more information on configuring Azure SQL connections, refer to Microsoft's documentation Azure SQL Database topic.

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.