Install SQL instance on domain controller

Installing SQL instance is not recommended and will usually fail (when starting the service section in the wizard). If this happens you can try the following:

This usually occurs when the master.mdf or the mastlog.ldf gets corrupt . In order to solve the issue go to the following path C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL , there you will find a folder ” Template Data ” , copy the master.mdf and mastlog.ldf and replace it in C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Data folder . Thats it . Now start the MS SQL service and you are done

It will reset the sa password.


Default sa passwords.

SQL Server 2008/R2 Express
User:  sa
Password:   [blank password – leave field empty to connect]

SQL Server 201x Express
User:  sa
Password: Password123

SQL Server 20xx Web or Standard
User: sa
Password:   will be the same as your administrator or root user password at the time the VDS was provisioned.


Login via management studio and run the following to change sa password:




Otherwise you can you use the following link to do it properly.

How to Install Microsoft SQL on a Domain Controller

Run Visual Studio as admin (need to run this to execute ps/iis scripts within)

Rightklick devenv.exe and choose Troubleshoot compatibility. In the new window click at Troubleshoot programm, then check The programm requires additional permission.

This forces the settings to administrator rights only, without running in compatibility mode.

Otherwise with other programs you should be able to right click and hit properties. There should be a compatibility tab. If not need to enable the compatibility tab in win 10.