More Fun (MDX Query Designer Error After Office 2007 Install)
If you are running the 2007 Microsoft Office System Beta, you may noticed some problems in the MDX query designer in the Reporting Services Report Designer. Specifically, trying to execute an MDX query that has been typed or modified directly in the text pane gives the following error:
Query preparation failed.
-> Error in the application. (msmgdsrv)
The problem is caused by a mismatch in versions between the msmgdsrv.dll file and the msmdlocal.dll file. The msmgdsrv.dll is loaded by managed code from the directory of the application using it, but msmgdsrv.dll loads explicitly msmdlocal.dll from the %Program Files%\Common Files\System\Ole DB directory. This results in a problem when the OLE DB directory files are updated but the application directory files are not.
To manually correct this, ensure the versions of msmdlocal.dll and msmgdsrv.dll in the following directories match the versions in the %Program Files%\Common Files\System\Ole DB directory.
- %Program Files%\Micorosft Visual Studio 8\Common7\IDE\PrivateAssemblies
- %Program Files%\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE
- %Program Files%\Microsoft SQL Server\MSSQL.*\Reporting Services\ReportServer\bin
Note: Replacing these files manually is a temporary fix and will be replaced by an upcoming official fix.
Comments
- Anonymous
January 23, 2007
Thank you very much for this quick fix for an issue that had been hounding me all day. Is this going to be part of SQL Server 2005 SP2 by any chance (or VS2005 SP2)? - Anonymous
February 04, 2007
Yes, this will be included in SQL 2005 SP2. - Anonymous
March 10, 2007
PingBack from http://blog.stevienova.com/2007/03/10/executing-mdx-errors/