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 d...
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
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