MOSS Command Line Installation Round Up

I apologise for not getting this done earlier. This is the index of all the posts I did to install MOSS from command line. I am planning to create a pdf document for this, not this week though. If you are a SharePoint blogger and would like to advertise in the pdf, please contact me. I have learnt a lot along the way and this method is just indicative of how you can use command line to install and configure SQL and MOSS. I have used these in testing, development and production environments with modifications as needed. For our project requirements I had to find this kind of solution! I could not imagine installing 1300 standalone MOSS instances manually!

Unattended SQL Server 2005 Installation

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

How to enable SQL Browser Service using a script

This is sixth in the series – MOSS Scripted Installation.

Up until this post we have covered

The last one was a manual step. In this post, let’s see how we can script this.

Configuring SQL Area Configuration to allow remote connections

In my situation I configured SAC and exported the configuration, because I am going to be deploying nearly 1300 sites and it’s gotta be scripted.

Howto configure sql express to allow remote connections

This is fifth in the series – MOSS Scripted Installation.

In previous posts, I wrote about pre-requisites and a brief overview on config.xml. Next we saw, how MOSS 2007 could be installed silently with SQL Server 2005 Express Edition.

It was a small step. This post is about allowing remote connections to SQL Server 2005 Express Edition. If you ever need to move sql database, attach pre-configured database or detach existing database, you will need to enable remote connections in sql server 205 express edition. It is disabled by default.

You can do this using SQL Server Area Configuration.

Script to install MOSS with SQL Express

This is fourth in the series – MOSS Scripted Installation.

In previous posts, I wrote about pre-requisites and a brief overview on config.xml.

Now let’s get down to real business.

All installation files will be in C:\Build\Packages\MOSS

  1. Create C:\Build\Packages\MOSS folder structure
  2. Copy Microsoft SharePoint Server 2007 installation files in C:\Build\Packages\MOSS\Server12
  3. Copy SQL Server files to C:\Build\Packages\MOSS\SQLExpress
  4. Create C:\Build\Packages\MOSS\Scripts
  5. Copy Config.xml from C:\Build\Packages\MOSS\Server12\Files\SetupSilent\ to C:\Build\Packages\MOSS\Server12\
  6. Edit this config.xml and replace with your MOSS product key. Leave the rest as is.

Launch the setup (assumption is made that you have already installed .net3 framework)