We help IT Professionals succeed at work.

Installation of SQL Express 2012 Error

blackbear67
blackbear67 asked
on
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.

Summary.txt
Comment
Watch Question

Michael FowlerSolutions Consultant

Commented:
Have a look at this solution
http://blogs.msdn.com/b/sqljourney/archive/2012/03/16/sql-2008-r2-setup-fails-with-quot-wait-on-the-database-engine-recovery-handle-failed-quot.aspx

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

Author

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

Author

Commented:
Here is the folder of the log files. Thank You.
20150319-170349.zip
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
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
reboot
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.

Author

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