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.