Missing Integration Services Catalog in Management Studio

7
votes

I have SQL Server 2008 R2 SP3 standard edition installed. I access remote to the server where SQL Server is installed. The option of the integration services catalog is missing under the database connection.

I did check the followings

  • I have the role sysadmin when I log in SQL Server
  • The service of integration services is installed and running.
  • The installation of the management studio is complete
  • I am missing the Microsoft SQL Server Integration Services when I run the Dcomcnfg.exe under Services, Computers, My Computer, and DCOM Config. Weird I am missing this. I wanted to find this to give appropriate permissions, but can't since the node is not there.

Any ideas? Help!

3
sql-serversql-server-2008ssissql-server-2008-r2

3 Answers

6
votes

That's because you're using SSMS 2008. The Integration Services Catalog was introduced with SQL Server 2012. The older client doesn't know that's a "thing."

I prefer to manage servers with the latest and greatest version of SSMS which is now a free download.

Microsoft® SQL Server® 2014

Choose "MgmtStudio 32BIT\SQLManagementStudio_x86_ENU.exe"

For clarification

Integration Services Catalog

Integration Services Catalog

Integration Services Object Explorer

Integration Services Object Explorer

4
votes

I had the same problem, Integration Server Catalog is invisible This is my solution:

  1. Check your installation edition of SQL Server. How to check? right click on the node of (SQL Server...) on SSMS - click properties - in "general" check the "product" name.

If you still use "SQL Server Developer Edition", some features will not available. the solution is download SQL Server Enterprise Edition.

I have no idea for Standard Edition, but maybe you can also use Enterprise Edition. This is link for download : download SQL Server 2014

  1. Click setup.exe to install and choose New SQL Server Stand-alone Installation select the feature you need. I think you can also select Integration Services in Feature Selection.. then fill the instance name and instance ID. continue the installation process until complete.

  2. Open SQL Server Management Studio. Database Engine connection -> Server Name: (Server Name) / (Instance ID)

  3. You will see the Integration Server Catalog. In the picture bellow, you can compare the display between SQL Server Developer Edition (above) & SQL Server Enterprise Edition (bottom with instance name).

I hope it can help..

Final result:

0
votes

I got same issue and i have installed SSMS 17.0 and now i am able to create the SSISDB catalog with encryption password.

It's working as expected.