asked on

Help with SQL server 2008 r2 corrupted install

Hello Experts,

I have a bad sql server install. I mistakenly installed 1st time with default instance which i dont wont and then uninstalled it and later on try to install with named instance but it would error out in the middle of installation and i just close out and manually start sql server and it would start but not the agent. I even cannot connect to the database engine with the Virtual server name i mentioned. After researching thoroughly i realized both sql server and agent were missing the "VirtualServername" entry in the sql server properties -> Advanced -> Virtual Server Name from the configuration Manager. Now the question is can i manually enter my server name in there?

dipopo

Did you perform a reboot after the install? Try performing a full un-installation ending with a reboot.

Then try the install again.

parpaa

ASKER

Yes i did that. But i can try again. Just to confirm, i am uninstalling throught the mainteance tab on installation launcher and selecting "remove node froma a sql server failover cluster". I hope that would remove all entries from the registry as well. But i have a feeling that its not deleting everything. Give me some time, i can try again and get back to you.

dipopo

Might want to follow these steps and after removing node, might want to un-install MS SQL too via control panel add/remove.

http://msdn.microsoft.com/en-us/library/ms143412.aspx

parpaa

ASKER

Only the database engine and replication failed to uninstall.. below is the error log snippet

Machine Properties:
Machine name: ABC
Machine processor count: 16
OS version: Windows Server 2008 R2
OS service pack: Service Pack 1
OS region: United States
OS language: English (United States)
OS architecture: x64
Process architecture: 64 Bit
OS clustered: Yes

Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered
Sql Server 2008 R2 SQL1 MSSQL10_50.SQL1 Database Engine Services 1033 Enterprise Edition 10.50.1600.1 No
Sql Server 2008 R2 SQL1 MSSQL10_50.SQL1 SQL Server Replication 1033 Enterprise Edition 10.50.1600.1 No

Package properties:
Description: SQL Server Database Services 2008 R2
ProductName: SQL Server 2008 R2
Type: RTM
Version: 10
SPLevel: 0
Installation edition: ENTERPRISE

User Input Settings:
ACTION: Uninstall
CONFIGURATIONFILE: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20131007_122025\ConfigurationFile.ini
ENU: True
FARMACCOUNT: <empty>
FARMADMINPORT: 0
FARMPASSWORD: *****
FEATURES: SQLENGINE,REPLICATION
HELP: False
IACCEPTSQLSERVERLICENSETERMS: False
INDICATEPROGRESS: False
INSTANCEID: <empty>
INSTANCENAME: SQL1
PASSPHRASE: *****
QUIET: False
QUIETSIMPLE: False
UIMODE: Normal
X86: False

Configuration file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20131007_122025\ConfigurationFile.ini

Detailed results:
Feature: Database Engine Services
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Failed: see details below
Configuration error code: 0x1C2074D8@1216@1
Configuration error description: The SQL Server failover cluster instance name '' could not be found as a cluster resource.
Configuration log: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20131007_122025\Detail.txt

Feature: SQL Server Replication
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Failed: see details below
Configuration error code: 0x1C2074D8@1216@1
Configuration error description: The SQL Server failover cluster instance name '' could not be found as a cluster resource.
Configuration log: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20131007_122025\Detail.txt

dipopo

reboot and try again please.

parpaa

ASKER

I didnt reboot then but i followed these instructions and ran the uninstall again and it worked fine.

1.Open Registry Editor and navigate to one of the following locations and ensure that all the values are set to 1. If not, manually edit the respective values and set them to 1.

For a named Instance
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft Microsoft SQL Server\MSSQL10.INSTNAME\ConfigurationState

I rebooted server now and doing a fresh install. I will update you once i finish the install and if there are no more issues i can close this thread.

parpaa

ASKER

It still throws this warning as before.. if i hit ok and continue, it wouldnt finish installation properly..

" wait on the database enfine recovery handle failed.Cehck the sql server error log for potential causes".

parpaa

ASKER

same situation as i called out in my original problem statement. The Virtualservername is blank if i click on the sql server properties -> advanced of config manager.

parpaa

ASKER

can we manually enter the value in the registry so that it would recognize the virtual name of the server and start?

dipopo

Hmmm I think you still have remnant objects referencing the failed SQL install. I'd get rid of everything and have a clean install as otherwise you may face bigger problems later on when it is LIVE with data.

parpaa

ASKER

well that was my question. How do i get rid of all the references of my bad install? I tried to remove everything by uninstalling with control panel and also with the sql install launcher.

ASKER CERTIFIED SOLUTION

dipopo

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

parpaa

ASKER

i am afraid thats not an option now thats why trying other ways to get it to work.

parpaa

ASKER

I found an tool (nevo uninstaller) that removes all the registry key associated wiht the install. So i uninstalled sql server using this tool and since then i am facing this new error during setup. Does anyone know what this means?

Error: No mapping between account names and security IDs was done