dibekem Posted July 2, 2015 Posted July 2, 2015 Hi Guys. I’m trying to install SQL server 2014 onto a windows server 2012 server for the preparation of SIMS to come in and do the migration of SIMS and FMS from an old server to this new server. I’m keep getting this error: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes. I also get a red cross on the database engine services and SQL server replication with status failed at the end of the installation. In this school we have 2 servers Curriculum and Admin. This new server will be replacing the admin server. When I install the SQL server I choose the 1st option new Sql server standalone installation and then I get this error. Do I get this error because we already have an SQL server in our domain? Or it is nothing to do with? Any help would be much appreciated Thanks
ITGURU Posted July 2, 2015 Posted July 2, 2015 Hi There are several different solutions to this error depending on the contents of the log file, which I think is in this location, may vary depending on version you are installing. C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110831_132727\Detail.txt can you post the contents here. 1
Lou_sim Posted July 3, 2015 Posted July 3, 2015 (edited) Hi, It sounds like a permissions issue. Had the same error myself recently and this fixed it. It is nothing to do with the fact that you already have a SQL server in the same domain. SQL Server Troubleshooting: Could Not Find Database Engine Startup Handle Error During installation - TechNet Articles - United States (English) - TechNet Wiki Edited July 3, 2015 by Lou_sim 1
dibekem Posted July 3, 2015 Author Posted July 3, 2015 Summary.txtDetail.zip Thanks. Here is what I have found in C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap I have also attached a summary txt file which I found there. Thank you
dibekem Posted July 3, 2015 Author Posted July 3, 2015 Hi. Thanks for your reply. I'm using the Administrator account. I thought that this account has every rights. But thanks will look into that article.
ITGURU Posted July 3, 2015 Posted July 3, 2015 Is the SQL Service showing in 'services' can you check what account it is trying to run as. The error you are receiving is either due to the account it's using not having correct privileges to start the service or is corrupt.
dibekem Posted July 3, 2015 Author Posted July 3, 2015 (edited) the account that it states in services/SQL SERVER (SQLEXPRESS) is NT Service\MSSQL$SQLEXPRESS with a really long password? Also the service is not running and I cannot start either. Must be that. Should I change it to the administer account? Edited July 3, 2015 by dibekem
ITGURU Posted July 3, 2015 Posted July 3, 2015 the account that it states in services/SQL SERVER (SQLEXPRESS) is NT Service\MSSQL$SQLEXPRESS with a really long password? Can you try changing it to the domain admin? - I see that you are using SQL Express rather than full SQL.
dibekem Posted July 3, 2015 Author Posted July 3, 2015 great that worked. Thank you so much! Yes I'm using the express version as Capita who looks after SIMS asked me to install that version, I think the full version isn't free so might be that's the reason. So now that the service is running, should I reinstall the SQL server? There was an option in the middle of the install where it was asking for an account. I just assumed it used the admin account which was there but I remember seeing this other account too. Also the SQL Server Agent is disabled in services, should I enable it? Hope that's to too many questions! Thanks
ITGURU Posted July 3, 2015 Posted July 3, 2015 You do have to buy the full version of SQL , express just has some limitations. SQL Agent just means that clients than 'discover' the server, and when programs ask to select an SQL server it will show in the list. You shouldn't need to re-install if it's now working and you can log in with the management console. However, whenever I do an SQL install I always click the button to add the current user. 1
ITGURU Posted July 3, 2015 Posted July 3, 2015 If you want to make things more secure, create a new Domain account with a different password and then use that account to run SQL Server service. great that worked. Thank you so much! Yes I'm using the express version as Capita who looks after SIMS asked me to install that version, I think the full version isn't free so might be that's the reason. So now that the service is running, should I reinstall the SQL server? There was an option in the middle of the install where it was asking for an account. I just assumed it used the admin account which was there but I remember seeing this other account too. Also the SQL Server Agent is disabled in services, should I enable it? Hope that's to too many questions! Thanks 1
dibekem Posted July 3, 2015 Author Posted July 3, 2015 Thanks. I think I'm going to reinstall it now that I know what went wrong. Yes I'm going to create another account just for this especially because if we change the administrator's password later on I guess it would affect this program. About the SQL server I'm only following what the SIMS guys sent to me. They actually emailed me all the files in a zip format. So it should be okay. Thanks so much!
3s-gtech Posted July 3, 2015 Posted July 3, 2015 If this is a new server, have you installed Server 2012 R2, and not Server 2012? R2 brought a large number of improvements - R1 feels clunky in comparison!
dibekem Posted July 3, 2015 Author Posted July 3, 2015 Yes it is R2 Just getting used to it. This is only my 2nd server to setup from scratch & my 1st sql server install. But getting there! (thanks to you of course)
dibekem Posted July 3, 2015 Author Posted July 3, 2015 All done, just reinstalled it and database ok! Thank you!
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now