Uninstall AD from SQL server - problems?

Posted on 2013-10-10
Medium Priority
Last Modified: 2016-07-10
I have a Windows 2008 R2 server that is a domain controller and also has SQL 2008 installed.  I want to remove the AD role and convert this to a standard member server without affecting SQL.  There are other DCs in the domain, but currently this server is the only one in this AD site.  I will be provisioning a new server and making it a DC before I demote this server.

Will there be any problems with this approach and are there any special considerations I should be aware of?
Question by:FWeston
LVL 35

Expert Comment

by:David Todd
ID: 39563408

I suggest that you add the Windows 2008 R2 topic to this question, because its a matter of how easily you can demote a controller to an ordinary member server.

The other thing to bear in mind is that often DC have other services - DHCP/DNS/WINS etc - that need to be removed as well.

As a DBA I suggest it would be easier to build a new member server, and migrate the databases etc to the new server, then repurpose the existing one, sell on the second hand market, use as a test machine, etc.

LVL 35

Expert Comment

by:Paul MacDonald
ID: 39563475
So special considerations unless this DC is also an FSMO role holder, in which case you'd want to move the role before demoting the old DC.
LVL 36

Accepted Solution

Seth Simmons earned 2000 total points
ID: 39563503
you cannot demote the server while sql is installed; sql would need to be uninstalled before any domain role changes.  same applies for exchange on a domain controller

Easily manage email signatures in Office 365

Managing email signatures in Office 365 can be a challenging task if you don't have the right tool. CodeTwo Email Signatures for Office 365 will help you implement a unified email signature look, no matter what email client is used by users. Test it for free!

LVL 35

Expert Comment

by:Paul MacDonald
ID: 39563624

Author Comment

ID: 39563654
Thanks for the info.

I didn't include all the info because my primary concern was SQL server.  

This server is a FSMO role holder, but we will move those roles before removing the AD DS role.  It is also a DNS server, but the same applies there, we will move DNS duties elsewhere.

We have already built two separate servers - one of which has SQL 2008 installed and all DBs from the current server will be detached and moved there.  The other new server is a new AD DC.  At the end of the process, this server will go away entirely.  None of these are physical machines, so luckily there is no need to worry about the physical aspect.

seth2740: the article you linked says once SQL is installed the server role can't be changed.  We've already done that once - this is an AWS machine and it had SQL server installed as soon as it was provisioned because SQL was installed in the image this machine came from.  We installed AD DS after SQL was already on the box and it didn't cause any problems.  It would be great if you had any info about uninstalling AD DS on a SQL server vs installing AD DS on a domain controller.
LVL 36

Expert Comment

by:Seth Simmons
ID: 39563715
not recommended so never done it

however, to answer your question, there could be some various issues like account logon problems

LVL 36

Expert Comment

by:Seth Simmons
ID: 41700909
the link i posted in my first post answers the original question

Featured Post

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Transferring FSMO roles is done when an admin wants to split roles between certain Domain Controllers or the Domain Controller holding the Roles has been forcefully demoted using dcpromo / forceremoval
Sometimes it necessary to set special permissions on user objects.  For instance when using a Blackberry server, the SendAs permission needs to be set. I see many admins struggle with the setting that permission only to see it disappear within a few…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

587 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question