SQL by default cannot be install on a domain controller using the administrator account. Therefore, the installation of SQL will failed if installed on a DC. This guide shows you how to install SQL on a domain controller.
Before we proceed, you must create a domain user with administrator privileges, this will be the account to use on our SQL installation. After the user has been created, proceed with the following steps:
Microsoft SQL Server Installation
- Download Microsoft SQL Server Express 2012 from Microsoft website.
- Once SQL has been downloaded, go to your download folder and double click the file “SQLEXPRWT x64 ENU.exe” to start the installation process.
- A security warning will popup for the SQL setup installation click “Run“.
- On the next windows select “New SQL Server Stand-alone installation” link.
- Accept the license terms then click “Next“.
- Make sure Include SQL Server product updates is selected and then click “Next“.
- The installation will proceed to download updates and additional files.
- Make sure everything is selected as on the image below and then click “Next“
- On the next Windows, name the instance name and then click “Next“.
- This is the critical part in order to be able to install SQL, on SQL Server Database Engine click on the arrow and select “Browse“.
- Next enter the user name, Note: the user has to be a domain administrator but cannot be the user “Administrator”. Click on “Check Names” then click “Ok“
- Then enter the password for the user, then click “Next“.
- Change the Authentication Mode to Mixed Mode and set a password for the SA account, then click “Next“.
- Click “Next” again.
- The installation process will start.
- Once the installation completes, click “close“.
- Now click on the “x” to close windows.
Configure Microsoft SQL Server
Once SQL is installed, now we need to configure it to use TCP/IP and to listen on port 1443 as default port.
- To open SQl server configuration manager, click on “Start>All programs” look for a folder name Microsoft SQL Server under Configuration Tools, select “SQL Server Configuration Manager” or search for “SQL Server Configuration Manager“.
- Expand SQL Server Network Configuration and click on Protocols for “SQLEXPRESS” (Name of Instance), right click on TCP/IP and select “Enable“.
- You will get a warning letting you know that the SQL server needs to be restarted, for the changes to take effect. Click “OK“.
- Once more right click on TCP/IP and select “Properties“.
- Next go down and on each entry for “TCP Dynamic Ports” remove all the “0” and leave it blank. There should not be any 0 in none of the entries for “TCP Dynamic Ports“. Scroll down and remove each one.
- When you get to the bottom of the list on “IP All” change TCP Port to “1433“, this will be the port we will be using for this example. Then click “Apply“.
- You will get a warning letting you know that SQL services need to be restarted, to apply the changes. Then click “OK”.
- Click “OK” again to apply the changes.
- Now select SQL Server Services on the left pane. Then right click on SQL Server (SQLEXPRESS) and in the menu select “Stop“.
- This will stop the service.
- Right Click on it again, but this time, select “Start”.
- After the SQL services has started, click on the “X” button to close the window.
This concludes the installation and configuration of Microsoft SQL Server Express 2012 on a Domain Controller. If you have any questions or comments please let me know.