Configure access to Analysis Server cubes over HTTP in an EPM/Office SharePoint Server 2007 extranet environment

This Office product will reach end of support on October 10, 2017. To stay supported, you will need to upgrade. For more information, see , Resources to help you upgrade your Office 2007 servers and clients.

 

Topic Last Modified: 2016-11-14

The extranet users and remote intranet users who need access to the Project Web Access Data Analysis views require the SQL Server 2005 Analysis Services to be configured to use HTTP or HTTPS. This feature is available only when the Enterprise Edition of SQL Server Analysis Services 2005 is installed.

The Microsoft TechNet article, Configuring HTTP Access to SQL Server 2005 Analysis Services on Windows Server 2003 (https://technet.microsoft.com/en-us/library/cc917711.aspx), documents the process in detail.

Additional documents that may prove useful also include the following:

• How to configure SQL Server 2005 Analysis Services to use Kerberos authentication (https://support.microsoft.com/default.aspx/kb/917409)

• Resolving Common Connectivity Issues in SQL Server 2005 Analysis Services Connectivity Scenarios (https://technet.microsoft.com/en-us/library/cc917670.aspx)