Solved

Error installing 2nd instance of Sql Server 2008 R2

Posted on 2012-03-21
2
276 Views
Last Modified: 2012-03-22
When trying to create a 2nd instance on a Sql Server 2008R2 I receive "Wait on the Database Engine recovery handle failed during setup".

For reference I will call the server:  dbserver/Prod

I read many articles on stopping/starting services using different accounts and that has not worked.  Also there is a potential of a bad ISO which is causing this issue.  So I would like to be able to fix the error above or remove the newly created instance.  I want to keep the original installation because there are no issues.  How can I just remove the newly created instance if I am unable to fix the issue above?

Thank you for your help,
Vince
0
Comment
Question by:wittkieffer
2 Comments
 
LVL 21

Expert Comment

by:huslayer
ID: 37752255
Hi,
I never had this problem before, but I'll try to help, check the SQL server logs for the exact error.
Also while installing, try to use a higher permissible account.

You're saying you get that error, does the installation continues? or stops?
if it stops what instance you need to remove , it's already didn't got installed?!

anyway to remove an instance, you just read this article http://msdn.microsoft.com/en-us/library/ms143412.aspx . and try with a different ISO since you suspects it could be the problem.
0
 
LVL 24

Accepted Solution

by:
DBAduck - Ben Miller earned 500 total points
ID: 37752271
When you go into Control Panel | Add remove programs and click on SQL Server and click Uninstall, you will get the option inside setup of which Instance to remove.  Just don't remove the instance you want to keep.
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how the fundamental information of how to create a table.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now