当项目服务器2010和SQL DB位于两个不同的服务器中时，分析服务需要什么权限？ [英] What are permission required for analysis services when project server 2010 and SQL DB are in two different servers?

问题描述

Hi Team，

我们已将项目服务器2010及其SQL DB设置在两个独立的服务器中。现在为项目服务器启用多维数据集构建，项目服务器管理员帐户是否需要sql server中的分析服务的管理权限？

请指定项目服务器和数据库所需的权限设置在不同的服务器上？

 

 

---

谢谢，可爱的

解决方案

Hi Lovely Rose 25，

来自
http://technet.microsoft.com/en-gb/library/ee662108.aspx

配置Analysis Services

Project Server 2010可以在Microsoft SQL Server Analysis Services（SSAS）中构建OLAP多维数据集以用于报告。如果计划使用Project Server 2010多维数据集构建功能，则必须将Farm Administrator帐户配置为在SQL Server Analysis Services中为将与Project Server 2010一起使用的Analysis Services实例具有管理权限
。 / p>

将Farm Administrator添加为Analysis Services服务器管理员

1. 
   

   打开SQL Server Management Studio。在连接到服务器窗口中，连接到Project Server 2010中使用的SQL Server 2005 Analysis Services实例。

   
   
2. 
   

   在Microsoft SQL Server Management Studio的对象资源管理器中，右键单击SQL Server 2005 Analysis Services实例名称，然后单击
   属性。

   
   
3. 
   

   在Analysis Services属性页的选择页面窗格中，单击
   安全性 。

   
   
4. 
   

   点击添加。

   
   
5. 
   

   在"选择用户，计算机或组"页面上，键入Farm Administrator帐户的名称。

   
   
6. 
   

   单击确定。 Farm Administrator帐户显示在"成员"列表中。

   
   
7. 
   

   单击确定。

   
   

Hi Team,

We have set up project server 2010 anf its SQL DB in two separate servers. Now for enabling cube building for project server, is administrative permission on analysis service in sql server is required for project server administrator account?

Could you please specify the permissions required when project server and DB is set up in different servers?

 

 

---

Thanks, Lovely

解决方案

Hi Lovely Rose 25,

From http://technet.microsoft.com/en-gb/library/ee662108.aspx

Configure Analysis Services

Project Server 2010 can build OLAP cubes in Microsoft SQL Server Analysis Services (SSAS) for use in reporting. If you plan to use the Project Server 2010 cube building feature, you must configure the Farm Administrator account to have administrative permissions in SQL Server Analysis Services for the instance of Analysis Services that you will be using with Project Server 2010.

To add the Farm Administrator as an Analysis Services server administrator

1. Open SQL Server Management Studio. In the Connect to Server window, connect to the instance of SQL Server 2005 Analysis Services that you are using with Project Server 2010.

2. In Microsoft SQL Server Management Studio, in Object Explorer, right-click your SQL Server 2005 Analysis Services instance name, and then click Properties.

3. On the Analysis Services Properties page, in the Select a page pane, click Security.

4. Click Add.

5. On the Select Users, Computers, or Groups page, type the name of the Farm Administrator account.

6. Click OK. The Farm Administrator account appears in the Members list.

7. Click OK.

这篇关于当项目服务器2010和SQL DB位于两个不同的服务器中时，分析服务需要什么权限？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！