Skip to main content
Feedback

RVR-SYNP-100

  1. Issue Summary

    • The error code RVR-SYNP-100 indicates an issue trying to connect to Azure Synapse using the Data Integration platform. This error typically results from network connectivity issues, IP whitelisting issues, improper configuration settings, or authentication failures.
    • It's crucial to diagnose whether it's a network-related problem or misconfiguration by checking the settings and connectivity options in the Data Integration setup.

  2. Action Steps:

    • Whitelist IP Addresses: Ensure that Data Integration IP addresses are whitelisted in your Azure Synapse firewall settings. This is necessary if you're not using an SSH Tunnel. Check the Data Integration documentation for a list of IP addresses that need to be whitelisted.
    • Correct Credentials: Verify that the connection settings in Data Integration match those required by Azure Synapse. This includes the host, database name, username, and password. Any incorrect detail can prevent a successful connection.
    • Azure Portal Configuration: Make sure that the 'Allow access to Azure services' option is enabled in the Azure portal firewall settings for your Azure Synapse Analytics setup.
    • Test the Connection: Use the 'Test Connection' feature in Data Integration to see if the connection settings are correct and the issue persists.
    • Check for Azure Active Directory (AAD) Authentication: If using AAD, ensure that it is correctly configured. Refer to Data Integration guidelines on AAD set up.
    • Review Network and Firewall Logs: Check if there are any blocked requests or unusual activity in your Azure network logs that might indicate connectivity issues.

  3. External References:

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