Demoting a SQL 2000 server that is also a Domain Controller

Posted on 2007-08-09
Last Modified: 2013-11-05
In a domain a client has several Domain Controllers.  One of them is also a SQL server (I know this isn't reocmmended, it was already like that).  That server now needs to be demoted.  The only ramification I can think of pertains to how the services are configured.  As long as all services aren't running as local accounts on the server when it's demoted is anyone aware of other complications that I'm not taking into account?  Also, after the demotion people will need to continue to access this machine until I can schedule a anyone aware of complications not restarting immediately?
Question by:IBS_Tech
    LVL 9

    Expert Comment

    Yea, you may run into some authentication issues with users trying to access that box.  
    The SQL jobs may also fail because of this

    Before you demote,
     - Figure out which FMSO roles the server has or if its strictly a BDC.
     - make sure it is pointing to the PDC for DNS resolution.  

    Other than that, you can probably get away with it, but you could also just hold off on the demotion until you are able to reboot.

     - brugh


    Author Comment

    The SQL server holds no FSMO roles.  It is also not the source of DNS.
    LVL 9

    Accepted Solution

    Cool. I think you should be fine.  However, i would still maybe hold off until you can actually reboot following the promotion.  But that's your call.

    Good luck.

     - brugh


    Author Comment

    Can you foresee (as much as possible) any issues before the reboot.  I've love to hold off till after hours, but it may be possible as the restart will be scheduled.

    Author Comment

    No issues, for all who are interested...thanks for confirming my thoughts.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
    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…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Viewers will learn how the fundamental information of how to create a table.

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now