Add a service principal to the server administrator role

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.

Before you begin

Before completing this task, you must have a service principal registered in Azure Active Directory.

Create service principal - Azure portal
Create service principal - PowerShell

Required permissions

To complete this task, you must have server administrator permissions on the Azure AS server.

Add service principal to server administrators role

  1. In SSMS, connect to your Azure AS server.

  2. In Server Properties > Security, click Add.

  3. In Select a User or Group, search for your registered app by name, select, and then click Add.

    Search for service principal account

  4. Verify the service principal account ID, and then click OK.

    Search for service principal account

Note

For server operations using Azure PowerShell cmdlets, service principal running scheduler must also belong to the Owner role for the resource in Azure Role-Based Access Control (RBAC).