Why SQL Server and Other Dev Environments Are So Hard to Install — A Few Suggestions

Sophomore year now, studying is more formal, slowly getting closer to being a programmer. Recently in the club, and in the dorm, I helped folks install dev environments, databases, etc. It made me sick installing them; I wonder if anyone shares the feeling. If you don’t, it means you haven’t installed on enough computers, haha.

Everyone has all sorts of operating systems, all versions, different environments, and errors of every kind — the only thing in common is install failure.

So why is it so hard to install?

  1. Installed before, related services already exist, causing errors
  2. The system is a stripped version — faster but missing required components
  3. The system has been used a long time, rogue software etc. messed up the registry
  4. The installer doesn’t match the OS — go to MSDN first to check the minimum requirements
  5. The installed version is too old, doesn’t support current CPU architecture — no choice, you can only install a newer version
  6. Security software blocks or identifies it as dangerous, deleting something in the installer — please turn off security software when installing

All sorts of reasons. What suggestions do I have? As follows:

Most effective method: Reinstall your OS, and definitely use the original MSDN image to install. Try not to use Ghost or stripped/modified versions by others. Then don’t install security software or entertainment software; in a clean environment:

  1. First install SQL Server database, then install Visual Studio
  2. Install other Microsoft software
  3. Install other dev tools
  4. Install your own stuff

This way, basically no problems. Also, if the OS is the latest, your dev tools should be the latest too. For example: Windows 8 OS, minimum supports SQL Server 2008 SP1, so don’t even think about older versions; if you must use old ones, you can only choose an old OS.

Everything goes by MSDN; MSDN is the bible, look it up more and it’ll go smoothly.

Start your development journey!