1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Can I remove / rejoin SQL server from domain without issue?

Discussion in 'Windows Server' started by jaqcal, May 11, 2018.

Advertisement
  1. jaqcal

    jaqcal Thread Starter

    Joined:
    May 11, 2018
    Messages:
    2
    Background: Our company has 2 physical DCs running Windows Server 2008 R2 and one physical SQL Server serving Microsoft Dynamics NAV to around 50 users. Recently I have been unable to add existing domain users into NAV and it appears the SQL Server has lost its trust relationship with the DC and is only authenticating existing users on cached data. The only method I've ever found to work in the past to fix the trust relationship issues is to remove and rejoin a system to the domain. I am not very proficient with SQL though, so my question is:

    If I make a backup of the SQL database and remove the SQL server from the domain, can I rejoin it without any issues with NAV reading AD and authenticating users? What other things (if any) do I need to take into consideration when removing and rejoining a SQL server to the domain?

    Thank you!
     
  2. srhoades

    srhoades

    Joined:
    May 15, 2003
    Messages:
    2,297
    Best practice is to not have an SQL server as a domain controller. Creates performance issues. I advise getting another server for SQL.
     
  3. jaqcal

    jaqcal Thread Starter

    Joined:
    May 11, 2018
    Messages:
    2
    Thanks for the reply srhoades. I'm sorry if I wasn't clear in my description, but we are not running the SQL server as a DC. We have 2 DCs independent of the SQL server. The DCs will remain on the domain. My question is just if I can remove and rejoin the SQL server without issues with AD.
     
  4. Fireflycph

    Fireflycph

    Joined:
    Apr 1, 2016
    Messages:
    467
    First Name:
    Morten
    Yes, you should be able to remove the SQL server account from AD without any issues. As long, as it's not a DC. Which I take it it isn't. I'd boot the DC's and maybe even rename the SQL server, if that won't cause too many inconveniences.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Similar Threads - remove rejoin server
  1. JesseTechHelp
    Replies:
    5
    Views:
    589

Short URL to this thread: https://techguy.org/1210064

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice