Linked Server with Azure Active Directory Authentication

Copper Contributor

Hi,

 

I've created a linked server to another SQL Server (target database) using Azure Active Directory Authentication but the below error occurs. 

BooBooTrains_2-1667376885154.png

 

However, I'm able login to the target database using the same credential, from SQL Server Management Studio

BooBooTrains_1-1667376752822.png

 

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