HiveBrain v1.2.0
Get Started
← Back to all entries
debugsqlMinor

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

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
errorfilecreatingsqlsqlservercouldmicrosoftdatabasemanagementload

Problem

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)

Solution

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.

Context

StackExchange Database Administrators Q#59234, answer score: 4

Revisions (0)

No revisions yet.