Not able to connect azure analysis service using sevice principal in SSIS

Question

I am receiving following message “Test connection failed because of an error in initializing provider. The following system error occurred: “ (Without any error description) while trying to connect Azure Analysis Services in SSIS using service principal authentication. Am able to connect via SSMS & Excel using without any issues. Also I am able to connect Test Analysis service connection successfully in SSIS using MFA authentication (using my own ID), but not using service principal.

• Package designed using Visual Studio -2019
• Service principal has been added to Contributor role
• All required client libraries are updated as per this Doc

Please help me to fix this issue.

Answer 1

Hi @Satish Sridharan (Cognizant Worldwide Limited) ,

To automate unattended PowerShell tasks, a service principal must have server administrator privileges on the Analysis Services server being managed. This article describes how to add a service principal to the server administrators role on an Azure AS server. You can do this using SQL Server Management Studio or a Resource Manager template.

Service principals are an Azure Active Directory application resource you create within your tenant to perform unattended resource and service level operations. They're a unique type of user identity with an application ID and password or certificate. A service principal has only those permissions necessary to perform tasks defined by the roles and permissions for which it's assigned.

Please refer to the following links:
1.Add a service principal to the server administrator role
2.Automation with service principals

Best Regards,
Mona

----------

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.