四硅捕鱼机真能海水淡水通吃吗

書名： Instant SQL Server Analysis Services 2012 Cube Security
作者名： Satya SK Jayanty
本章字數(shù)： 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 Users and Groups folder.
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.

官术网_书友最值得收藏!

Instant SQL Server Analysis Services 2012 Cube Security

How to do it...

Note