THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

SQLBI - Marco Russo

Please visit the same blog at https://www.sqlbi.com/blog/marco/ - comments are now disabled here but you can comment on the new blog (all blog posts available here are available there, too).
You can follow me on Twitter: @marcorus

Slow HTTP access to AS2000 with Win2K3 RTM without SP1

Thanks to Microsoft support for Analysis Services (one of my customers opened an incident), I just discovered an issue that is not indexed anywhere in Google, so I write a post hoping to save time of the next unlucky user...

I you use HTTP access to Analysis Services 2000 and you have Analysis Services installed on Windows 2003 Server RTM, there is a problem with IIS 6.0 described in KB840875. Apparently it is not related to Analysis Services, but when you use HTTP access you are using an ASP page (MSOLAP.ASP) that indirectly uses the API described in the kb article. This issue is solved by Windows Server 2003 SP1.

For this reason, if you have Windows 2003 Server RTM without SP1 and you want to access to Analysis Services via HTTP, you can rely on two choices:

  • Upgrade the server to Windows Server 2003 SP1. This is the suggested one.
  • If you cannot upgrade to SP1, you can use a workaround modifying the MSOLAP.ASP page: simply change the Response.Buffer line into this:

    <%Response.Buffer=TRUE%>

    The original value is FALSE. I found only one reference to this fix into an old post in the newsgroups, which didn't correlate the problems (probably it was something else, because at that time Win2K3 Servere were still in beta test.

Analysis Services 2005 is not affected by this issue.

Published Monday, January 29, 2007 3:28 PM by Marco Russo (SQLBI)
Filed under:

Comments

No Comments
New Comments to this post are disabled

About Marco Russo (SQLBI)

Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies. He runs the SQLBI.COM website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on. Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.

This Blog

Syndication

Archives

Privacy Statement