SQL 2008 R2 Advanced Setup Feature - Sysprep

hi,

we going deploy bunch of windows embedded 7 standard operating systems. wes7 images generalized using sysprep.

i understand running sysprep on operating system sql installed cause trouble. i'm going use sql 2008 r2 advanced install feature called "image preperation of stand-alone sql server".

this way able configure sql when wes7 images deployed onto hardware using advanced setup feature "image completion of prepared stand-alone instance of sql server".

configuring prepared sql instance manually time consuming considering going roll out 10 20 systems every day. there way run both advanced setup features mentioned above automatically?

any advise appreciated!

hi sebastian,

if want install sql server 2008 r2 automatically, try use command prompt.

when installing through command prompt, sql server supports full quiet mode using /q parameter, or quiet simple mode using /qs parameter. /qs switch shows progress, not accept input, , displays no error messages if encountered. /qs parameter supported when /action=install specified.

install sql server 2008 r2 using sysprep: http://msdn.microsoft.com/en-us/library/ee210664(v=sql.105).aspx.

how install sql server 2008 r2 command prompt:  http://msdn.microsoft.com/en-us/library/ms144259(v=sql.105).aspx.

thanks,
maggie

---

please remember mark replies answers if , unmark them if provide no help. can beneficial other community members reading thread.

SQL Server  >  SQL Server Setup & Upgrade