Boomi · Data Integration: Azure SQL

RVR-MSS-501: Azure SQL external general error

Short answer

RVR-MSS-501 is an external general error from the Azure SQL connector, usually server settings or network connectivity. Check the Azure SQL firewall and the credentials' rights.

VerifiedLast verified

01Error text

Boomi error
Error Code: RVR-MSS-501

02Likely causes

  • Connectivity or configuration problems, often Azure SQL server settings or network connectivity.

03How to fix it

  1. Check the Azure SQL firewall settings for IP address restrictions.
  2. Confirm the credentials have the needed rights on the databases and tables.
  3. Test the connection outside Data Integration with a SQL tool such as Azure Data Studio.
  4. Review the logs in Azure SQL and in Data Integration.

04Official documentation

Test every fix in a non-production environment before you apply it to production. See how entries are verified.

More for Boomi work:Open Boomi jobsBoomi rates and salaries

The iPaaS Brief

Subscribe to The iPaaS Brief.

The iPaaS newsletter for the people who run integrations. From iPaaS Group.

Free. You finish on theipaasbrief.com and confirm by email.