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 ««123»»

Central Management Servers Expand / Collapse
Author
Message
Posted Thursday, December 12, 2013 8:01 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 6:09 AM
Points: 1,622, Visits: 2,032
Thanks for the question. I like the suggestion in the reference to run CMS on a development box. Another reference I found explicitly suggested using a developer version to save a license. Thoughts on that?

Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn
Post #1522323
Posted Thursday, December 12, 2013 8:04 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 3:32 PM
Points: 469, Visits: 579
If you really need to add the Central Management Server to a group that it maintains there is a work around to do that.

You can begin a New Server Registration to an existing group as usual, but instead of entering the instance name, enter the IP address of the server. You will have slightly different behaviors when executing queries against that server though. When you start a new query from only that registered server the status bar will show the IP address rather than instance name. However, you run a query against the group the result set will show the server name.
Post #1522327
Posted Thursday, December 12, 2013 8:08 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, March 28, 2014 5:23 AM
Points: 283, Visits: 1,110
Actually you can add SQLSales1 to the group, but you have to use a different way of addressing it.

So for example if you know that SQLSales1 is listening on port 2001, you can add it as SQLSales1,2001. Change the second field in the New Registered Server dialog back to SQLSales1 and it will be still be displayed under the group using that name.

EDIT: Ha - I see shawnjohnson just beat me to it!



Check Your SQL Servers Quickly and Easily
www.sqlcopilot.com
Post #1522330
Posted Thursday, December 12, 2013 10:04 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 12:04 PM
Points: 4,243, Visits: 3,320
I never used this feature - this QotD sent me to TechNet. Thanks, Steve!
Post #1522391
Posted Thursday, December 12, 2013 3:55 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, March 27, 2014 2:39 PM
Points: 2,141, Visits: 486
Great for testing results across environments (DEV-TEST-UAT-QA-PROD). Thanks, Steve.
Post #1522512
Posted Thursday, December 12, 2013 5:30 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 9:57 PM
Points: 1,571, Visits: 690
TO easy -- I use a CMS for all my servers - makes life very simple.

Good question though.


Hope this helps...

Ford Fairlane
Rock and Roll Detective





Post #1522536
Posted Thursday, December 12, 2013 7:16 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 9:46 AM
Points: 3,150, Visits: 1,900
I don't currently use CMS but I might start. Looks like a very handy way to check things across servers. Thanks for making me go look this up Steve!
Post #1522545
Posted Friday, December 13, 2013 5:45 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, March 13, 2014 5:32 AM
Points: 152, Visits: 384
--oops, I overlooked the second page of post, sorry
Post #1522640
Posted Saturday, December 14, 2013 1:17 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 2:16 AM
Points: 922, Visits: 378
Nice tricky question, must read it very carefully so not to fall in the trap.
Post #1522937
Posted Monday, December 16, 2013 12:04 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:41 PM
Points: 12,201, Visits: 9,156
Nice question, thanks.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1523098
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse