I am not sure why I am writing about this in 2012, but I found myself needing to install the SQL 2008 R2 client tools on a Windows XP client machine. I am at a client that is still running Windows XP and installing SQL 2012 is not an option. They have a base image and when I went to install the client tools, I got the following error:
TITLE: SQL Server Setup failure.
SQL Server Setup has encountered the following error:
I came across this article in the MSDN forms. I will let you follow the steps in the article, but I had the following experience:
- After I deleted the registry key, I tried to reinstall–no go–I got an error about a missing registry key. Seems strange; I mean who just deletes registry keys? Even tried rebooting, cause its Windows XP.
- I reinstalled Microsoft SQL Server Compact 3.5 SP2 and uninstalled it.
- SQL 2008 R2 client tools installed no problem.