Installing SQL Server 2008 Analysis Services – Screenshots Step By Step

Leave a comment (0) Go to comments

What is Analysis Services?

Why we use Analysis Services ?

What are the Key features of Analysis Services?

Microsoft SQL Server Analysis Services (SSAS) provides functionality for online analytical processing (OLAP) and data mining functionality for business intelligence applications.

Analysis Services enables us to analyze large quantities of data. By using Analysis Services, we can design, create, and manage multidimensional structures that contain detail and aggregated data from multiple data sources.

Microsoft Analysis Services provides us a single point of access for an organization’s business intelligence (BI) data by providing capabilities of

  • OLAP functionality allows us to query aggregated data that is stored in multidimensional cubes.
  • Data mining can identify relationships within your data and assess probabilities of future results based on past actions.
  • KPI support to create balanced scorecards to evaluate performance against business objectives.
  • Combining data from both OLAP and relational sources.

Microsoft Analysis Services is not a separate component,. SQL Server Analysis Services is shipped with SQL Server only and there is no separate licensing required to use Analysis Services.


How to Install Microsoft SQL Server Analysis Services ?

Microsoft SQL Server Analysis Services is installed using a SQL Server Setup media only.

STEP BY STEP Guide to Install Microsoft SQL Server Analysis Services with Screen Shots.

Step 1 – Locate the SQL Server Installation Files on Media  and start the run the Setup.exe, which will open a SQL Server Installation Center

Installing SQL Server 2008 Analysis Services   Screenshots Step By Step install SQL Server Analysis Services 2008 How to Install Microsoft SQL Server Analysis Services

Step 2 – In SQL Server Installation Center window, Click Installation on the left.

Installing SQL Server 2008 Analysis Services   Screenshots Step By Step install SQL Server Analysis Services 2008 How to Install Microsoft SQL Server Analysis Services

Step 3 – Click New SQL Server stand-alone installation or add features to an existing installation

Installing SQL Server 2008 Analysis Services   Screenshots Step By Step install SQL Server Analysis Services 2008 How to Install Microsoft SQL Server Analysis Services

Step 4 – The SQL Server 2008 Setup window opens. Once the  operation on the Setup Support Rules page has completed, click OK.

Installing SQL Server 2008 Analysis Services   Screenshots Step By Step install SQL Server Analysis Services 2008 How to Install Microsoft SQL Server Analysis Services   

Step 5 – On the Product Key page, select your Edition for which you have license and supply the product key. I this scenario, I am use a Evaluation Edition, which is freely hosted on Microsoft site and valid to use for 180 days.

Installing SQL Server 2008 Analysis Services   Screenshots Step By Step install SQL Server Analysis Services 2008 How to Install Microsoft SQL Server Analysis Services   

Step 6 – On the License Terms page, check I accept the license terms, and then click Next.

Installing SQL Server 2008 Analysis Services   Screenshots Step By Step install SQL Server Analysis Services 2008 How to Install Microsoft SQL Server Analysis Services   

Step 7 – On the Setup Support Files page, click Install.

Installing SQL Server 2008 Analysis Services   Screenshots Step By Step install SQL Server Analysis Services 2008 How to Install Microsoft SQL Server Analysis Services

Step 8 – Once installation has finished,  click Next

Installing SQL Server 2008 Analysis Services   Screenshots Step By Step install SQL Server Analysis Services 2008 How to Install Microsoft SQL Server Analysis Services   

Step 9 – On the Feature Selection page, select the Analysis Services to install. In case you don’t have any other component installed on this Server then select Client Tools
Connectivity, Management Tools – Basic, and Management Tools –
Complete checkboxes too, this will useful for management  and then click Next.

Installing SQL Server 2008 Analysis Services   Screenshots Step By Step install SQL Server Analysis Services 2008 How to Install Microsoft SQL Server Analysis Services

 Step 10 – On the Instance Configuration, specify you wanted to install a named or a default instance.

SQL Server Analysis services supports multiple instances, if you are a beginner and installing on test machine then select default instance option.

Installing SQL Server 2008 Analysis Services   Screenshots Step By Step install SQL Server Analysis Services 2008 How to Install Microsoft SQL Server Analysis Services

 Step 11 – On the Disk Space Requirements page, SQL Server Installation center will let you know, what space required for completing this installation.

Installing SQL Server 2008 Analysis Services   Screenshots Step By Step install SQL Server Analysis Services 2008 How to Install Microsoft SQL Server Analysis Services

Step 12 – On the Server Configuration page, provide the Use User ID and password under which Analysis Services will run. if you are unsure of this, provide you current login credentials or select Local System account.

Installing SQL Server 2008 Analysis Services   Screenshots Step By Step install SQL Server Analysis Services 2008 How to Install Microsoft SQL Server Analysis Services

 Step 13 – On the Analysis Services Configuration page, click Add Current User, and then click Next. This will make you current login ID as administrator to manage Analysis Services.

Installing SQL Server 2008 Analysis Services   Screenshots Step By Step install SQL Server Analysis Services 2008 How to Install Microsoft SQL Server Analysis Services

Step 14- Change the Data and  Log Directory, if you point your OLAP databases into some other drive. This would be default path which will be used for Data, Log, Temp and backup files.

Installing SQL Server 2008 Analysis Services   Screenshots Step By Step install SQL Server Analysis Services 2008 How to Install Microsoft SQL Server Analysis Services

 Step 15 – On the Error and Usage Reporting page, clear both checkboxes, and then click Next.

Installing SQL Server 2008 Analysis Services   Screenshots Step By Step install SQL Server Analysis Services 2008 How to Install Microsoft SQL Server Analysis Services

 Step 16 – On the Installation Rules page, click Next and ensure there is no error. If there is any error, SQL Server Installation Center will not allow you to proceed next.

Installing SQL Server 2008 Analysis Services   Screenshots Step By Step install SQL Server Analysis Services 2008 How to Install Microsoft SQL Server Analysis Services

Step 17 – Once the Setup finishes after installing all files Click Close and Exit Setup.

Installing SQL Server 2008 Analysis Services   Screenshots Step By Step install SQL Server Analysis Services 2008 How to Install Microsoft SQL Server Analysis Services

EOF - Installing SQL Server 2008 Analysis Services – Screenshots Step By Step, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

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


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.