Skip to main content
Feedback

RVR-MSS-702

Issue summary

The error codeRVR-MSS-702 indicates a connection failure with Azure SQL in Data Integration. This error suggests an issue establishing a connection to the Azure SQL database from Data Integration platform. Possible causes range from network connectivity issues and incorrect credentials to IP allowlisting problems and configuration errors in Azure SQL settings.

As per Data Integration documentation, this error occurs due to incorrect configuration settings or connectivity issues between Data Integration and Azure SQL. Verifying configurations and network settings is necessary.

Action steps

To resolve the error, follow these steps:

  1. Verify credentials: Ensure the username and password provided to Data Integration for the Azure SQL connection is correct. Incorrect credentials can cause connection failures.
  2. IP allowlisting: Confirm that Data Integration IP addresses are allowlisted on your Azure SQL server. Missing or incorrect allowlisting can lead to connectivity issues.
  3. Network and firewall: Check that no firewall settings block the connection from Data Integration to Azure SQL. Make sure the firewall permits access to Azure services and to any necessary client IPs.
  4. SQL Server settings: Verify that your Azure SQL server is configured to accept incoming connections. Ensure that the SQL Server agent, if required, is running.
  5. Test connection: Use the Test Connection feature in Data Integration to verify the connection is established. This can help identify whether changes take effect.
  6. Check Azure Service status: The connection failures are due to service disruptions in Azure. Check the status of Azure services to ensure that there is no ongoing outage.

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