Cannot see Integration Services Catalogs node in SQL Server Management Studio (SSMS)

1
votes

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.

enter image description here

1
sql-serverssissql-server-2014
Which edition of SQL Server 2014 do you have? Express, Web, Standard, Developer/Enterprise? - marc_s
Do you have any other versions of SQL Server running on your system? or perhaps just another version of SSMS? You can't see the Integration Services Catalogs in SSMS 2008 or older. - JodyT
No I have only 1 version of SSMS, and thats 2014. - Chirag
On that server, run this query SELECT SERVERPROPERTY('productversion') AS ProductVersion; What does that say? - billinkc
ProductVersion = 12.0.2269.0 - Chirag

1 Answers

1
votes

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

enter image description here

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