SQL Server Q&A

Symptoms
This article describes the following about this hotfix release: The issues that are fixed by this hotfix packageThe prerequisites for installing this hotfix packageWhether you must restart the computer after you apply this hotfix packageWhether this hotfix package is replaced by any other hotfix packageWhether you must make any registry changes after you apply this hotfix packageThe files that are contained in this hotfix package
Resolution
When you try to export SQL Server 2005 reports to Microsoft Office Excel or to Microsoft Excel, you may receive an error message that resembles the following:

Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index

Symptoms
When Microsoft Office Excel 2007 tries to connect to an OLAP cube on a server that is running Microsoft SQL Server 2005, the connection fails.
Resolution
This problem occurs because SQL Server 2008 installs the Msolap100.dll, and this file checks for the SQL Server 2008 only value DBPROP_MSMD_SUBQUERIES. When the value is not present, the Msolap100.dll fails and prevents Excel 2007 from connecting to the server.