在 SQL Server Management Studio (SSMS) 中看不到集成服务目录节点 [英] Cannot see Integration Services Catalogs node in SQL Server Management Studio (SSMS)

查看:49
本文介绍了在 SQL Server Management Studio (SSMS) 中看不到集成服务目录节点的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我想创建一个 SSIS 目录,创建目录的方法是右键单击集成服务目录"节点并选择创建目录"选项.

I wanted to create a SSIS catalog and the way to create a catalog is to right click on "Integration Services Catalogs" node and select "Create Catalog" option.

但是,我无法在 SQL Server Management Studio (SSMS) 中看到Integration Services Catalogs"节点,如下图所示.

However, I am not able to see the "Integration Services Catalogs" node in SQL Server Management Studio (SSMS) as shown in the following image.

缺少什么才能在 SSMS 中看到此节点?请帮忙.

What is missing so that I can see this node in SSMS? Please help.

仅供参考,我的机器上安装了 SQL Server 2014(开发人员版)和 Integration Services 12.0.

FYI, I have SQL Server 2014 (Developer edition) and Integration Services 12.0 installed on my machine.

推荐答案

已为我解决!

仅供参考,我不得不再次启动 SQL Server 安装程序并安装 SQL Server 的命名实例 (\).因此,当我连接到 SQL Server 的命名实例时,我能够在对象资源管理器上看到集成服务目录"节点(见下文).

FYI, I had to launch SQL Server Setup again and install the named instance (\) of SQL Server. So, when I connect to Named Instance of SQL Server I am able to see the "Integration Services Catalogs" node on Object Explorer (see below).

然而,虽然我已经解决了这个问题并且我现在可以继续前进,但我不确定为什么当我连接到 SQL Server 默认实例时它无法显示这个节点.

However, although it is resolved for me and I am able to move forward for now, I am not sure why its not able to show me this node when I connect to SQL Server default instance.

MS Technet 参考

这篇关于在 SQL Server Management Studio (SSMS) 中看不到集成服务目录节点的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆