Skip to main content
Skip table of contents

Installing SQL Server on a Domain Controller - Limitations

SQL Server Installation on a Domain Controller - Limitations

For security reasons, we do not recommend installing SQL Server 2014 on a domain controller. SQL Server will not block installation on a computer that is a domain controller, but the following limitations apply:

  • You cannot run SQL Server services on a domain controller under a local service account.

  • After installing on a SQL Server computer, you cannot change a domain member's computer to a domain controller. You must uninstall SQL Server before changing the host computer to a domain controller.

  • After installing SQL Server on a computer, you cannot change the computer from a domain controller to a domain member. You must uninstall SQL Server before changing the host computer to a domain member.

  • SQL Server is not supported when the cluster nodes are domain controllers.

  • SQL Server The installer cannot create security groups or configure SQL Server service accounts on a read-only domain controller. In this scenario, the installer fails.

Installing SQL Server on a Domain Controller - Limitations

For security reasons, we recommend that you do not install SQL Server 2014 on a domain controller. SQL Server Setup will not block installation on a computer that is a domain controller, but the following limitations apply:

  • You cannot run SQL Server services on a domain controller under a local service account.

  • After SQL Server is installed on a computer, you cannot change the computer from a domain member to a domain controller. You must uninstall SQL Server before you change the host computer to a domain controller.

  • After SQL Server is installed on a computer, you cannot change the computer from a domain controller to a domain member. You must uninstall SQL Server before you change the host computer to a domain member.

  • SQL Server failover cluster instances are not supported where cluster nodes are domain controllers.

  • SQL Server Setup cannot create security groups or provision SQL Server service accounts on a read-only domain controller. In this scenario, the Setup will fail.

Reference:https://docs.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server?view=sql-server-2014

Comment from Dan on 2020-05-11

A Windows Server license comes with 2 OS licenses, and they can be used as follows:

1 Windows Server on the physical host that is only used for Hyper-V.2x VM Windows Server

However, if there is another role on the host, a license must be assigned to it, so there is only one license left for a single VM.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.