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

Eric KALONJI 0

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.

2 answers

Erland Sommarskog 111.1K Reputation points

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.
Please sign in to rate this answer.
Eric KALONJI 0 Reputation points

2024-09-30T11:42:38.8266667+00:00

Thank you @Erland Sommarskog for the prompt feedback.

Unfortunately I have already deleted the install media (the exe file I downloaded from the web to install SQL Server), is there any way I could add those packages on the already installed SQL Server since I do not what to uninstall and re-install it anew?

Erland Sommarskog 111.1K Reputation points

2024-09-30T13:02:33.4933333+00:00

Download the file again. When you run it, select the option Download media to get the ISO file. Then run from the ISO.

And good point from Olaf. The book you have is outdated. Some things will match, others not. For instance, the book is entirely silent on Power BI which is a huge thing these days.

Eric KALONJI 0 Reputation points

2024-09-30T13:48:32.31+00:00

Thanks again to the both of you. I'd like to embark into this journey of data analysis, data analytics and business intelligence, so I thought a dive into the past could be a good leap towards that aim, and this book looked great because of the multiple hands-on projects it contains, but certainly, it's quite obsolete. Would there be any books, any materials you both could recommend that offer sufficient hands-on activities using power bi in those three fields so that I may be building a portfolio as I learn and practice? Kindly
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Olaf Helper 44,501 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.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

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

2 answers

Your answer