Search code examples
sql-serverssas

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!


Solution

  • 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: