Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
> 
What are permission required for analysis services when project server 2010 and SQL DB are in two different servers?

Proposed Answer What are permission required for analysis services when project server 2010 and SQL DB are in two different servers?

  • Friday, January 06, 2012 6:21 AM
     
     
    Sign In to Vote
    0

    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
     

All Replies

  • Friday, January 06, 2012 7:58 AM
    Moderator
     
     Proposed Answer
    Sign In to Vote
    0

    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.

    Ben Howard [MVP] blog | web
    • Proposed As Answer by PWMatherMVP Friday, January 06, 2012 11:54 AM
    •  
     
  • Friday, January 06, 2012 10:18 AM
     
     
    Sign In to Vote
    0
    Thanks a lot for your reply.
    Thanks, Lovely