how enable de Analysis Service in SQL server ?

Question

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

Answer 1

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:

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

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.

Answer 2

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:

• Analysis Server Properties (Service tab)
• Analysis Server Properties (Log On tab)
• Install SQL Server Business Intelligence Features
• Install Analysis Services in Power Pivot Mode
• Configure the Windows Firewall to Allow Analysis Services Access