New SQL server install problem

[dibekem]

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]

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.

[Lou_sim]

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

[dibekem]

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]

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]

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]

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]

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]

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]

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.

[ITGURU]

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

[dibekem]

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]

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]

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]

All done, just reinstalled it and database ok!

 

 

Thank you!