Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (SqlMgmt)

share|improve this question

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.

share|improve this answer
    
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 '14 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 '14 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). – Aaron Bertrand Feb 20 '14 at 4:40

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

Solution

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 12.0.0.0 version and i pasted 12.0.2000.8 and it worked like a charm.!!!! cheers.!!!

share|improve this answer

protected by Community Jan 14 at 21:22

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

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