I have installed Microsoft SQL Server 2022, but I cannot see the SSIS & SSAS packages.

Eric KALONJI 0 Reputation points
2024-09-30T10:23:41.08+00:00

Good day!

When I installed SQL Server, I remember having ticked the options that asked me whether I wanted to include SSAS, SSIS & SSRS; I ticked them all since I wanted to have a many features as I possibly could.

Now, am studying the book below:

User's image

I have gotten to a point where I need to deploy a SSAS project in Visual Studio, and when I launch the option to depoy it, I get the below error message although the connection setup to the server was made as prescribed in the book:

User's image

Upon investigating, it appears to me that some package are missing from my SQL Server. Here below is a screenshot of how it appears on other people' machines:

User's image

As opposed to how it appears in mine:

User's image

Is there anything I could to add all the packages such as SSAS, SSIS & SSRS that are seemingly missing in my PC?

Regards.

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,132 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,826 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,925 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,578 questions
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.
1,284 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Erland Sommarskog 111.6K Reputation points MVP
    2024-09-30T11:27:31.5566667+00:00

    Apparently you did not install Analysis Services, contrary to your belief. But it is easily addressed if you still have the install media, just start Setup and select the install option, and then you can add features to an existing instance.

    Note that SQL Server Reporting Services is a separate download and install.


  2. Olaf Helper 44,736 Reputation points
    2024-09-30T12:58:14.0733333+00:00

    Additional see Add Features to an Instance of SQL Server (Setup)

    And please keep in mind, you read a book for version 2012, there are several changes in 2022 and previous versions.

    0 comments No comments

Your answer

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