RVR-MSS-703

Issue summary

The error code RVR-MSS-703 with the message "External Error - SAS Token is required" indicates an issue when connecting to Azure SQL through the Data Integration platform. The error confirms that a Shared Access Signature (SAS) token is missing. This token is required for connection and operations within Azure.

This issue commonly arises when the SAS token required to authenticate and authorize connections to Azure resources, such as Blob Storage or SQL Database, is not provided in the Data Integration configuration. The connection setup for Azure resources generally requires this token to validate and grant appropriate access without revealing the storage account's credentials.

Action steps

To resolve the error, follow these steps:

1. Retrieve SAS token:

   • You need to generate a SAS token that grants the necessary permissions for accessing the Azure resource.
   • Follow the Microsoft SAS Token topic to create a SAS token.

2. Configure SAS token in Data Integration:

   • Once you have the SAS token, ensure to enter it correctly in the connection settings within Data Integration. This involves updating the Azure SQL connection configuration to include the SAS token.
   • Refer to the Configure Azure Blob Storage in Data Integration topic for detailed steps on configuring Azure Blob Storage connections with a SAS token.

3. Test connection:

   • Use the Test Connection feature in Data Integration after updating the configuration to ensure that the connection to the Azure resource is established successfully.

4. Check permissions:

   • Verify that the permissions granted by the SAS token are adequate for the operations you intend to perform through Data Integration.

External references

For more information on Azure SQL Connection, refer to Data Integration Azure SQL connection topic.

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.