Sql-server – Error creating database in SQL Server Management Studio. (Could not load file or assembly ‘Microsoft.SqlServer.Sqm)

sql serversql-server-2012ssms

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)

Best Answer

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.