RVR-SYNP-321

1. Issue Summary

   • The error "Failed creating database credentials. Error Code: RVR-SYNP-321" for Azure Synapse indicates that there was a problem with establishing or validating the credentials used to connect to the database. This can often be due to incorrect or missing information such as username, password, or network permissions.
   • Initial diagnosis suggests that there's an issue with the configuration settings required for creating or validating the database credentials within Azure Synapse.

2. Action Steps:

   • Verify Credentials: Double-check the username and password used for the connection to ensure they are correct.
   • Check Database Role Permissions: Ensure that the user has the necessary permissions to access and modify the database in Azure Synapse. You may need to grant specific permissions or roles to the user.
   • Network Permissions: Make sure that the IP addresses used by Rivery are whitelisted in your Azure Synapse firewall settings. This is crucial for allowing external access.
   • Configuration Settings: Verify that all configuration settings in the Azure Synapse connection are correct, including server name, database name, and any specific options required by Synapse.
   • Review Documentation: Review the Rivery documentation for connecting to Azure Synapse to ensure that all prerequisites and setup steps have been followed correctly. You can find the relevant documentation here by navigating to the Azure Synapse section.

3. External References:

   • Rivery Official Documentation for Data Connectors: Rivery Docs

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