Uninstall AD from SQL server - problems?

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?
LVL 3
FWestonAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

David ToddSenior DBACommented:
Hi,

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.

Regards
  David
0
Paul MacDonaldDirector, Information SystemsCommented:
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.
0
Seth SimmonsSr. Systems AdministratorCommented:
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

http://blogs.technet.com/b/mdegre/archive/2011/07/01/can-i-install-sql-server-on-a-domain-controller.aspx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Paul MacDonaldDirector, Information SystemsCommented:
Interesting!
0
FWestonAuthor Commented:
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.
0
Seth SimmonsSr. Systems AdministratorCommented:
not recommended so never done it

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

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/879c9c63-8069-43db-8593-7149ee273054/cannot-start-any-sql-server-services-to-run-the-server-after-demoting-a-dc?forum=sqldatabaseengine
0
Seth SimmonsSr. Systems AdministratorCommented:
the link i posted in my first post answers the original question
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.