Alpesh Nakar – SharePoint Consultant's Blog

This is Part 2 of the 100% Scripted MOSS Installation. In Part 1 of the series, MOSS was installed on SQL SERVER 2005 Express edition. In this series, we will install SQL SERVER 2005 Enterprise Edition using a script, followed with a recap of installation of MOSS and then configuring MOSS using scripts. This will be a shorter journey, since we have seen various permutations in the earlier series.

I have used the instructions from MSDN to configure and install SQL Server 2005 Enterprise Edition.

start /wait C:\BUILD\Packages\MOSS\SQL2005\Servers\setup.exe /qb ADDLOCAL=Client_Components,Connectivity,SQL_Documentation,SQL_Tools90

start /wait C:\BUILD\Packages\MOSS\SQL2005\Servers\setup.exe /qb INSTANCENAME=MOSS2007 ADDLOCAL=SQL_Engine SAPWD=password SQLACCOUNT=domain\sqlserviceaccount SQLPASSWORD=password AGTACCOUNT=domain\sqlserviceaccount AGTPASSWORD=password SQLBROWSERACCOUNT=domain\sqlserviceaccount SQLBROWSERPASSWORD=password SECURITYMODE=SQL

As in earlier series, application installation packages are in

C:\Build\Packages\MOSS\ and copy your SQL SERVER 2005 CD to

C:\Build\Packages\MOSS\SQL2005\

Then apply Service Packs

start /wait C:\BUILD\Packages\MOSS\SQLSERVER2005SP1-KB913090-x86-ENU.exe /allinstances /quiet

start /wait C:\BUILD\Packages\MOSS\SQLSERVER2005SP2-KB921896-x86-ENU.exe /allinstances /quiet

/allinstances /quiet applies service pack to all instances quietly

You can download the scripts from my sky drive

For further customized options you can refer to MSDN Article here.

Next recap of MOSS Installation.