Error creating database in SQL Server Management Studio. (Could not load file or assembly 'Microsoft.SqlServer.Sqm)

Question

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)

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.

Answer 2

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.!!!