I configured HTTP access for the SQL Analysis server, as indicated in the following article,
https://technet.microsoft.com/en-us/library/gg492140(v=sql.105).aspx
Finally, I configured msmdpump.dll for my SQL Analysis service, and I try to load the connection string in Excel, I got an XML parsing exception when row 1 was excluded, column 9 of the DTD is prohibited.
web.config from 'C: \ inetpub \ wwwroot \ OLAP' is,
<?xml version="1.0" encoding="UTF-8"?>
<configuration>
<system.web>
<identity impersonate="true" />
<authentication mode="Forms" />
</system.web>
<system.webServer>
<httpProtocol>
<customHeaders>
<add name="Access-Control-Allow-Origin" value="*" />
<add name="Access-Control-Allow-Methods" value="GET, POST"/>
<add name="Allow" value="OPTIONS, TRACE, GET, HEAD, POST, PUT"/>
<add name="Access-Control-Allow-Headers" value="Origin, Content-Type, Accept"/>
</customHeaders>
</httpProtocol>
<handlers>
<add name="OLAP" path="*.dll" verb="*" modules="IsapiModule" scriptProcessor="C:\inetpub\wwwroot\OLAP\msmdpump.dll" resourceType="File" preCondition="bitness64" />
</handlers>
</system.webServer>
</configuration>
The security authentication application pool is NetworkService. Are any administrator rights a connection restriction or missing parameters?