Pages

Tuesday, October 18, 2011

Could not load file or assembly 'Microsoft.SqlServer.Sqm ...

When you try to run SQL 2008 Management Studio on Windows 2008 R2 x64 you receive this error:

Microsoft SQL Server Management Studio
Cannot show requested dialog.

Could not load file or assembly 'Microsoft.SqlServer.Sqm, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The module was expected to contain an assembly manifest. (SqlMgmt)

Solution:

Copy the file Microsoft.SqlServer.Sqm.dll located on
C:\Program Files\Microsoft SQL Server\100\Shared to folder
C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE and
C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE.