Add SQL server under CMS

Marco Bakker | DBA.nl 72 Reputation points
2023-01-06T15:49:52.513+00:00

Hi guys,

Can I add a SQL server under the central management server which is not part of the domain? So is for example a workgroup SQL server.

Hope someone knows the answer.

kind regards
Marco

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,779 questions
Accepted answer
  1. Seeya Xi-MSFT 16,441 Reputation points
    2023-01-10T09:37:56.697+00:00

    Hi @Anonymous ,

    In the first link I post, we can read this content: There is one other disadvantage. All registered server connections in the CMS can only use Windows authentication. This means you can only add servers to your CMS that are in the same domain or a trusted domain. You will not be able to add standalone servers that are not in a domain. We generally see this in a DMZ scenario where the SQL Server hosts data for a public facing web server. Along those lines, we typically see that test and development environments are hosted in separate untrusted domains. You will not be able to add these servers either. In these scenarios, you will need a separate CMS in each untrusted domain. Because the machines in my environment are in the domain, I have no way to do the test.

    Best regards, Seeya

    If the answer is the right solution, please click "Accept Answer"

    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Seeya Xi-MSFT 16,441 Reputation points
    2023-01-09T02:53:51.337+00:00

    Hi @Anonymous ,

    You can only add servers to your CMS that are in the same domain or a trusted domain. You will not be able to add standalone servers that are not in a domain. So, you will need a separate CMS in each untrusted domain.

    Please see these blogs, which also contain setup steps.
    https://www.sqlservercentral.com/articles/manage-your-environment-with-cms
    https://www.brentozar.com/archive/2008/08/sql-server-2008s-new-central-management-server/
    Create a Central Management Server and Server Group

    Best regards,
    Seeya

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments
  2. Marco Bakker | DBA.nl 72 Reputation points
    2023-01-09T15:27:09.323+00:00

    Thanks SeeyaXi-msft for your answer.

    Yes the blogs describe adding a server under the CMS within a domain or a second domain. But NOT adding a SQL server which is NOT part of a domain but is a member of a workgroup. I think it is NOT possible, but I'm not quite sure.

    Anybody else with ideas?

    kind regards
    Marco

    0 comments