RVR-MSS-712

1. Issue Summary

   • The error "External Error - SAS Token is required" with Error Code RVR-MSS-712 indicates that while using the Azure SQL data connector in Data Integration, a Shared Access Signature (SAS) Token is missing. This token is essential for authentication and authorization when accessing Azure services. Typically, SAS tokens are used in scenarios where a specific resource access needs to be granted without sharing the account key.

2. Action Steps:

   • Generate a SAS Token:
     • Navigate to the Azure portal and open the storage account you wish to connect to.
     • Under the "Security + networking" section, select "Shared access signature."
     • Configure the permissions, protocols, start, and expiry times as required.
     • Generate the SAS token and copy the necessary fields (Token, SAS URL).
   • Configure the Connection in Data Integration:
     • In your Data Integration console, go to the connection settings for Azure SQL.
     • Enter the generated SAS Token in the appropriate field. This is mandatory when using the Blob Storage as a custom FileZone but optional for other uses.
   • Test the Connection:
     • Use the "Test Connection" feature in Data Integration to ensure the configuration is set correctly. If successful, proceed with your River operations.

3. External References:

   • For more details on generating SAS tokens, refer to the Microsoft Documentation.
   • Data Integration comprehensive guide on Azure Blob Storage Connection.

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