Sql server管理错误：无法创建新数据库 [英] Sql server management error : cannot create a new database

问题描述

您好。我无法通过右键单击Sql Server Management Studio 2014中的数据库来创建新数据库。



这很有趣，因为我能够创建一个新的数据库查询或通过visual studio。



但是当我右键单击Management Studio中的数据库时，我收到此错误：

Hi. I cannot create a new database by right-clicking Databases in Sql Server Management Studio 2014.

This is interesting because I am able to create a new database with query or via visual studio.

But when I right-click Databases in Management Studio, I get this error:

Cannot show requested dialog.

------------------------------
ADDITIONAL INFORMATION:

Could not load file or assembly 'Microsoft.SqlServer.Sqm, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' 
or one of its dependencies. 

我的尝试：



我试图加载一些丢失的程序集（例如Microsoft.SqlServer.Smo.dll）

并尝试安装SharedManagementObjects.msi和DB2OLEDBV5_x64.msi但不是偶然的...

What I have tried:

I have tried to load some missing assemblies (such as Microsoft.SqlServer.Smo.dll)
and tried to install SharedManagementObjects.msi and DB2OLEDBV5_x64.msi but not a chance...

推荐答案

安装Sql Server 2014 SP1提供了缺少的dll和文件并解决了问题。

Installing Sql Server 2014 SP1 supplied missing dlls and files and solved the problem.

这篇关于Sql server管理错误：无法创建新数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！