How to assign Server Admin role for a user in SSAS

In this blog we shall look at the steps to add a user into the Server Administrators Role in SQL Server Analysis Services (SSAS). Let’s get started..

Connect to the SQL Server Analysis Services from Management Studio (SSMS), once connected, right click on Analysis Server (as shown below) and select Properties. ssas-1Once you click Properties, the Analysis Services Properties dialog box appears, then click Security page, to show the list of users who are currently Server administrators (shown below)..ssas-2 Click on Add button and type the name of the user and click OK button.ssas-3 The user is now part of the Server Administrator group on the Analysis Server now.. To cross check click on the Security page on the Server Properties.ssas-4Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru so that, you know when there is a new blog post.

–Bru Medishetty

Posted in Uncategorized | 1 Reply