SQL Database on Domain

Answers

• 

  

  0

  Sign in to vote

  Your not totally clear on what it is your are asking here. I would say though unless you have a very, very small environment, I would not want to be installing SQL server on a domain controller, in fact I would not installing anything on a domain controller and let it act purely as a domain controller.

  SQL Server can be very processor / memory intensive and should be run on it's own hardware. Most programs that require a database will give you an option to use a built in database and I would recommend this route if it is an option.

  If your organization is big enough to NEED a SQL server, you should have the finances to purchase a server for this.

  • Proposed as answer by Alex Lv Wednesday, March 11, 2015 2:46 AM
  • Marked as answer by Alex Lv Tuesday, March 24, 2015 10:10 AM

  Tuesday, March 10, 2015 12:58 PM
• 

  

  0

  Sign in to vote

  Hi khaled lfa,

  I agree with MikeeMiracle, additional, It is not recommended to install SQL Server on a domain controller. There are specific security restrictions when running SQL Server in this configuration and given the resource demands of a domain controller, SQL Server performance may be degraded.

  Furthermore, SQL Server is not supported on a read-only domain controller. Setup will normally fail. Even if you find methods to work around the problem with setup, SQL Server is not supported on a read-only domain controller. In addition, SQL Server failover clustering is not supported to install on a domain controller.

  The related KB:

  You may encounter problems when installing SQL Server on a domain controller

  http://support.microsoft.com/kb/2032911

  I’m glad to be of help to you!

  ---

  Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com

  • Marked as answer by Alex Lv Tuesday, March 24, 2015 10:10 AM

  Wednesday, March 11, 2015 2:48 AM