How you can resolve Your SQL Server installation is either corrupt or has been tampered error
When re-installing Microsoft SQL Server 2005, I came across with following error.
Your SQL Server installation is either corrupt or has been tampered with (Error getting instance ID from name.). Please uninstall then re-run setup to correct this problem
I tried re-run the setup but still it’s failed. When I rebooted the machine, windows reported the same error. I was sure it was because of trying to running the services. Even I removed the whole SQL Server installation, the entries in the services was still existing.
The next thing I googled and found and KB article in Microsoft website to remove the Installation files using Windows Installer Cleanup utility
But that also dint work for me.
I tried the following steps which worked fine for me. I’m not an SQL Server expert. This something a brutal method to resolve this issue. In my system there are two “Instance IDs” for SQL server. Aint bothered about all those stuffs so DO IT AT YOUR OWN RISK.
1. Uninstall SQL server and it’s related components from Add/Remove Programs.
2. Backup the entire registry
3. Remove the SQL Server Services (Instances) from registry resides under HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\
4. Reboot your machine.
5. If you’re not getting the previous error message which you’ve used during logon, you can proceed with Installing SQL Server afresh.
6. The above methods worked fine for me. I also removed HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server key entries as well before re-install. I think it’s not mandatory
