debugsqlMinor
Error creating database in SQL Server Management Studio. (Could not load file or assembly 'Microsoft.SqlServer.Sqm)
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)
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
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.
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.