We recently encountered an issue with SQL Server 2008 R2 failing to run after the upgrade from Windows XP Pro SP2 to SP3.
This was tested and reproduced (with varying results) on more than one computer.
Steps to reproduce this.
On a Windows XP Pro machine with Service Pack 2 installed, install SQL Server 2008 R2.
Next upgrade Windows to Service Pack 3.
Now upon opening SSMS or trying to start the SQL server service you receive the following message:
"This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem".
In some instances reinstalling/repairing SQL Server 2008 R2 does fix the issue. In other cases the installer crashes and you need to use msizap to clean it up before you can reinstall. In other cases you do not receive any errors at all.
After testing in multiple virtual machines it looks like the cleaner the Windows install the more likely you are to run into this issue. On machines with most or all windows updates (prior to SP3) installed you do not necessarily even get the failure.
On machines with just Windows XP Pro SP2 installed with no additional updates you get the failure every time.
Obviously the SQL Server 2008 R2 prerequisites are installed in all cases in order to be able to install SQL server to begin with.
Any help with this would be appre
View Complete Post