Share via

Problem Installing SSIS and SSAS in Management Studio

Douglas M 0 Reputation points
2025-11-12T15:20:06.89+00:00

When installing SSIS or SSAS using SQL Server Installation Center It says that they are already installed. When I open SSMS (Management Studio) The only option I have is to logon to the database engine. The box is grayed out. See below. Can someone tell me what to do?

User's image

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 128.6K Reputation points MVP Volunteer Moderator
    2025-11-12T21:52:08.4033333+00:00

    Which version of SSMS do you have? SSMS 22 became generally available yesterday, so you may want to download it and give it a spin. Note that support for SSIS and SSAS are optional components, so you need to select these when you install.

    Also note that your current version of SSMS will not be affected. Different major versions of SSMS install side by side.

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.