CODEWITHSUNDEEP
sql-serverssas
Dave
Dave

Reputation: 103

SQL Server Analysis Services - Do I have it?

Hi I have access to SQL Server at work and I've heard some interesting things that can be done with SQL Server Analysis Services. How do I know whether analysis services is running? Is it installed by default on the server? Would it be installed locally on my machine? Forgive what probably seems like a pretty dumb question, but I couldn't find any concrete details on Microsoft's website. Thanks!

Upvotes: 10

Views: 44176

Answers (3)

Joe L.
Joe L.

Reputation: 1908

When you're in SQL Server Management Studio, click on the Connect button in the Object Explorer. If you see "Analysis Services..." in the list, then you have Analysis Services.

Also, when you launch Management Studio and get the Connect to Server dialog, look in the "Server type" dropdown list. If "Analysis Services" is listed there, then you have it.

Upvotes: 1

Damir Sudarevic
Damir Sudarevic

Reputation: 22177

  • Look for MSSQLServerOLAPService or MSOLAP$some_name in services

OR

  • Start SQL Server Configuration Manager and look under SQL Server Services

Upvotes: 7

OMG Ponies
OMG Ponies

Reputation: 332791

SQL Server Analysis Services is included if you are using the following Editions:

  • Standard
  • Developer
  • Enterprise

Is there a way for me to know whether this component was installed?

It will be listed as a service - Control Panel > Admin Tools > Services, or just type "services.msc" from Start > Run.

Resources:

Upvotes: 16

Related Questions