在 SQL Server Management Studio (SSMS) 中看不到集成服务目录节点 [英] Cannot see Integration Services Catalogs node in 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.
这篇关于在 SQL Server Management Studio (SSMS) 中看不到集成服务目录节点的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!