RVR-MSS-701

1. Issue Summary

   • Error Code: RVR-MSS-701
   • Data Connector: Azure SQL
   • Error Description: External Error - Connection failed

   Diagnosis: The error code "RVR-MSS-701" indicates a connection failure when attempting to connect to an Azure SQL database through Rivery. This can be attributed to several potential issues, including network connectivity problems, incorrect connection settings (like host, port, etc.), firewall settings not allowing the connection, or incorrect credentials.

2. Action Steps:

   • Check Network and Firewall Settings: Ensure that the necessary IP addresses are whitelisted on the Azure SQL server and that there are no network issues preventing the connection. You can find the IP addresses to whitelist from Rivery's documentation.
   • Verify Connection Parameters: Double-check that the host, port number, database name, username, and password are all correctly entered in Rivery.
   • Test the Connection: Use Rivery’s "Test Connection" feature to verify if the connection is functional.
   • Enable Azure Active Directory: If using Azure Active Directory for authentication, ensure it is configured properly according to the guidelines for connecting Rivery to Azure SQL.
   • Review Logs for Additional Errors: If the above steps do not resolve the issue, review the logs in Azure SQL for any specific error messages that may provide more insight into the failure.

3. External References:

   • Rivery's Documentation on Azure SQL Connection
   • Microsoft Azure SQL Database Connectivity Troubleshooting

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