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
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!
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.
Choose "MgmtStudio 32BIT\SQLManagementStudio_x86_ENU.exe"
For clarification