I need to create SQL DW link server with Azure Active Directory (AAD) credentials.
I tried with windows and AAD Service Account but received an error:
Login failed for user ‘Domain\username’. (Microsoft SQL Server, Error: 18456)
Please let me know is there any way to achieve this. Thanks in advance!