SQL Analysis Service
In SQL configuration manager I am not seeing the Analysis Service. Is this not installed on:
SQL Server 2008 R2
Description: Windows Server 2008 R2 Ent 64Bit SQL Server 2008 R2
OS: Windows
Status: Running
Thanks,
Mike
-
Hi Mike,
The Analysis Service is not included as standard with SQL Server 2008 R2. However you can install it through the Deployment Wizard provided in the SQL Analysis Services folder under 'All Programs'.
I have attached a screenshot of where this can be located. Please let us know if you have any other questions.
Best Regards,
Scott Petri
-
Hi Scott,
I get an error message when I try this - I can't connect to the server. I reckon that's because Analysis Services aren't running on the machine; it's not installed. The deployment wizard only lets you deploy an analysis services database to a running analysis server.
How can I install analysis services?
Please sign in to leave a comment.
Comments
2 comments