Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Analysis Services not available in 'Server Type' drop-down Expand / Collapse
Posted Friday, January 7, 2011 9:47 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, January 7, 2011 2:53 PM
Points: 3, Visits: 7
Hi there,

First post for me here.

I've just upgraded from 2008 R2 Express to 2008 R2 Enterprise in order to work with some cubes in Analysis Services. I now have two instances of SQL server, SQLEXPRESS (Express) and SQLENT (Enterprise).

During installation, I made sure analysis services was selected and the service now appears in the config manager - great. However, when I try to connect to it from SSMS I run into trouble - 'Analysis Services' isn't available in the server type drop-down in the 'connect to server' dialogue, rather I only have "Database Engine" and "SQL Server Compact".

Does this mean I have to uninstall the whole lot and start again with just one instance of the Enterprise version?

Additional complication in that I can't just detach (from Express) and re-attach (to Enterprise) my existing DBs as it's complaining that Express is a newer version than Enterprise. I've used the 'import and export data' wizard to copy one or two, but have about ten left to get through - is there a quicker way to do this?

For bonus points, how to I restore an .abf file to analysis services?

Thanks all,

Post #1044521
Posted Friday, January 7, 2011 11:06 AM



Group: General Forum Members
Last Login: 2 days ago @ 11:56 AM
Points: 7,508, Visits: 8,664
It might be that you're using the Express client tools. Did you reinstall the client tools as well when you upgraded?

Brandie Tarvin, MCITP Database Administrator

LiveJournal Blog:
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1044569
Posted Tuesday, September 11, 2012 11:35 PM


Group: General Forum Members
Last Login: Thursday, October 27, 2016 5:37 AM
Points: 157, Visits: 220
Please find the solution at below thread,
Post #1357792
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse