Saturday, July 4, 2009

SQL Server 2005 Analysis Services with the Project Server 2007 : Part 2

Configure SSP account

The second step in SQL Server 2005 Analysis Services configuration is to give correct permission to Shared Services Provider (SSP) account on Analysis Service.

  • Determine the SSP account

    1. On the SharePoint Central Administration Web site, in the Quick Launch, click Shared Services Administration.
    2. On the Manage this Farm's Shared Services page, from the drop-down list for the Shared Services Provider you are using, click Edit Properties.
    3. On the Edit Shared Services Provider page, in the SSP Services Credential section, note the account name in the Username field. This is the SSP account.
  • Add the SSP account to the OLAP users local group
    1. Open Computer management : Start->All Programs->Administrative Tools->Computer Management.
    2. Open OLAP user group : Computer Management page->Local Users and Groups->Groups->"SQLServer2005MSOLAPUser$$MSSQLSERVER"
    3. On the SQLServer2005MSOLAPUser$$MSSQLSERVER properties page, click Add.
    4. On the Select Users, Computers, or Groups page, go to the Enter the object names to select section and add the name of the SSP account. Click Check Name to verify that the account exists.
    5. Click OK.

  • Add the SSP account as a server role member in SQL Server 2005 Analysis Services
    1. Connect to the instance of SQL Server 2005 Analysis Services on SQL Server Management Studio.
    2. Right click your SQL Server 2005 Analysis Services instance name, and then click Properties.
    3. Click Security in the Select a page pane.
    4. Click Add. In the Select Users or Groups page, go to the Enter the object names to select field and enter the name of the SSP account that you are adding to the server role. Click Check Name to verify that the account exists.
    5. Click OK.




------------------------------------------------------------------------------
<<Part 1    
Part 3 >>



----

No comments: