I am having installer problems on several machines trying to install SQL Server Express 2005 Express as well as later versions (but I would be happy with 2005 anyway). However, I do have one machine where it runs fine. So, is there a way to clone the installation by copy-pasting the files and then doing some magic to make it work? So far when I put the folder into another XP Pro machine and tried launch ssmsee.exe, it didn't start - command executed in cmd quietly and nothing happened.

Is this approach in fact doable with some relevant fixes? Or is the installer the only way?

  • I would imagine the installer sets registry settings, which you wouldn't get if you copied and pasted the binary files and libraries and executables. There's probably a way to copy registry settings to, but I'm not certain about that. – FrustratedWithFormsDesigner Mar 9 '12 at 16:17
  • Might this be a better question for the serverfault site? You can script SQL Server installation, but it doesn't sound like that's what you're looking for, reg cloning and such. – Eric Higgins Mar 9 '12 at 16:24
  • 1
    No, you cannot copy an existing installation. Installer is the only way. – Remus Rusanu Mar 9 '12 at 16:28

No, you need to go through the installer to get SQL Express working on the other machines.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.