We wanted to configure Analysis Services and OLAP functionality to use a different instance of SQL Server than Project server database server because it was a stand alone install of Project server. So, SQL Server Analysis Service was running on the remote Database server. and it was NOT running on the local Project server Database Server .
As per MS article , you have to ‘Configure the Analysis Services service account’ on local project server database server. But I got below error when I tried that step:
The SQL server analysis service was running under account : NT ServiceMSSqlOLAPService on the remote database server and the same was not available on local project server database server. It looks like NT ServiceMSSqlOLAPService account gets created when you install analysis service. So, we ended up changing above account to a domain account to get it to work.
Hope it helps! If you have any questions please contact us.
