Post reply

Central Management Servers

  • December 11, 2013 at 9:53 pm

    #73558

    Comments posted to this topic are about the item Central Management Servers

  • December 11, 2013 at 10:58 pm

    #1672827

    Very good question and good explanation.

  • December 12, 2013 at 12:29 am

    #1672842

    Good! I will try!

    😀

  • December 12, 2013 at 1:02 am

    #1672852

    Awesome question and nice explanation..

    Thanks Steve.

  • December 12, 2013 at 1:42 am

    #1672857

    Good question!

    I went for the first option and got it wrong and still don't know why?

    I then run two profilers for the following query:

    USE master

    GO

    SELECT * FROM sysdatabases;

    GO

    and got the query on both of them.

    Regards,

    IgorMi

    Igor Micev,My blog: www.igormicev.com

  • December 12, 2013 at 2:22 am

    #1672868

    Nice question!

    As per BOL

    http://technet.microsoft.com/en-us/library/bb895144.aspx

    Note that the Central Management Server cannot be a member of a group that it maintains.

  • December 12, 2013 at 3:55 am

    This was removed by the editor as SPAM

  • December 12, 2013 at 6:15 am

    #1672922

    Steve, good question.

    Thanks

  • December 12, 2013 at 6:18 am

    #1672923

    I got the right answer for the wrong reason. Since you did not say you added the first server to the group, I figured it would not run there. I did not know the CMS could not be part of the group it hosts.

  • December 12, 2013 at 6:26 am

    #1672927

    Well I was wrong, but at least I was in the majority.

  • December 12, 2013 at 8:01 am

    #1672963

    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?

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • December 12, 2013 at 8:04 am

    #1672966

    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.

  • December 12, 2013 at 8:08 am

    #1672968

    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

  • December 12, 2013 at 10:04 am

    #1673016

    I never used this feature - this QotD sent me to TechNet. Thanks, Steve!

  • December 12, 2013 at 3:55 pm

    #1673112

    Great for testing results across environments (DEV-TEST-UAT-QA-PROD). Thanks, Steve.

Viewing 15 posts - 1 through 15 (of 23 total)

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