Thursday, January 07, 2010

MS: 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. The file size inside these 2 folders should be 0 bytes.
at

35 comments:

  1. Anonymous3:19 AM

    IS VERY GOOD
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .
    .

    ReplyDelete
  2. Mike Quentel4:03 PM

    This solution works--thank you!

    ReplyDelete
  3. Unknown7:49 AM

    Legend..solved my issue too

    ReplyDelete
  4. Unknown3:50 AM

    oh.god..you are genius...

    ReplyDelete
  5. Luigi6:03 PM

    Hi, I've a similar problem using sqlexpress 2008 R2, all is working fine, but the proprety of the database gives this error:
    "Cannot show requested dialog. (SqlMgmt)" and "Cannot find a matching quote character for the character '''. (SqlManagerUI)"

    All happen from a day to another, SQl was working fine untill yesterday!
    Any ideas?
    Ciao

    ReplyDelete
  6. Unknown1:41 PM

    Ran into same issue with SQL Server 2008 R2 (x64) on Windows 2008 R2 (x64) Not sure what would cause it. We'll leave that for MSFT to figure out.

    Solution copying the DLL, Microsoft.SqlServer.Sqm.dll located on C:\Program Files\Microsoft SQL Server\100\Shared to folder C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE.

    worked for me.

    ReplyDelete
  7. Unknown6:01 AM

    Thx Buddy... Actually when i got this error.. i was so scared and was sad cause i was unable to find out error..
    Thx...
    by help of u i done it....
    Thx..

    ReplyDelete
  8. Unknown6:02 AM

    Thx Buddy... Actually when i got this error.. i was so scared and was sad cause i was unable to find out error..
    Thx...
    by help of u i done it....
    Thx..

    ReplyDelete
  9. RAHUL12:12 AM

    It Works..! Thank you!

    ReplyDelete
  10. harika1:12 AM

    It works for me too:-)
    Thanks for the help

    ReplyDelete
  11. harika1:13 AM

    This comment has been removed by the author.

    ReplyDelete
  12. nhân10:44 AM

    THANK YOU VERY MUCH!

    ReplyDelete
  13. nhân10:45 AM

    This comment has been removed by the author.

    ReplyDelete
  14. Anonymous9:55 AM

    Thx

    ReplyDelete
  15. abhi9:55 AM

    i cannot find the file Microsoft.SqlServer.Sqm.dll in the specified folder,,,,can anyone help me out...

    ReplyDelete
  16. Manupriya Somanayaka2:24 PM

    its work thnx

    ReplyDelete
  17. Abhishek tripathi12:09 PM

    realy i was frustrated when i have uninstalled , install the sql due to this error, but no uses. thanx a lot i have solved it as u suggested.

    ReplyDelete
  18. Krushnakumar D. Joshi12:58 PM

    thanks its working !!!!!!!!!

    but why this problm comes??????

    ReplyDelete
  19. Krushnakumar D. Joshi12:59 PM

    thanks its working but why this problems comes?

    ReplyDelete
  20. Electron Karthick8:32 PM

    Thank you thank you thank you!

    ReplyDelete
  21. Unknown8:33 PM

    Thank you very much... it works

    ReplyDelete
  22. Unknown5:01 AM

    Thanks ...very good ..great job..............!

    ReplyDelete
  23. aman verma3:07 AM

    Thanks ...........

    ReplyDelete
  24. Unknown9:22 AM

    on my system "C:\Program Files (x86)\Microsoft SQL Server\100\Tools"
    and only one folder within "Tools\policies" the rest are missing. I tried to copy from a different server "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE" and dll file as you mentioned but it didn't work.

    ReplyDelete
  25. Unknown9:22 AM

    on my system "C:\Program Files (x86)\Microsoft SQL Server\100\Tools"
    and only one folder within "Tools\policies" the rest are missing. I tried to copy from a different server "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE" and dll file as you mentioned but it didn't work.

    ReplyDelete
  26. Unknown9:22 AM

    on my system "C:\Program Files (x86)\Microsoft SQL Server\100\Tools"
    and only one folder within "Tools\policies" the rest are missing. I tried to copy from a different server "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE" and dll file as you mentioned but it didn't work.

    ReplyDelete
  27. Unknown9:22 AM

    This comment has been removed by the author.

    ReplyDelete
  28. Unknown6:32 AM

    thanks , its very helpful

    ReplyDelete
  29. Unknown6:42 AM

    This comment has been removed by the author.

    ReplyDelete
  30. Unknown6:42 AM

    This comment has been removed by the author.

    ReplyDelete
  31. Unknown6:42 AM

    Thank you Very Much

    ReplyDelete
  32. Unknown7:30 AM

    Arigato hosaimase...thank you

    ReplyDelete
  33. chetan gohil6:11 AM

    i just copy and relace it...!
    thanks man it works....

    ReplyDelete
  34. Unknown4:48 AM

    Good tnxs alot

    ReplyDelete
  35. Unknown7:21 AM

    on 2012 Microsoft.SqlServer.Sqm.dll copy in
    c:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\
    c:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\

    ReplyDelete