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:

wsxwhx704 said...

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

Mike Quentel said...

This solution works--thank you!

admin said...

Legend..solved my issue too

岚风 ~虚伪的月下轮舞曲 said...

oh.god..you are genius...

BioDataSheet team 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

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

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

nitin 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.
Султан Абдулла said...

Thx

abhi said...

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

Hamid Kaifi said...

Good job bro its really works

Manupriya Somanayaka said...

its work thnx

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

krishnkumar Joshi said...

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

but why this problm comes??????

krishnkumar 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

KARTHIK.G Karthik said...

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

aman verma said...

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

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

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

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

Gazy G said...
This comment has been removed by the author.
S L Sinwar said...

thanks , its very helpful

onir sharma said...
This comment has been removed by the author.
onir sharma said...
This comment has been removed by the author.
onir sharma said...

Thank you Very Much

Nancy Clara David said...

Arigato hosaimase...thank you

chetan gohil said...

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

Gazala Shaikh said...

Good tnxs alot

Stolyarov M 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\