How to Install ePO and Microsoft SQL on a Domain Controller

As best practices is not recommended to installed ePO or SQL server on a domain controller. If you try to install SQL on a DC most likely the installation will fail and SQL is needed to be able to install ePO server.

For some of us we may want to learn more about ePO but have limited hardware resources and the only option is to installed SQL and ePO on a DC. This tutorial will show you how to installed Sboth products on a domain controller.

  • Microsoft SQL Installation – The following link will show you how to install Microsoft SQL Server Express 2012 on a DC. Once SQL has been installed on the DC, return to this page to proceed with the rest.
  • Add SQL user – To add a SQL user to be used by ePO, first installed SQL Management Studio. Once SQL management studio is installed then proceed to add SQL user, to be use by ePO server.
  • Install ePO – Now we are ready to install ePO server.

Add SQL user to be used by ePO server

Next we are going to add a SQL user that we will be using for ePO to connect to the database. For this you need to have SQL management studio installed.

  1. Open SQL management studio, click Start>All Programs>Microsoft SQL Server 2012>SQL Server Management Studio.
  2. Use the SA account and credentials we used during setup of Microsoft SQL Server, then click “Connect“.
  3. Expand Security folder and then right click on Logins, on the menu select “New Login“.
  4. On the General section change to SQL Server Authentication. For login name enter the name of the desire user. For this example I will be using “epouser“. Make sure to remove Enforce password policy, Enforce password expiration and user must change password at next login.
  5. Next go to Server Roles, and select “Public” and “Sysadmin“, then click “Ok“.

We are done adding a SQL user to be used by ePO to connect to the database. For SQL permission require to install and use ePO please see KB75766.

Installing ePO Server

The last step for this guide is to install ePolicy Orchestrator Server

  1. Run “setup.exe” file to start the installation of ePO.
  2. On the security warning window click “Run“.
  3. On my test environment I have less then 8GB of RAM so ignore this warning. If you get this warning click “OK“. Best practice recommend to have more then 8GB of RAM on a production ePO server.
  4. On the next window select “Next“.
  5. On the next Windows select “Custom” then click “Next“.
  6. Select “Microsoft SQL Server“, then “Next“.
  7. Click “Next” to install Microsoft Visual C++..
  8. Let the installation finish installing Microsoft Visual C++.
  9. After is done click “Next“.
  10. The installer will try to search for SQL is ok if it cannot find it.
  11. Once it fails to find the SQL server, you will get the option to put the information yourself.
    • For Database Server, you must put in the hostname\instance.
    • For SQL authentication, use the SQL user we created and credentials.
    • If your are not sure of the host name, open command prompt and type hostname.
    • If you are not sure of the name of the instance, open SQL Server Configuration Manager, under SQL Server Network Configuration, you should find the protocol for <instance name> .

    After you enter all the information click “Next”.

  12. You might get an error saying that it was unable to find SQL, in the previous step it did not allow you to put a port number. Once it errors out, you will have the opportunity to add a port number. The port we are using is “1433”, if the installation continues, just wait for next screen.
  13. For this example I left all the ports as default, just click “Next“.
  14. Insert a password to be used for the admin account and Key passphrase then click “Next“.
  15. Insert your ePO key, disable or unselect “Enable Automatic Product Installation”, then click “Next“.
  16. Accept the license agreement then click “OK“.
  17. Then click “Install” to start the installation process.
  18. The installation will proceed.
  19. Once the installation complete just click “Finish“.

This concludes the installation of ePO & Microsoft SQL on a DC, if you have any questions or comments please let me know.

Leave a Reply

Your email address will not be published. Required fields are marked *