SQL Express silence installation on IS Profession

[jrahma]

I want to knowhow can i do the following on IS 2009 Professional:

Install SQL Server 2005 Express with the following:
[LIST=1]

Silence Installation

Forece JASSIMSRV as instance name

Forece WHATWHEN as database name

[AaronM]

This can be done by editing the existing Microsoft SQL Server 2005 Express SP2 prerequisite and specify additional command arguments to SQLEXPR32.exe which is under the "Application to Run" tab when editing a pre-requisite. I would suggest you then save as a new file and name it accordingly. For instance: "Microsoft SQL Server 2005 Express SP2 (MyInstanceName Instance)"

Example arguments:
/qn INSTANCENAME=MyInstanceName ADDLOCAL=All SQLACCOUNT="NT AUTHORITY\SYSTEM" SQLACCOUNT="NT AUTHORITY\NETWORK SERVICE" SQLACCOUNT="NT AUTHORITY\LOCAL SERVICE" AGTACCOUNT="NT AUTHORITY\LOCAL SERVICE" SQLBROWSERACCOUNT="NT AUTHORITY\LOCAL SERVICE"

The "/qn" argument denotes silent install and the "INSTANCENAME" argument allows you to specify your instance name. The full command line arguments are documented in MSDN and/or SQL Server's help.

[AaronM]

The database name would be done in your SQL script code of creating the database. It is separate from the task of creating the SQL Server instance.

[AaronM]

You may also find this article helpful as it explains additional options.

How to: Install SQL Server 2005 from the Command Prompt
http://msdn.microsoft.com/en-us/library/ms144259.aspx