Can I add 2019 Standard Server to a SBS 2011 Domain as a SQL Server?

Jason Jacobsen 1 Reputation point
2021-08-11T18:03:00+00:00

I have a new 2019 server standard that I am going to make and SQL server. I am having problems joining it to my existing SBS 2011 domain as just a file server. What am I missing? I just tried to add it the regular way by configuring the IP and Gateways and just joining the Domain.

Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,307 questions
0 comments No comments
{count} votes

7 answers

Sort by: Most helpful
  1. Dave Patrick 426.2K Reputation points MVP
    2021-08-12T17:26:42.697+00:00

    Sounds good,

    --please don't forget to upvote and Accept as answer if the reply is helpful--

    1 person found this answer helpful.
    0 comments No comments

  2. Dave Patrick 426.2K Reputation points MVP
    2021-08-11T18:43:53.157+00:00

    What happens when you try? Make sure the domain controller and problem member both have the static ip address of DC listed for DNS and no others such as router or public DNS.

    --please don't forget to upvote and Accept as answer if the reply is helpful--


  3. Dave Patrick 426.2K Reputation points MVP
    2021-08-11T19:17:19.99+00:00

    Please run;

    Dcdiag /v /c /d /e /s:%computername% >C:\dcdiag.log
    repadmin /showrepl >C:\repl.txt
    ipconfig /all > C:\dc1.txt
    ipconfig /all > C:\problemmember.txt

    then put unzipped text files up on OneDrive and share a link.


  4. Dave Patrick 426.2K Reputation points MVP
    2021-08-11T21:59:38.357+00:00

    Dcdiag /v /c /d /e /s:%computername% >C:\dcdiag.log (on domain controller)
    repadmin /showrepl >C:\repl.txt (on domain controller)
    ipconfig /all > C:\dc1.txt (on domain controller)
    ipconfig /all > C:\problemmember.txt (on problem member server)

    then put unzipped text files up on OneDrive and share a link.


  5. Dave Patrick 426.2K Reputation points MVP
    2021-08-11T22:46:43.507+00:00

    Please do not zip the files.