I need to create SQL DW link server with Azure Active Directory (AAD) credentials

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
sql-serverazureazure-active-directoryazure-sqldw
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/