PDA

View Full Version : SQL Express silence installation on IS Profession



jrahma
07-30-2008, 03:51 PM
I want to knowhow can i do the following on IS 2009 Professional:

Install SQL Server 2005 Express with the following:

Silence Installation
Forece JASSIMSRV as instance name
Forece WHATWHEN as database name

AaronM
07-30-2008, 08:02 PM
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
07-30-2008, 08:05 PM
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
07-30-2008, 08:13 PM
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