- Instant SQL Server Analysis Services 2012 Cube Security
- Satya SK Jayanty
- 248字
- 2021-08-13 16:32:04
How to do it...
In order to create security it is essential to create a Windows user and group that will enable the remaining recipes in this book to proceed. Here we will browse through the Windows Server 2008 R2 operating system options.
Once the prerequisites mentioned in the preceding Getting ready section are completed, follow these steps:
- Navigate to Start | Control Panel and choose Administrative Tools, then open the Computer Management (Local) program.
- Expand the
Local UsersandGroupsfolder. - Right-click on Users to create a new user. For the sake of this recipe I have created a user named
DBIA_BI_User. - Right-click on Groups to create a new group, name the group as
BI_User, add the newly created user DBIA_BI_User, and click on OK. - To relate to the preceding steps you should have similar properties shown as per the following screenshot:
- Now the initial requirement of a local user and group on the server is completed, let us jump into SQL Server Management Studio that is specific to Analysis Services instance security.
- Open the SSMS and choose Connect to Analysis Services… (AS) instance.
- Right-click on the selected AS instance and choose Properties.
- Within that Properties page select the Security option that will show the default Server administrators.
Note
Further we can choose the corresponding local or domain group to be part of the Server Administrators role. For the purpose of this recipe we can skip the option of adding any additional group at this moment.