RVR-MSS-822

1. Issue Summary

   • You are encountering the error "Connection missing fieldError Code: RVR-MSS-822" when trying to connect to an Azure SQL database using Rivery. This indicates that a mandatory field in the connection configuration might be missing or incorrectly set.

2. Action Steps:

   • Check Connection Configuration:
     • Ensure that all mandatory fields are correctly filled in your Azure SQL connection settings in Rivery. Key fields include:
       • Connection Name
       • Host (Server name)
       • Port Number (default is usually 1433)
       • Database Name
       • Authentication Method (make sure to select if it is SQL Authentication or Azure Active Directory)
       • Username and Password
   • Test Connection:
     • Once you've verified all fields, use the "Test Connection" function in Rivery to check if the connection details are correct and working【4:2†Rivery Documentation 202408 (2).pdf】.
   • Review Access Permissions:
     • Ensure that the IPs used by Rivery are whitelisted in your Azure SQL firewall settings to allow traffic【4:16†Rivery Documentation 202408 (2).pdf】.
   • Reconnect if Necessary:
     • In some cases, reconnecting to your Azure SQL account can resolve the issue. This may be necessary if recent changes were made to your configurations or credentials【4:0†Rivery Documentation 202408 (2).pdf】.

3. External References:

   • For more details on setting up an Azure SQL connection in Rivery, consider reviewing the official documentation at Rivery Azure SQL Connection Procedure.

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