Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question
    
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
add comment

1 Answer 1

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

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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