Forum Discussion
Linked Server with Azure Active Directory Authentication
Hi,
I've created a linked server to another SQL Server (target database) using Azure Active Directory Authentication but the below error occurs.
However, I'm able login to the target database using the same credential, from SQL Server Management Studio
I'm quite new to this. Can anyone help, pls. Thanks!
2 Replies
BooBooTrains , I see "MSOLEDBSQL" provider in the error message.
Which version are you using? Older versions don't support AAD auth.
See
Microsoft OLE DB Driver for SQL Server - OLE DB Driver for SQL Server | Microsoft Learn
Olaf
- Hi Olaf,
Thanks for the reply! I've downloaded and installed the driver but still gets the same error. I've read from the documentation that SQLOLEDB is deprecated but not MSOLEDBSQL. Is it due to my misunderstanding as I'm not familiar in this area? I'm only familiar with SQL and trying to reference to a database on a different server
