For more information visit:
Microsoft cloud Computing
Environment Domain A Server A - Project server and Web Server Server B- SQL Analysis Services server
Domain B Clients / Users Users accessing Project Server via. HTTP
Domain Relationship Both the domains (Domain A & B) are on Intranet but don’t have any trust.
In this Scenario where IIS Server and Project Server running on same box and Analysis Services running on different Server we need to follow below mentioned steps:
1) Ensure that OLAP Application Pool Identity is set to domain account (by default its local system account and AS Server on other box doesn’t not understand the local account from IIS Server)
2) Enable anonymous access with domain account (default is IUSR),since AS data-source needs to be accessed remotely from IIS Server.
3) OLAP Virtual Directory port should be open from Firewall (making it accessible by external domain)
4) On client boxes ensure that Right SSAS Provider (OLEDB) is installed
Configuring HTTP Access to SQL Server Analysis Services on IIS 6.0
Configure HTTP Access to SQL Server Analysis Services on IIS 7.0
Writer - Ashutosh Sharma, Support Engineer- SQL BI Team
Reviewer – Karan Gulati, Support Escalation Engineer – SQL BI Team