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

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

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!
 
Joined
May 15, 2003
Messages
2,298
Best practice is to not have an SQL server as a domain controller. Creates performance issues. I advise getting another server for SQL.
 

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.
 

Fireflycph

Morten
Joined
Apr 1, 2016
Messages
1,537
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.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

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 807,865 other people just like you!

Latest posts

Members online

Top