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!
+2
A:
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:
OMG Ponies
2010-01-03 04:46:14
Thanks for the fast reply! So if I'm reading things right it sounds like Analysis Services would be installed locally on my machine and this component just wasn't included when SQL Server was installed on my computer? Nothing is actually run on the server itself?
Dave
2010-01-03 05:06:00
It is run on the server itself. It's not just a matter of having the right edition, it has to be selected during installation.
Vinko Vrsalovic
2010-01-03 05:29:46
Thanks for clarifying. I read the additional links that were provided and it sounds like it indeed needs to have been selected and installed on the server. In my case there really isn't an IT person I can go to that knows the particulars of the installation. Is there a way for me to know whether this component was installed? Thanks for your help folks!
Dave
2010-01-03 05:46:47
+1
A:
- Look for
MSSQLServerOLAPService
orMSOLAP$some_name
in services
OR
- Start
SQL Server Configuration Manager
and look underSQL Server Services
Damir Sudarevic
2010-01-03 13:12:37
A:
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.
Joe L.
2010-02-11 14:45:39