Forum Discussion
Is it possible to Mirror Azure SQL via VNet Gateway with Workspace Identity?
Hi AndrewDMay ,
Workspace identities are not supported for gateway-based connections. That said, according to the documentation you referenced, workspace identity can be used to authenticate directly to an Azure SQL Database, provided the connection does not go through a gateway.
Thank you
Thanks for the information. I see on that page this limitation listed:
Workspace-Identity-based authentication is currently not supported for gateway connections.
But in the tutorial for Mirroring Azure SQL: https://learn.microsoft.com/en-us/fabric/mirroring/azure-sql-database-tutorial there are instructions for using Workspace identity (although a note at the top saying that Entra logins are currently in preview) - so I do think mirroring using Workspace identity may be supported for public Azure SQL databases (with normal caveats about relying ons something in preview).
It feels odd that something that's largely a networking construct (using a gateway) should be tied into the authentication mechanism, but I don't claim to understand how that this all works under the hood.
Hopefully it will be a supported configuration soon - the more things that can use Workspace identity the better.
Hi AndrewDMay ,
Workspace identities are not supported for gateway-based connections. That said, according to the documentation you referenced, workspace identity can be used to authenticate directly to an Azure SQL Database, provided the connection does not go through a gateway.
Thank you