SQL install Fails at Creating database Engine

---

 

This happens if SQL is installed on a Domain Controller. It is not recommended that SQL be installed on a Domain Controller. Please see the Microsoft link below:

SQL installation on a Domain Controller – Important Notes

Please ensure that you have IT (internal or external) perform steps.

1

Verify the SQL services have installed

2

Log into SQL Mgmt. Studio as the sa user with a blank password

3

Access Security and expand Logins

4

Right click on Logins, select New Login and leave it at Windows Authentication

5

Add in the account of the Administrator and click OK to the screen below

6

Select Server Roles and add in the sysadmin and public role and click OK

7

Next right click on the sa user and go to properties and add in a password and click OK

8

Test the Administrator login by accessing File -> Connect Object Explorer and choosing Windows Authentication and verify the account login is okay now

9

Test the sa account with the password you just created via Connect Object Explorer

10

Access the Windows services module.

11

Right click on SQL Server for the Amicus Attorney by CARET instance and go to Properties

12

Select the Log On tab and then This account

13

Browse for the same Administrator account you added to the SQL Security Login above

14

Type in the admin password and click OK

You will receive a message that the account has been granted rights to login as that service

15

Perform the same steps on the SQL Server Agent service

16

Start both services

That’s it! Continue on to the Amicus Premium 2016 Installation.

If at any time these steps fail please contact Microsoft. CARET is not responsible for troubleshooting your SQL installation.