After upgradation of SQL server from 2016 to 2022 we are unable to connect with azure storage account using polybase managed identity.

Question

Hi,

We have implemented Poly base mechanism to retrieve data from azure storage to SQL Server. However, we are able to connect with storage account using poly base with SAS token in SQL server 2016. As per the documentation SQL server 2022 supports Poly base with managed identity, So, we have upgraded the version to SQL server 2022. In our case it is creating the external table, but we are getting the error while retrieving data from newly created external table. Occurred Error is --> "Azure Active Directory authentication to Azure Storage is not allowed in BULK INSERT/OPENROWSET."

Could you please suggest what was the possible solution to achieve polybase with managed identity.

Answer 1

Hi，Tarun Chinni (TATA CONSULTANCY SERVICES LTD)

Is the SQL Server you mentioned running on-prem?

For an on-prem SQL Server, you will need to rely on storage access keys or SAS tokens to access the Azure storage account, as managed identities are only applicable to managed services on Azure

Reference link:

Grant limited access to Azure Storage resources using shared access signatures (SAS)

Access data from a file stored on Azure Blob Storage

Use a managed identity for an external source

Best Regards,

Mikey Qiao

---

If you're satisfied with the answer, don't forget to "Accept it," as this will help others who have similar questions to yours.