Q

Can SQL and AD exist on a single system?

Is it possible to have a SQL and AD on single system? Will there be any conflicts?

Is it possible to have a SQL and AD on single system? Will there be any conflicts?
It is certainly possible to install SQL Server on an Active Directory domain controller. However, this creates two potential issues that you need to be aware of.
  1. Additional processor and hard drive overhead will be required of the physical hardware, since both applications can be resource-intensive.

  2. From a security perspective, it's often preferable to separate mission-critical applications onto separate physical devices so that you can reduce the attack exposure on each machine. If your SQL Server is residing on your domain controller and an attacker were able to compromise the physical server using a SQL vulnerability, they would essentially have the "keys to the kingdom" since your sensitive AD information would also be compromised at that point.
This was last published in November 2005

Dig Deeper on Microsoft Active Directory Design and Administration

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchServerVirtualization

SearchCloudComputing

SearchExchange

SearchSQLServer

SearchWinIT

SearchEnterpriseDesktop

SearchVirtualDesktop

Close