SQL Server Analysis Services - Do I have it?

sql-server ssas
Dave picture Dave · Jan 3, 2010 · Viewed 37.8k times · Source

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!

Answer

OMG Ponies picture OMG Ponies · Jan 3, 2010

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:

Related questions

SQL Server 2012: Login failed for user 'NT Service\MSSQLServerOLAPService'.; 28000

I am using Analysis services in Microsoft SQL Server 2012 on Windows 7. I tried to create Mining models and process it. I am getting the following error while processing it. OLE DB error: OLE DB or ODBC error: Login failed for …

Read More
SSAS MDX WHERE clause syntax - filtering multiple values from the same hierarchy

I'm quite new to data warehousing and MDX queries, and I realize that I'm probably not using the MDX syntax properly in the case below. I'm using SSAS 2005 on MS SQL Server 2005 and would like to query my cube and …

Read More
deployment of adventureworks cube fails: 'user does not have permission to create a new object in 'GARY-PC' or the object does not exist

when I deploy adventure works cube it fails, and i get: user does not have permission to create a new object in 'GARY-PC', or the object does not exist. trying to process cube from adventureworks DW and having what seem …

Read More