SQL Server 2016 CTP2连接错误 [英] SQL Server 2016 CTP2 connectivity Error

问题描述

大家好，

我在我的虚拟机上安装了SQL Server CTP2。

直到昨天才工作正常
我能够连接到我的SQL数据库并正在使用SSAS多维数据集。

但是当我今天打开我的SSMS并尝试连接DataBase Engine或Analysis服务时

I have installed SQL server CTP2 on my VM .
It was working fine till yesterday
I was able to connect both to my SQL Database and was working on SSAS cube .
But when I open my SSMS today and tried connecting DataBase Engine or Analysis services 

注意：我已经检查了SQL服务并且所有服务都已启动 

Note: I have checked the SQL services and all are started 

我收到以下错误：

TITLE: Microsoft SQL Server Management Studio
------------------------------

Error connecting to 'serverName**'.

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

Could not load type 'Microsoft.SqlServer.Management.Dmf.FailedOperationException' from assembly 'Microsoft.SqlServer.Dmf, 
Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'. (ObjectExplorer)

------------------------------
BUTTONS:

OK
------------------------------

可能是什么原因？我在网上搜索但没有发现任何有用的东西可以解决我的问题。

What could be the reason ? I searched online but did not find any thing useful that could solve my problem.

推荐答案

5月非常乐于助人。

C：\Program
Files\Microsoft SQL Server\100\SDK\Assemblies  是正确的文件夹位置（或  C：\Program
文件（x86）\ Microsoft Microsoft SQL Server \100\SDK \Assemblies  在64位系统上。）

你需要添加引用：

You need to add references to:

• 
  

  Microsoft.SqlServer.ConnectionInfo.dll

• Microsoft.SqlServer.ConnectionInfo.dll

Microsoft.SqlServer.Smo.dll

Microsoft.SqlServer.Smo.dll

Microsoft.SqlServer.Management.Sdk.Sfc.dll

Microsoft.SqlServer.Management.Sdk.Sfc.dll

Microsoft.SqlServer.SqlEnum.dll

Microsoft.SqlServer.SqlEnum.dll

（这些是构建SMO应用程序所需的最小文件）

(These are the minimum files that are required to build an SMO application)

Ref.: 如何：在Visual Studio .NET中创建Visual C＃SMO项目

可以下载SQL Server管理对象（SMO）作为相关的一部分  SQL Server（20XX）
功能包 （检查小图，因为我不相信这些是可再发行的？）

The SQL Server Management Objects (SMO) are downloadable as part of the relevant SQL Server (20XX) Feature Pack (check the smallprint as I don't believe these are redistributable?)

http://stackoverflow.com/questions/6453415/reference-microsoft-sqlserver-smo-dll

http://stackoverflow.com/questions/6453415/reference-microsoft-sqlserver-smo-dll

这篇关于SQL Server 2016 CTP2连接错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！