Analysis Services (SSAS) Installation Setup Guide with SSMS

Analysis Services 2022: In this article we will see how to download the SQL Server and run the setup to download the ISO file and then install the Analysis Services name, post that connecting to Analysis Services instance using SSMS Client Tool. Follow all the required steps and you can see that you have successfully managed to install the Analysis Services. Also, if you have any queries/concern please comment down below.

Note: SSAS (Analysis Services) don’t have its separate installer setup so first you have to download the SQL Setup where in the SSAS is setup is included in it.

#1) SQL Server 2022 Download?

Step 1: Go to your browser and types “SQL Server Download” and you can click the below Microsoft link.

image 15

Step 2: Here we can see 2 methods to download the SQL Server 2022, you can select any 1 option and proceed further. I will suggest going with “Developer” option which is option 2.

image 28

Step 3: Once you download the file it will be saved into your PC, just open it and follow the below steps:

#2) SQL Server 2022 ISO file download?

Step 1: If I open the setup file then you can see this below interface. For more control you can download the Media (ISO File), in my case I will go with 3rd option.

image 16

Step 2: By default, the ISO will be selected and folder path as well, just change the download folder if you want and click on download below.

image 24

Step 3: The file has started to download, now wait until the setup file is completed. Once downloaded move to below steps.

image 17

#3) Analysis services 2022 installation?

Step 1: Open the ISO file which you have downloaded in the above step, and you can see the setup file just open it.

image 17

Step 2: Now go to “Installation” menu and click on the first option mentioned in the below image.

image 28

Step 3: In this step we will what edition we will choose, in my case I will go with the Developer version. If you have product key, then you can enter in the below option.

image 60

Step 4: Accept the terms and conditions and click on next.

image 23

Step 5: In this step you can see that I have passed all the rules, now click on next.

image 27

Step 6: This is important step here, in my case I will install SSAS so I am selecting “Analysis Services” here. If you just want to install the SQL Server and SSAS both then tick the first option as well “Database Engine Services”

image 20

Step 7: Give Name to your Analysis Services “PCTAB” the reason I am giving PCTAB because “PC” in my VM name and “TAB” is the tabular model

image 25

Note: In my case I am using “Named Instance” so I have provided alternative name. If you select the default one, then your SQL and SSAS will have the same name.

Step 8: Leave everything as default and click on Next.

image 18

Step 9: Select Tabular model here and click on “Add Current User” and proceed further.

image 22

Step 10: Once done all the installation will start and will complete after some time as you can see in the below image. Now our SSAS is installed successfully and we are good to connect with SSMS.

image 19

#4) Connect SSAS Instance using SSMS?

Step 1: Go to your browser and type SSMS download and open the first link of Microsoft.

image 30

Step 2: Click on the below link and your SSMS will start downloading as you can see in the below image.

image 26

Step 3: Open the setup file then install the SSMS and open it and go to the home page after installation.

image 21

Step 4: In the homepage you can see “Connect” option at the top, just click on that and select SQL Database.

image 29

Step 5: Now give the Tabular Model name as you can see in my case I have given “PCTAB”

image 31

Step 6: Now I have successfully connected to SSAS.

image 32

Conclusion:

We have seen all the above-mentioned steps, on how to download, install and configure Analysis Services. I have some other links as well on SQL Bi, if you want you can check out the below links. Also comment down for any queries\concern. For more check out this link: https://learn.microsoft.com/en-us/analysis-services/instances/install-windows/install-analysis-services?view=asallproducts-allversions

SQL Bi Links:

  1. SQL Server 2022 Download, Install, Connect Using SSMS Tool (kingfishertechtips.in)
  2. SSRS/PBIRS – Install And Configure The Report Server On-Prem (kingfishertechtips.in)
  3. Could Not Load Folder Contents In Portal URLs – SSRSPBIRS (kingfishertechtips.in)
  4. SSRS/PBIRS – Install And Configure The Report Server On-Prem (kingfishertechtips.in)
  5. SQL Server 2022 Download, Install, Connect Using SSMS Tool (kingfishertechtips.in)
  6. Capture Fiddler Trace for Debugging the Network Traffic (kingfishertechtips.in)
  7. On-Premises Gateway: Configure/Map SQL DB To Power Bi (kingfishertechtips.in)
  8. Fixed Column/Row Header Make Visible In Any Report (kingfishertechtips.in)
  9. Self-Signed Certificate: Configure SSRS/PBIRS With SSL (kingfishertechtips.in)
  10. Create Local User Account/Local Admin User In Windows 10/11 (kingfishertechtips.in)
  11. Login With AAD/Domain/Microsoft Account To Azure VM’s/RDP (kingfishertechtips.in)
Vickey Rajpoot
Vickey Rajpoot

Hello there! I'm dedicated Microsoft Data & AI Engineer at LTIMindtree, where I thrive technology into actionable insights. Dive into my world by visiting my YouTube channel & Webiste, "Kingfisher Tech Tips".

Articles: 71

3 Comments

  1. I loved as much as you’ll receive carried out right
    here. The sketch is tasteful, your authored subject matter stylish.
    nonetheless, you command get bought an nervousness over that you wish be delivering the following.
    unwell unquestionably come further formerly again since exactly
    the same nearly very often inside case you shield
    this hike.

Leave a Reply

Your email address will not be published. Required fields are marked *