How To: Ensure SQL Server Components are Installed

Overview

Before Jet Analytics can be installed, it must have access to the proper SQL Server components. This article shows you how to confirm that each required SQL Server component is installed.

Process

1. Open SQL Server Configuration Manager and click SQL Server Services

   From here, you can see each SQL Server component that is installed on the server.

   

2. Confirm the Database Engine is installed

   During the installation, we will be connecting to an instance of the database engine.  Ensure that the instance is running.

   In this example there are two instances of the database engine, each with a unique name.

   

   Your environment only needs to have a single instance; multiple instances are shown only for reference.

    

3. Confirm SQL Server Analysis Services is installed

   During the installation, we will be connecting to an instance of Analysis Services.  Ensure that the instance is running.

   In this example there are two instances of Analysis Services, each with a unique name.

   

   Your environment only needs to have a single instance; multiple instances are shown for reference.

4. Confirm SQL Server Integration Services is installed and running