RVR-MSS-702

1. Issue Summary

   • Error Code RVR-MSS-702 indicates a connection failure with Azure SQL in Data Integration. This error suggests that there is an issue with establishing a connection to the Azure SQL database from the Data Integration platform. Possible causes range from network connectivity issues, incorrect credentials, IP whitelisting problems, to configuration errors within Azure SQL settings.
   • As per Data Integration documentation, this error typically occurs due to incorrect configuration settings or connectivity issues between Data Integration and Azure SQL. Verifying configurations and network settings is necessary.

2. Action Steps:

   • Verify Credentials: Ensure the username and password provided to Data Integration for the Azure SQL connection are correct. Incorrect credentials are a common cause for connection failures.
   • IP Whitelisting: Confirm that Data Integration IP addresses are whitelisted on your Azure SQL server. Missing or incorrect whitelisting can lead to connectivity issues.
   • Network and Firewall: Check that there are no firewall settings blocking the connection from Data Integration to Azure SQL. Make sure the firewall allows access to Azure services as well as any necessary client IPs】.
   • 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.
   • Test Connection: Use the 'Test Connection' feature in Data Integration to see if the connection can be established. This can help identify whether changes take effect.
   • Check Azure Service Status: Sometimes, connection failures are due to service disruptions in Azure. Check the status of Azure services to ensure that there's no ongoing outage.

3. External References:

   • Data Integration Documentation on Connecting to Azure SQL
   • Azure SQL Database Network Configuration

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