SSMS Could not load file or assembly msmgdsrv, Version=9.0.0.0

Hi everyone,

Today I an into an error using SSMS while clicking on the button check for an MDX query, the error message was:
“Could not load file or assembly ‘msmgdsrv, Version=9.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or one of its dependencies. The system cannot find the file specified. (MDXQueryGenerator)”

After some investigations I found out that the path for the dll needs to be changed. To change the path open the file “%ProgramFiles%Microsoft SQL Server100ToolsBinnVSShellCommon7IDESsms.exe.config” with a text editor and find the line . Change the attribute of href to the actual dll, on my system it was C:Program FilesMicrosoft Analysis ServicesAS OLEDB10msmgdsrv.dll. Restart SSMS and then it works.

I hope this helps

Florian

Source: Microsoft.com