Cannot see Integration Services Catalogs node in S

2019-05-31 04:02发布

问题:

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.

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

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

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

回答1:

Got resolved for me!

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).

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 Reference