none
AAD Authentication for Azure SQL

    Question

  • I am able to create Linked Service for Azure SQL  in the portal and verified it is working fine but could not see complete JSON code to automate creation using Power Shell script. Azure link provides Sample JSON payload  but User ID & Password fields are misleading . Why this fields are needed here as I am using AD authentication . Can you provide me the way to get  connection string  that gets generated from portal or provide me valid connection string which use Service Principal authentication.

    Thursday, March 29, 2018 9:43 AM

All replies

  • You can find the sample of connection string here: https://azure.microsoft.com/en-us/updates/azure-data-factory-supports-aad-authentication-for-azure-sql-database-and-sql-data-warehouse/
    Wednesday, April 11, 2018 11:34 PM