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

1 Answer 1

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 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 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 at 4:40

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.