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.

36 comments:

Anonymous said...

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

Mike Quentel said...

This solution works--thank you!

Unknown said...

Legend..solved my issue too

Unknown said...

oh.god..you are genius...

Luigi said...

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

Unknown said...

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.

Unknown said...

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..

Unknown said...

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..

RAHUL said...

It Works..! Thank you!

harika said...

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

harika said...
This comment has been removed by the author.
nhân said...

THANK YOU VERY MUCH!

nhân said...
This comment has been removed by the author.
Anonymous said...

Thx

abhi said...

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

Unknown said...

Good job bro its really works

Manupriya Somanayaka said...

its work thnx

jyoti tripathi said...

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.

Krushnakumar D. Joshi said...

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

but why this problm comes??????

Krushnakumar D. Joshi said...

thanks its working but why this problems comes?

Electron Karthick said...

Thank you thank you thank you!

Unknown said...

Thank you very much... it works

Unknown said...

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

aman verma said...

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

Unknown said...

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.

Unknown said...

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.

Unknown said...

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.

Unknown said...
This comment has been removed by the author.
Unknown said...

thanks , its very helpful

Unknown said...
This comment has been removed by the author.
Unknown said...
This comment has been removed by the author.
Unknown said...

Thank you Very Much

Unknown said...

Arigato hosaimase...thank you

chetan gohil said...

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

Unknown said...

Good tnxs alot

Unknown said...

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\