You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
Version 1
Next »
Prerequisites
- SQL Compliance Manager 7.0 installed on a machine.
- Azure SQL Managed instance .
- Blob storage account with container and SAS token for access. For the blob storage make sure that:
- Default access tier is "Hot".
- It's best practice for the Storage Account to be located in the same region where the monitoring SQL instance will be (e.g North Europe).
- Ensure the "Enable storage account key access" setting is checked. The option is available during creation, or under the "Configuration" blade afterward.
- Make sure that the storage account is accessible from the SQL-managed instance.
- When generating a Shared Access Signature, make sure its expiry is sufficient in the future. Upon expiry, the SAS token would have to be updated from the SQL Server itself.