Solved

Impact Of Unistalling AD on a Stand-Alone 2003 Server

Posted on 2008-06-25
4
194 Views
Last Modified: 2010-04-18
What impact will there be if AD was removed from a Stand-Alone server that is using the AD only for itself (no other servers or boxes are using AD on this box) and SQL 2005 was running on this server previous to the installation of AD? Will the box need to be rebuilt, and if so why.
0
Comment
Question by:Robert Pollick
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 7

Expert Comment

by:Christopher Martinez
ID: 21869740
At a high level, the directory database is deleted, all of the services required for Active Directory are stopped and removed, the local SAM database is created.

Pulled from Microsoft

2.5.12 Installing SQL Server 2005 on a Windows Domain Controller

Security Note:  
We recommend against running SQL Server 2005 on a domain controller.
 
It is possible to install SQL Server 2005 on a Windows domain controller; however, it cannot run on a Windows Server 2003 domain controller as Local Service or Network Service. SQL Server service accounts should run as Windows domain user accounts. It is also possible to install SQL Server service accounts to run as Local System, but this option is not recommended.

Do not change the role of the server after you install SQL Server 2005. For example, if you install SQL Server 2005 on a member server, do not use the Dcpromo tool to promote the server to a domain controller. Or, if you install SQL Server 2005 on a domain controller, do not use Dcpromo to demote the server to a member server. Changing the role of a server after you install SQL Server 2005 can result in loss of functionality and is not supported.
0
 

Author Comment

by:Robert Pollick
ID: 21870020
So, if another DC was introduced with a different domain, the SQL instances on the box in question is pointed to this new domain, then the box in question were to be demoted, it is not known how SQL will react to this demotion of the DC where SQL is currently installed even though the security for SQL is pointing to this new domain. Am I completely understanding this correctly?
0
 
LVL 7

Accepted Solution

by:
Christopher Martinez earned 500 total points
ID: 21870229
You are correct. SQL doesnt like change. Modifying the DC can result in a loss of SQL functionality. Its unkown how it will react, just frowned upon by microsoft engineers. Sorry for the generality but its not always black and white with these things.
0
 

Author Comment

by:Robert Pollick
ID: 21870301
I appreciate your assistance. Thank you.
0

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

On July 14th 2015, Windows Server 2003 will become End of Support, leaving hundreds of thousands of servers around the world that still run this 12 year old operating system vulnerable and potentially out of compliance in many organisations around t…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

617 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