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:something@company.com

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?


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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.