Take the 2-minute tour ×
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.

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

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.

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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