This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 40%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
Hi All,
User is accessing SSAS Cube via http msmdpump url where connection is getting redirected from sharepoint server to cube server.
ISS setting is DNS+Windows Authentication.
This was working fine until a month back and then suddenly user started getting below error:
XML Parsing failed at Line 1, column 9: DTD is prohibited
We changed ISS settings from DNS + Windows Authentication to IP+Windows Authentication:
Then encountered below error:
The following system error occurred
It is working fine when we changed ISS settings from DNS + Windows Authentication to IP+Anonymous.
And giving error whenever change setting back to 'DNS + Windows Authentication'
Anyone encountered similar scenario or can please hint/suggest anything on this?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 9%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELY%3C/text%3E%3C/svg%3E)
Hi,
Seems same issue have been reported by other user.
The fundamental source of the error is a "500 - Internal server error" coming from IIS. That's what you need to focus on.
Excel’s parser (MSOLAP) isn’t expecting the first line of the server error which contains a XHTML 1.0 Strict document type:
Also you could try other methods described in : XML parsing failed at line 1, column 9: DTD is prohibited
Regards,
Lukas
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Users always get connection timeout problem when using multi subnet AG via listener. Especially after failover to another subnet ----Hot issues October
Hi,
We did not hear from you, did you resolve your issue ?
Sorry for delay reply,
Actually before posting the question I already had tried all options given in this blog and none seems working.
If anyone has any other clue. please suggest..
Thanks
From current info, there is seems not much to do. Have you do more trouble shooting or research based on your environment ?
Hi , this is still in process and not resolved.
To be honest, this case is complicated and out of we scope here. I cannot help much on this. (mainly we could not access your environment nor replicated the issue.) You could consider MS support.