• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 452
  • Last Modified:

promoting a dedicated SQL 2005 Standard server to a domain controller

I have a Windows 2003 Standard server that also has SQL installed on it.  I'm using it for a file/SQL server for 15 users.  I have another server that is a domain controller.  It is dedicated for a domain controller.  I want to promote my SQL server to a domain controller also.  The reason for this is to have multiple DC's and we're limited on backup licenses for our DR site and limited on storage.  So...  I want to save a license/storage and simply make one of the servers already being replicated a domain controller.  Is this okay?  I thought using a SQL server as a DC was not recommended.. But...  In an envorinment this small I didn't think it would matter too much.
0
gopher_49
Asked:
gopher_49
  • 2
  • 2
1 Solution
 
MrAliCommented:
Having SQL Server do both isn't recommended, and there are nuances with clustering as well, you do not cluster DCs so keep that in mind if you are in fact, utilizing clustering.  If the current server is already a member of the domain, just not a DC, then you just need to run DCPROMO from a dos (command) prompt.  If it isn't, then you have a bunch of permission issues we need to resolve first.  Let us know if it isn't.
0
 
Jason WatkinsIT Project LeaderCommented:
Make sure the SQL server is using the DC (or domain's DNS server) for it's DNS server
0
 
gopher_49Author Commented:
The SQL server is a member server and already using the correct dns server, however, I don't want to cause any issues in the future.  I do not use clustering nor do I plan to.  Is this a safe config?
0
 
Jason WatkinsIT Project LeaderCommented:
Will the SQL component still be needed after the server has been promoted? File system security and GPO setting change to a server after it has been promoted. Any local account that may exist on the server will no longer be available after promotion.
0
 
MrAliCommented:
Since your computer was already a member of the domain, you should be pretty good already with permission issues and such.  It's not recommended practice but yes, it will work.  I've seen SQL ran on domain controllers before numerous times.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now