Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

MSSQLServerADHelper100

Posted on 2010-09-20
4
Medium Priority
?
4,027 Views
Last Modified: 2012-05-10
SQL 2008 fails to install because this service is missing, or registry key is not found.  The system had a manual cleanup of the registry to delete keys pointing to a dead SQL installation.  Do not want to restore registry.  Can someone tell me where this key should be and post a sample so I can edit and see if it will go?
0
Comment
Question by:billherde
  • 2
  • 2
4 Comments
 
LVL 11

Expert Comment

by:Ved Prakash Agrawal
ID: 33723052
Are you trying to first time or repairing installation?

Try to uninstall sql server and then try to install again.

if you want to install only particular component and sql server is already installed. go to add remove program and click change to add missing component.
0
 
LVL 11

Expert Comment

by:Ved Prakash Agrawal
ID: 33723061
MSSQLServerADHelper100 will be in many places in the registry and its not easy to make changes. so the best way is to reinstall/Repair.
0
 
LVL 3

Accepted Solution

by:
billherde earned 0 total points
ID: 33723396
Made the call to Microsoft, and did a manual cleanup of all installation.  Reinstall went to the same point and died.  TS found that active directory is causing the problem as the SQL cluster being installed is supposed to be taking the name of the old SQL server.  Old SQL server was renamed, but AD did not update and names are all messed up.  Old server also cannot log into domain.  Will update staus on another question posted a little while ago, but it appears this is not a SQL or MSI issue.
0
 
LVL 3

Assisted Solution

by:billherde
billherde earned 0 total points
ID: 33755971
Closing this request as it turns out the problem was only reflected in the SQL installation. AD problems with object names is what was causing the problem.  Once conflicting named server was removed and metabase cleanup done SQL installed normally.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

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…
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

772 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