Menu
I just ran an "update edition" to update from SQL Server 2008 R2 Express to Enterprise. I first ran the update edition process, and then separately added the Analaysis Services component. All these processes ran without reporting any errors.
When I open SQL Server Configuration Manager, I can see under "SQL Server Services" that Analysis Services is running.
However, when I start up SQL Server Management Studio and get to the "Connect to..." dialog, in the "Server Type" dropdown I don't get the option to select "Analysis Services" (all I get is "Database Engine" and "SQL Server Compact"). This means I can't actually connect to the Analysis Services server, even though it seems to be running.
Any suggestions as to what is going on, or what I need to change in order to enable Management Studio to "see" the Analysis Services server?
767
asked Jun 07 '11 13:06
Install using the wizardOn the Feature Selection page, select Analysis Services from the feature tree. On the Analysis Services Configuration page > Server Configuration tab, select a mode. Then add users that will have Administrator permissions for the instance.
Grant the SQL Server Agent account administrator permission on SSAS. Using Management Studio, connect to the remote SQL Server Analysis Services instance. Right-click the server name, click Properties, and then click Security. Click Add to add the SQL Server Agent account.
I think Brian Knight might have answered this issue in serverfault.com. See the following link for more information: https://serverfault.com/questions/152904/unable-to-connect-to-sql-server-analysis-services-on-windows-vista/153625#153625
Make sure you've installed Management Studio with the Full option. The basic installation option doesn't install support for Analysis Services. You can add Management Studio features by running the installer again. I hope this helps.
136
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
