SQL Server Management Studio

Question

SQL Server Management Studio

river1

SSC-Insane

Points: 24309
More actions
January 5, 2016 at 9:38 am

#399525

Hi,
I installed SQL Server MS.
When I try to register (through registred servers) my SSAS I don't get that option.
Whit SQL 2012 tools the option is available.
CAn someone help?
Thanks,
Pedro

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Luis Cazares SSC Guru Points: 183706 More actions · Answer 1

river1 (1/5/2016)
Hi,
I installed SQL Server MS.
When I try to register (through registred servers) my SSAS I don't get that option.
Whit SQL 2012 tools the option is available.
CAn someone help?
Thanks,
Pedro

Are you using an Express edition or Developer?

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Eric M Russell SSC Guru Points: 125561 More actions · Answer 2

At the top of the 'Registered Servers' tab, there should be four icons: 'Database Engine', 'Analysis Services', 'Reporting Services', and 'Integration Services'. You must click on the 'Analysis Services' icon to list your SSAS instances.

"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

river1 SSC-Insane Points: 24309 More actions · Answer 3

There are not four. Just two (database engine and compact SQL edition)

Lowell SSC Guru Points: 323518 More actions · Answer 4

I believe Registered Servers are SQL only, so are you looking in the "Local Server Groups", or did you actually create a central management server to store the info?

Central Management Servers , which are in the same zone in SSMS can support SSAS.SSRS.SSIS as well as SQL

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

river1 SSC-Insane Points: 24309 More actions · Answer 5

The point is: I should have the option to join (register) Data engines, SSAS, SSIS and SSRS . Same as I have in SQL Server 2012 cliente tool. I don't have it