Install

  • In this step, you must install the software you downloaded in step 1 (Download All Tools for SSAS 2022) in order and principle on your system.

There are 6 ways to install SSAS 2022:

6 Ways to Install SSAS 2022

Peripheral Tools

install-sql-server-ssas-together

Install SQL Server & SSAS Together

14 Steps to Install SQL Server 2019

  • Installation > New SQL Server stand-alone installation
  • Product Key > Enter the 25-character key
  • License Terms > I Accept the License Terms
  • Global Rules > Next
  • Microsoft Update > Use Microsoft Update to Check for Updates > Next
  • Install Setup Files > Next
  • Install Rules > Next

Installing SSAS During SQL Server Installation

  • Feature Selection > Select The Components That You Want To Install > Next

This window is where we need to install and activate the SSAS service and the other services we need for the rest of our work.

In this window, we should select the components we need to carry out their installation process. Here, we need this option called “Database Engine Services” for our work and to install the services relevant to the SQL server core. Another option we need to choose is “Analysis Services.”

By selecting these two options, we have both OLTP and OLAP databases at our command and can meet all the requirements of SSAS projects.

Continue to Install SQL Server 2019

  • Instance Configuration > Select Either Default Instance or Named Instance
  • Server Configuration > Determine The Usernames and Passwords | Choose Your Desired Language >Next
  • Database Engine Configuration > Choose the authentication mode > Specify locations for storing files
  • Ready to Install > See a Summary of All SQL Server Components > Install 
  • Installation Progress > Next
  • Install Completion > Close
adding-ssas-to-an-existing-sql-server

Adding SSAS To an Existing SQL Server

11 Steps To Adding SSAS To an Existing SQL Server

  • Double Click on Setup.exe
  • Installation (navigation bar on the left) > “New SQL Server stand-alone installation or add features to an existing installation.”
  • Select “Add features to an existing instance of SQL Server 2019” > Choose The Instance We Are Adding To > Next
  • Check “Analysis Services” > Set “Instance root directory” > Next
  • Configure “Account Name” | Specify which users will have administrator privileges for Analysis Services.  > Set Startup to Automatic > Next
  • Select ‘Server Mode’ | Tabular or Multidimensional 
  • Click “Data Directories” > 
  • Select “Add Current User” | To add the account that SQL Server Setup is running under > Ok > Next
  • Verify Summary
  • Install
  • Close
adding-ssms-to-an-existing-sql-server

Adding SSMS To an Existing SQL Server

3 Steps to Adding SSMS To an Existing SQL Server

  • Double-click on the downloaded file
  • Change the SSMS installation path if necessary > Install 
  • Close

4 Steps to Connect to SSMS

  • Set the Server Type on the Database Engine or Analysis Services

  • Select the Server Name and Authentication Type in this window

  • Enter the User Name and Password that you have specified in the install step

  • Finally, click on the Connect button

After running SSMS using one of these two methods, the SQL Server instance connection window opens up as illustrated in the figure below, and you can connect to a SQL Server instance.

connect-to-a-sql-server-instance-window

 “Connect to a SQL Server Instance” Window

If this window is not opened automatically, you can open it up manually from the Object Explorer > Connect > Database Engine path:

manual-opening-connect-to-server-window

Manual Opening of the “Connect to Server” Window

After running the above program, you need to select which SQL Server you want to connect to from the Server Type expanding list.

If you want to access OLTP databases, you must select the Database Engine option.

And if you want to use OLAP databases, select the Analysis Services option.

  • If you want to access OLTP databases, you must select the Database Engine option.

  • And if you want to use OLAP databases, select the Analysis Services option.

install-visual-studio-without-ssas-extension

Install Visual Studio 2019 Without SSAS Extension

12 Steps to Install Visual Studio Without SSAS Extension

  • Right-click and select the Run as administrator on the downloaded file
  • You will be asked for permission to continue > Yes 
  • Next
  • Accept the software License terms and Privacy 
  • Accept the software License terms and Privacy
  • Continue
  • The Installer fetches the required files to install the Visual Studio 2019
  • Choose the components you need
  • Specify the installation location
  • Install
  • Please, Waite …
  • Finish
install-visual-studio-without-ssas-extension

Install Visual Studio 2022 Without SSAS Extension

6 steps to install Visual Studio 2022

  • Visual Studio Installer > Continue

visual-studio-2022-install-step1-part1
Visual Studio 2022 Install-Step1-Part2
  • Choose The Components You Need
visual-studio-2022-install-step2
  • Specify The Installation Location
Visual Studio 2022 Install-Step3-Part1
Visual Studio 2022 Install-Step3-Part2
  • Install
Visual Studio 2022 Install-Step4
  • Please Waite …
Visual Studio 2022 Install-Step5-Part1
Visual Studio 2022 Install-Step5-Part2
  • Finish
Visual Studio 2022 Install-Step6-Part2
adding-ssas-to-an-existing-visual-studio

Adding SSAS To an Existing Visual Studio 2022

7 Steps to Adding SSAS To an Existing Visual Studio 2022

  • Click the Extensions Menu > Click on the “Manage Extensions” option

adding-ssas-to-an-existing-visual-studio-2022-p1
  • Search for “SSAS” in the search bar

You can see in this section that it has brought the Microsoft Analysis Services Projects 2022 for us with a download button beside it.

  • Click the Download Button

  • After the download process is done, we Double-Click on it for the SSAS to install.

adding-ssas-to-an-existing-visual-studio-2022-p4
  • Click the Install Button

adding-ssas-to-an-existing-visual-studio-2022-p5
  • Close The Visual Studio (Click the End Tasks Button)
adding-ssas-to-an-existing-visual-studio-2022-p6
adding-ssas-to-an-existing-visual-studio-2022-p7
  • Click the “Close” button.

adding-ssas-to-an-existing-visual-studio

Adding SSAS To an Existing Visual Studio 2019

8 Steps to Adding SSAS To an Existing Visual Studio

  • Click the extension menu and click on the “manage extension” option.
  • Search for “SSAS” in the search bar.

You can see in this section that it has brought the Microsoft Analysis Services Project for us with a download button beside it.

  • I should first click on this button for the extension to download and then start installing it.

After clicking the download button of this extension, its download process starts.

  • After the download process is done, we double-click on it for the SSAS to install.
  • We select our desired language and click ok.
  • We hit next in the next window.
  • And eventually hit the “install” button for the SSAS installation to start.
  • Click the “Close” button.

Introducing Resources

Written by: Moslem Afrashteh

Get Exclusive SSAS Tips

That I Only Share With

Email Subscribers

Leave A Comment