Configure SSAs remote connection over HTTP in iis7.5

Environment: win7 + SQL server2005

1. First, find the following directories and files in the SQL Server Installation Directory of the Analysis Server:

2. Create a folder named OLAP and copy everything in the above ISAPI.

3. Create an application pool named "OLAP" in IIS and set it as follows:

4. Create a virtual directory under the default IIS website and point to the folder created in step 1. Pay attention to the red line section.

5. Right-click the virtual directory OLAP and select "convert to application"

 

6. Double-click "handler ing" in the function view area of OLAP ".

 

7. Right-click "add script ing", select the msmdpump. dll file under the created virtual directory, and click OK.

 

After the settings are complete, you can link them using the following methods:

If the connection fails, check the permission settings. Allow everyone.