== Sql 2005 Installation ==
* Ensure IIS is installed
* Install SQL server 2005
* Copy the contents of the %SQL 2005 Installation folder%\OLAP\bin\isapi directory into the folder you would like to become the base for the virtual directory in IIS.(e.g. C:\inetpub\wwwroot\olap)
* Create an application pool:
** Goto IIS management console
** Right-click the Application pools to open the shortcut menu and select New, then Application Pool.
** Name the application pool. e.g. OLAP
* Create a virtual directory
** Goto IIS management console
*** Right-click the Web site to open the shortcut menu and select New, then Virtual directory.
*** Name the virtual directory.(e.g. OLAP). The Content Directory should point to the folder you’ve just created. (e.g. C:\inetpub\wwroot\olap)
*** Make sure that under the Access Permissions, only the second check box, Run Scripts (Such as ASP) is selected
* Set up virtual directory properties
** Right-click your virtual directory node and select Properties from the menu.
** In virtual directory tab:
*** Choose the application pool as one you’ve just created.
*** Click the Configuration button. It will show 'Application Configuration' Dialog
*** Click on add button
*** In the Executable option, enter the full path name to msmdpump.dll. (e.g. C:\wwroot\olap\msmdpump.dll)
*** Enter .dll in the Extension text box.
*** Click the OK button to accept the settings
** In 'Directory Security'  tab:
*** Click to Edit on Authentication and access control. It will show 'Authentication Method' dialog box
*** Enable 'Anonymous Access' or you can set up the security as per your requirement
* Set up Web Service Extension
** Goto IIS management console, right-click the Web Service Extensions node and select Add new Web Service Extension.
** Name the extension.(e.g. olap)
** Click the Add button and provide a path to your msmdpump.dll file
** Check the Set extension status to Allowed check box.
* Now XMLA IIS instance for SQL 2005 has been configured. In this example, the instance url is something like 'http://yourserver/olap/msmdpump.dll'. You should see a SOAP response like this (use firefox, IE will serve up it's own error page): 
 <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Body>
   <soap:Fault xmlns="http://schemas.xmlsoap.org/soap/envelope/">
   <faultcode>XMLAnalysisError.0xc10e0002</faultcode>
   <faultstring>Parser: The syntax for 'GET' is incorrect.</faultstring>
   <detail>
    <Error ErrorCode="3238920194" Description="Parser: The syntax for 'GET' is incorrect." Source="Unknown" HelpFile=""/>
   </detail>
   </soap:Fault>
  </soap:Body>
 </soap:Envelope>

