IIS7 Configuring SSAS to install the environment over HTTP remote connection
Operating system: Windows7, Windows Server2008
IIS version: 7.5
IIS7 configuring SSAS for remote connections over HTTP is detailed in the following steps:
1. First find the following directories and files in the SQL Server installation directory of the Analysis servers, with the following path: D:\Program Files\Microsoft SQL Server\msas10_50.mssqlserver\olap\bin\ Isapi
2. Create a new OLAP file on the D drive and copy all of the above-mentioned ISAPI files in.
3. Create a new application pool in IIS named OLAP, managed mode Select Classic, set up as follows
4. Create a new virtual directory under the IIS Default Web site named OLAP, the physical path select the second step of the new D:\olap folder, as
5, in the virtual directory OLAP point right click, select "Convert to Application", then the corresponding application pool select the third step to create the OLAP mode, specific as
6. In the OLAP Features view area, double-click the "Handler mappings"
7, right-click, select "Add Script Map", select the newly built virtual directory of the Msmdpump.dll file, OK. will appear whether to allow ISAP expansion, click Yes, specific as
8. Configure IIS authentication, in the features view, double-click Authentication, and the following dialog box appears
9. The above is enabled for anonymous authentication, and the others are disabled. Right-click Anonymous authentication, select Edit, and the following dialog box appears:
Click Settings to enter the appropriate user name and password, special note: Here the user name must be accessible to SQL Server. If the multidimensional database has an instance name, for example. \sqlserver2008 Remember to modify the Msmdpump.ini file, open the Msmdpump.ini file, and modify the corresponding servername to. \sqlserver2008.
Test whether the configuration was successful
1, in the Multidimensional Analysis engine input: HTTP://IP Address: Port number/iis site name/msmdpump.dll can, for example: Native IP address: 192.168.156.139 Port: IIS site Name: OLAP
Visit as follows: Http://192.168.156.139/olap/msmdpump.dll
2, in Excel to connect the cube configuration as follows: Open Excel, click Data, from other analytical data sources, input access to the Http://192.168.156.139/olap/msmdpump.dll connection can be, specific as
Select the corresponding multidimensional database and the corresponding cube to
Additional instructions: If the XML parsing fails at the 1th and 9th columns when using the EXCE connection: disables the DTD error. In the application pool, select the OLAP application pool that you created earlier, click Advanced Settings, enable 32bit-bit applications: Select True
PS: Share IIS6, IIS5 configure SSAS via HTTP remote connection detailed solution, details refer to the following accessories HTTP://WWW.FLYBI.NET/ARTICLE/64 turn from: http://www.flybi.net/article/63
II7 configuration of SSAS via HTTP remote link access
