Skip to main content
Feedback

RVR-MSS-701

Issue summary

The error code RVR-MSS-701 with the description "External Error - Connection failed" indicates a connection failure when attempting to connect to an Azure SQL database through Data Integration. This can be due to issues such as network connectivity problems, incorrect connection settings (such as host, port, and so on), firewall settings that block the connection, or incorrect credentials.

Action steps

To resolve the error, follow these steps:

  1. Check network and firewall settings: Ensure that the necessary IP addresses are allowlisted on the Azure SQL server and that no network issues are preventing the connection. You can find the IP addresses to allowlist from Data Integration documentation.
  2. Verify connection parameters: Double-check that the host, port number, database name, username, and password are correct in Data Integration.
  3. Test the connection: Use Data Integration’s Test Connection feature to verify if the connection is functional.
  4. Enable Azure Active Directory: If using Azure Active Directory for authentication, ensure it is appropriately configured according to the guidelines for connecting Data Integration to Azure SQL.
  5. Review logs: If the above steps do not resolve the issue, review the logs in Azure SQL for any specific error messages that may provide insights into the failure.

External references

For more information, refer to the following topics:

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.

On this Page