Can't install Microsoft SQL Server on a domain controller
important
For security reasons, Microsoft recommends that you don’t install SQL Server on a domain controller.
SQL Server setup won't block installation on a computer that is a domain controller, but the following limits apply:
- You can't 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 can't change the computer from a domain member to a domain controller. You have to uninstall SQL Server before you can change the host computer to a domain controller.
- After SQL Server is installed on a computer, you can't change the computer from a domain controller to a domain member. You have to uninstall SQL Server before you can change the host computer to a domain member.
- SQL Server failover cluster instances aren't supported where cluster nodes are domain controllers.
- SQL Server setup can't create security groups or provision SQL Server service accounts on a read-only domain controller. In this scenario, the 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. You can find instructions for installing Microsoft SQL Server here: 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.”
- Select theUse an existing instance of Microsoft SQL Serveroption, and select Next.
- Select the instance you created when you installed SQL Server.
- Continue with Step 3 to install the application.
- Follow any prompts on the screen and selectFinish.
