Nov 02 2022 01:16 AM
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!
Nov 02 2022 03:49 AM
@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
Nov 02 2022 07:30 PM