Missing Integration Services Catalog in Management Studio
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.exeunder 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!
Solution
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
Integration Services Catalog
Integration Services Object Explorer
- How to create Tab Delimited Select statement?
- Remove specific data along with the angle brackets in SQL
- Nested SQL Server cursor has no records
- Error when clicking on button to save value in database
- Result order of string_split?
- How do I get a list of stored procedures from a linked server?
- Get distinct related values based on matching value
- SQL Server ignores indexes
- Handling transactions divided by GO statement
- Why can't I re-authenticate (MFA with mssql extension for VS Code)?
- Deploying Umbraco 13 app to Azure app service issue
- Running total for stock left for each month
- Calculate Mashed Potatoes Percentage
- How to use Windows authentication with the Scaffold-DbContext command?
- sql server data fields nvchar(x) or nvarchar(max)
- Convert tables with "id,attribute,value" columns to "id,attribute1,attribute2,..."
- How to limit the SQL Server Developer edition to the Standard edition?
- SQLx to Mssql connection string
- How to create sequential ID's per user in Postgresql
- Select row, check condition and update versus update row where condition
- Filtering on an object/casted column?
- Join tables, between column and attribute in xml data
- SSAS cube processing error about column binding
- SQL Server 2012 error: object reference not set to an instance of an object
- Function to Calculate Median in SQL Server
- No built-in function in SQL Server for "substring to the end"?
- Multiplication aggregate operator in SQL
- When are curly brackets required when used in a XQuery in SQL Server?
- SQL query for search user using combine FirstName and LastName column
- Trying to write dynamic sql and export results to a text file