Analysis Services not available in 'Server Type' drop-down

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » Analysis Services not available in 'Server...

Analysis Services not available in 'Server Type' drop-down

Rate Topic

Display Mode

Topic Options

Author

Message

phy2sll

Posted Friday, January 07, 2011 9:47 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, January 07, 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

Brandie Tarvin

Posted Friday, January 07, 2011 11:06 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:57 AM
Points: 6,724, Visits: 5,796

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, MCDBA, MCSA

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

durga.palepu

Posted Tuesday, September 11, 2012 11:35 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, April 15, 2013 2:54 AM
Points: 1, Visits: 6

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 »

Permissions