I'm trying to create a new database in SSMS, but I get this error:

Could not load file or assembly 'Microsoft.SqlServer.Sqm, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (SqlMgmt)

2 Answers 2


Close Management Studio.

Find the file Microsoft.SqlServer.Sqm.dll located in one of the following folders:

C:\Program Files\Microsoft SQL Server\110\Shared\
C:\Program Files\Microsoft SQL Server\110\Tools\Binn\VSShell\Common7\IDE\
C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\VSShell\Common7\IDE\

Wherever you find it, make sure it also exists in the other two locations.

I don't know that this will solve your issue, so please let me know - if not I will delete this. This was just too complex to add as a comment.

  • I have the file in C:\Program Files\Microsoft SQL Server\110\Shared\ folder. But unfortunately I don't have the other two folder. I only have ManagementStudio, Resources and schemas folder in C:\Program Files\Microsoft SQL Server\110\Tools\Binn . Any idea?
    – Ren
    Feb 20, 2014 at 3:46
  • should I copy it at the dir C:\Program Files\Microsoft SQL Server\110\Tools\Binn\ ? because I dont have the \VSShell\Common7\IDE\ folder.
    – Ren
    Feb 20, 2014 at 4:24
  • @Ren Sorry, I don't know. Sounds to me like you should completely uninstall, reinstall, and make sure you apply at least service pack 1 (if you are using SQL Express, get it here). Feb 20, 2014 at 4:40

It's because the exact verion 11.0.. was not found in the folder where 'ssms.exe' is present.


Goto the exact folder where 'ssms.exe' is present by going to start menu and typing ssms.exe. then right click the result and click 'open file location'.

In that location try to paste the exact 11.0.. version of 'Microsoft.SqlServer.Sqm'.

In my case it asked for version and i pasted 12.0.2000.8 and it worked like a charm.!!!! cheers.!!!

Not the answer you're looking for? Browse other questions tagged or ask your own question.