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
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!
Recent Answers
- Joshua Engel on Why fry rice before boiling?
- haakon.io on Why fry rice before boiling?
- Jon Church on Why fry rice before boiling?
- Lex on Does Google Analytics track 404 page responses as valid page views?
- Peter Machado on Why fry rice before boiling?
Recent Questions
- How can I transform graph image into a tikzpicture LaTeX code?
- How Do I Get The Ifruit App Off Of Gta 5 / Grand Theft Auto 5
- Iv’e designed a space elevator using a series of lasers. do you know anybody i could submit the designs too that could manufacture the concept and put it to use
- Need help finding a book. Female OP protagonist, magic
- Why is the WWF pending games (“Your turn”) area replaced w/ a column of “Bonus & Reward”gift boxes?