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.
Verify the SQL services have installed
Log into SQL Mgmt. Studio as the sa user with a blank password
Access Security and expand Logins
Right click on Logins, select New Login and leave it at Windows Authentication
Add in the account of the Administrator and click OK to the screen below
Select Server Roles and add in the sysadmin and public role and click OK
Next right click on the sa user and go to properties and add in a password and click OK
Test the Administrator login by accessing File -> Connect Object Explorer and choosing Windows Authentication and verify the account login is okay now
Test the sa account with the password you just created via Connect Object Explorer
Access the Windows services module.
Right click on SQL Server for the Amicus instance and go to Properties
Select the Log On tab and then This account
Browse for the same Administrator account you added to the SQL Security Login above
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
Perform the same steps on the SQL Server Agent service
Start both services
That’s it! Continue on to the Amicus Premium 2016 Installation.
If at any time these steps fail please contact Microsoft. Abacus Data Systems is not responsible for troubleshooting your SQL installation.
Please sign in to leave a comment.