AzureSQL How To Do Azure AD Authentication with SSIS in VM Running SQL Server June 7, 20181166 views0 Share By IG Share Can you do Azure AD Authentication with SSIS running in a Virtual Machine on the cloud? Short answer – No. In case if you want to know why it is so, read along to understand more. Azure AD Authentication with SSIS Azure AD issues tokens and centrally managed identities for users authenticating against it. Now, for the traditional SQL Server on-premises services like Integration Services (SSIS), it either supports AD or SQL Auth (Basic Authentication). It cannot use currently authentication against identity providers which issues tokens. See the following options in the following screenshot: Even though I was able to authenticate with a web app entry in AAD, I do not see a way to get around the Azure SQL DB connection. See below: With Microsoft’s Azure Feature Pack, it gives you the following Connection Managers. Azure Storage Connection Manager Azure Subscription Connection Manager Azure Data Lake Store Connection Manager Azure Resource Manager Connection Manager Azure HDInsight Connection Manager So, in a nutshell, you cannot have a source or destination with SQL Database using an AAD authentication method at the time of writing this post. As an alternative, the SSIS integration for Azure lets you create a Data Factory “Managed Service Runtime,” and it is adequately documented on the Microsoft website. We hope this post was helpful. Feel free to send us suggestions in the comment section below. Disclaimer: The Questions and Answers provided on https://www.gigxp.com are for general information purposes only. We make no representations or warranties of any kind, express or implied, about the completeness, accuracy, reliability, suitability or availability with respect to the website or the information, products, services, or related graphics contained on the website for any purpose. Share What's your reaction? Excited 0 Happy 0 In Love 0 Not Sure 0 Silly 0 IG Website Twitter
TSQL How to Effectively split a string using STRING_SPLIT function in SQL server By DataGeekApril 15, 2019
Azure Azure SQL Managed Instance General Purpose vs Business Critical In this article, I will try to compare the Azure SQL Managed Instance General Purpose ...
Azure Azure SQL DTU to vCore Migration Steps for PAAS Databases on Cloud In this article, we are going to talk about Azure SQL DTU to vCore Migration. ...
Azure How To Change Azure SQL DB MAXDOP Settings Using T-SQL Command In this article, we are going to discuss how to change Azure SQL db MAXDOP ...
Azure How To Delete Azure Account Subscription Permanently & Cancel Pay If you want to delete Azure Account Subscription completely, then this article is for you. ...