Prepare Analysis Services Server to host analysis databases
Updated: 2009-04-09
This article is only applicable to Planning Server distributed deployment. It is not for a stand-alone deployment.
If your Analysis Services (AS) databases are to be hosted on an AS server computer that is separate from Planning SQL Server Application database, you may need to manually set up the permissions to enable the service identity (SI) account for the AS server to communicate with the computer running SQL Server. However, if the Analysis Services service on one computer is running the same domain account as the other SQL Server service on another computer, then you do not need to do this step. See Installing SQL Server and SQL Server Analysis Services for details on choosing this service account.
Procedures
Assign permissions on the Analysis Services computer
Start SQL Server Management Studio.
Connect to your Analysis Services server.
In the Object Explorer pane, right-click (Microsoft Analysis Server 9.00.xxx…), and then click Properties.
Click Security, and then click Add.
Add your new SI account, and then click OK.
Click OK to close the Properties window.
Your SI account has now been added to SQL Server Analysis Services.
Download this book
This topic is included in the following downloadable book for easier reading and printing:
See the full list of available books at Downloadable content for PerformancePoint Monitoring Server.