0
votes

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!

1
Do you have the option of using the username@domain instead? (which could be username@domain.onmicrosoft.com)Jean-Marc Prieur
Please clarify what is connecting to what, and the actual code that you tried.Nick.McDermaid

1 Answers

1
votes

Linked servers are not supported from Azure SQL Data Warehouse.

If you're trying to connect from SQL Server to Azure SQL Data Warehouse, you might find these note helpful:

https://blogs.msdn.microsoft.com/sqldw/2016/04/12/connecting-a-linked-server-to-azure-sql-data-warehouse/