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?
parpaaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Then try the install again.
0
parpaaAuthor Commented:
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.
0
dipopoCommented:
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
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

parpaaAuthor Commented:
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
0
dipopoCommented:
reboot and try again please.
0
parpaaAuthor Commented:
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.
0
parpaaAuthor Commented:
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".
0
parpaaAuthor Commented:
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.
0
parpaaAuthor Commented:
can we manually enter the value in the registry so that it would recognize the virtual name of the server and start?
0
dipopoCommented:
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.
0
parpaaAuthor Commented:
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.
0
dipopoCommented:
Honestly given the degree of issues faced with the installation/un-installation of the MS SQL on the given server.

My advice is to re-install Windows, and perform the MS SQL install carefully selecting preferred options. Make a check-list, it works!
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
parpaaAuthor Commented:
i am afraid thats not an option now thats why trying other ways to get it to work.
0
parpaaAuthor Commented:
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
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.