We help IT Professionals succeed at work.

Installation of SQL Express 2012 Error

blackbear67 asked
When Installing SQL Express 2012 on our Windows 2012 R2 64 bit server I encountered Database Engine Services Error  0x851A001A.

I have tried various ways to fix the issue but I am now stumped and in need of help ASAP. Please keep answers simple as I am not a true db guy. I will attach the install log for reference.

Watch Question

Michael FowlerSolutions Consultant

Have a look at this solution

1. Go to SQL Server Configuration manager, right click on the SQL Server service, and change the service account (if it is local system, give it a windows level account, and vice-versa). It might throw a WMI error but you will see the account getting updated anyway. If not, then use the Services console. Change the account for SQL Agent as well.
2. Next, try to start the service. It should come online.
3. However, you will not be able to log in to the SQL Server
4. Now stop the service and start it from the command prompt using -m -c -T3608 parameters.
5. Now try logging in to the server using admin connection from sqlcmd (sqlcmd admin:<server name>\<instance name> ...)
6. Once logged in, use the sp_addsrvrolemember '<domain\username>','sysadmin'.
Also add the builtin/administrators to the sysadmin role
7. Now stop the service from the command prompt and start it from SQL Server configuration manager


I changed the service account but the service will still not start.
The SQL Server (MSSQLSERVER) service terminated with the following service-specific error:
Vitor MontalvãoIT Engineer
Distinguished Expert 2017
The Summary isn't enough. For more details errors post the file in %ProgramFiles%\Microsoft SQL Server\110\Setup Bootstrap\Log\


Here is the folder of the log files. Thank You.
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

You didn't attach nothing and we only need the log file from the last installation error.
I think I have it fixed.
I uninstalled SQL
removed all reg settings
started the install process again but this time I selected the administrator account instead of the system account in the install options.  All services started with no errors.


Because I discovered changing the default account authentication while installing worked.