Solved

Error installing 2nd instance of Sql Server 2008 R2

Posted on 2012-03-21
2
281 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:Jason Yousef, MS
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
This query failed in sql 2014 5 32
Sql server function help 15 31
SQL SELECT query help 7 41
Merge two rows in SQL 4 16
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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.

821 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