Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
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,

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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, December 19, 2014 8:46 AM
Points: 5,676, Visits: 6,488
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

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
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
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 11:30 PM
Points: 1, Visits: 8
Hi,
Please find the solution at below thread,

http://serverfault.com/questions/152904/unable-to-connect-to-sql-server-analysis-services-on-windows-vista/153625#153625
Post #1357792
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse