RVR-SYNP-100

Issue summary

The error code RVR-SYNP-100 indicates an issue trying to connect to Azure Synapse using the Data Integration platform. This error results from network connectivity issues, IP allowlisting issues, improper configuration settings, or authentication failures.

Action steps

To resolve the error, follow these steps:

1. Allowlist IP addresses: Ensure that Data Integration IP addresses are allowlisted in your Azure Synapse firewall settings. This is necessary if you are not using an SSH Tunnel. Check the Data Integration documentation for a list of IP addresses that need to be allowlisted.
2. Correct credentials: Verify that the connection settings in Data Integration matches those required by Azure Synapse. This includes the host, database name, username, and password. Any incorrect detail can prevent a successful connection.
3. 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.
4. Test the connection: Use the Test Connection feature in Data Integration to verify the connection settings are correct and the issue persists.
5. Check for Azure Active directory (AAD) authentication: If using Azure Active directory (AAD), ensure that it is correctly configured. Refer to Data Integration guidelines on AAD setup.
6. 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.

External references

For more information, refer to the following topics:

• Getting started with Data Integration
• Microsoft Azure Synapse connection

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.