RVR-MSS-827

1. Issue Summary

   • The error code RVR-MSS-827 relates to a missing field in the connection setup for Azure SQL in Rivery. This error indicates an issue with either the configuration of the connection parameters or the retrieval of necessary metadata during connection establishment. The problem can stem from incomplete or incorrect connection details such as missing host, port, database name, username, password, etc., necessary for establishing a secure connection to Azure SQL.

2. Action Steps:

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

   • 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 Rivery’s IPs.

   • Test Connection:

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

   • Logs and Error Examination:

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

3. External References:

   • For more detailed guidance regarding Azure SQL connections, review the following Rivery documentation link: Rivery Documentation on Connection Setup.
   • Microsoft's own documentation on configuring Azure SQL connections may also provide valuable insights: Azure SQL Database Documentation.

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