Installation of SQL Express 2012 Error

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
blackbear67Asked:
Who is Participating?
 
blackbear67Author Commented:
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.
0
 
Michael FowlerSolutions ConsultantCommented:
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
0
 
blackbear67Author 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
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Vitor MontalvãoMSSQL Senior EngineerCommented:
The Summary isn't enough. For more details errors post the file in %ProgramFiles%\Microsoft SQL Server\110\Setup Bootstrap\Log\
0
 
blackbear67Author Commented:
Here is the folder of the log files. Thank You.
20150319-170349.zip
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
You didn't attach nothing and we only need the log file from the last installation error.
0
 
blackbear67Author Commented:
Because I discovered changing the default account authentication while installing worked.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.