1. If there is an existing MS SQL running, detach database and uninstall existing MS SQL.
  2. To uninstall, Control Panel > programs and feature > remove MS SQL
  3. Removing existing

  4. Once done, go back to Control Panel > programs and feature > remove MS SQL Native Client

  5. Once complete, run the MS SQL 2008 R2 Setup.exe
  6. Select New Installation or add features to an existing installation

  7. Next all the way until you reach "Feature Selection". Select following feature:

  8. Next All the way until you search "Server Configuration". Select SQL_Latin1_General_CP850_BIN2

  9. Next all the way until "Database Engine Configuration". Choose data root directory path where data files are stored.

  10. Next all the way and you are done.