how enable de Analysis Service in SQL server ?

Jeyner Alfaro 0 Reputation points
2026-08-10T23:03:45.0366667+00:00

I install SQL Server but the Analysis Service is disable, How active this service?

SQL Server Analysis Services
SQL Server Analysis Services

A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.

0 comments

2 answers

Sort by: Oldest
Most helpful Newest Oldest

  1. AI answer

    2026-08-10T23:04:11.92+00:00

    If Analysis Services is installed but the service is disabled, enable and start it from SQL Server Configuration Manager:

    1. Open SQL Server Configuration Manager.
    2. Open the Analysis Server Properties dialog for the SSAS service.
    3. On the Service tab, change Start Mode from Disabled to Manual or Automatic.
      • Manual: starts only when started manually.
      • Automatic: starts when Windows starts.
    4. Check State. If it is stopped, go to the Log On tab and select Start.

    If Analysis Services was not installed at all, it must be added through SQL Server Setup, because Analysis Services is installed as a SQL Server feature.

    To verify it is running:

    1. Open SQL Server Management Studio.
    2. Connect to the Analysis Services instance.
    3. If the connection succeeds, the service is running.

    If remote connections are needed for a default Analysis Services instance, open inbound TCP port 2383 in Windows Firewall.

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

  2. Erland Sommarskog 137.4K Reputation points MVP Volunteer Moderator
    2026-08-11T07:08:50.7866667+00:00

    You need to run SQL Server Setup to add it, as this is an optional component. Choose the option New SQL Server standalone installation or add features to existing installation. When you come to the page Installation Type, select Add features to an existing instance of SQL Server 2025:

    User's image

    On the next page, you can select the features you want to add. However, the scree may look like this:

    User's image

    No Analysis Services in sight! This is because I took these screenshots from a machine with Express Edition. Thus, if you have Express Edition, you first need to upgrade to a more versatile edition.

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.