Cannot Install Microsoft SQL Server on a Domain Controller

Show expandable text

For security reasons, Microsoft recommends that you not install SQL Server 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 or a network 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, setup will fail.

Install Microsoft SQL Express from X:\Product Download\MSI\SQLEXPR_x86_ENU.exe (where X represents the drive where the application is installed and "program directory" for the application's installation folder. Instructions for installing Microsoft SQL Server can be found in Upgrading or installing a Microsoft SQL instance.

After successfully installing Microsoft SQL Server, you can continue with the installation and complete Step 2, "Configure Database Server."

  1. Choose the Use an existing instance of Microsoft SQL Server option, and click Next.
  2. Choose the instance that you created when you installed SQL Server above.
  3. Continue with Step 3 to install the application.
  4. Follow any prompts on screen and click Finish.

Was this article helpful?

Thank you for the feedback!