TransWikia.com

SQL Server Linked Server to Azure SQL using Azure AD

Database Administrators Asked by tbdevmanager on November 15, 2021

I am trying to set up a linked server from an on-prem SQL Server to an Azure SQL instance. The Azure SQL instance uses Azure AD for authentication. When we attempt the connection we get this error
enter image description here

The server it can not open is the piece after the @ symbol in the typical azure ad user name ie:[email protected]

I have searched the internet for answer and I can not find any reference to used Azure AD for a linked server connection. Is this simply not possible?

One Answer

Not possible today. AD auth works, AAD auth is not implemented in linked servers. I have not tried ADFS, however.

Answered by Conor Cunningham MSFT on November 15, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP