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!
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!