Installing SQL Server 2005 Service Pack Silently

Switch
Description

/?
Displays unattended installation command prompt help.

/allinstances
Applies SQL Server 2005 SP3 to all instances of SQL Server 2005 and to all SQL Server 2005 shared, instance-unaware components.

/instancename=InstanceName
Applies SQL Server 2005 SP3 to an instance of SQL Server 2005 named InstanceName, and to all SQL Server 2005 shared, instance-unaware components.

/password=Password
User account password for connecting to a remote failover cluster node.

/quiet
Runs SQL Server 2005 SP3 Setup in unattended mode.

/reportonly
Only the discovery and enumeration section of Setup is run, and a report enumerating the local instances and components of SQL Server 2005 is displayed.

Note:
When using this switch, SQL Server 2005 SP3 is not applied.

/rsupgradedatabaseaccount=rsAccountName
Specifies an account that has permissions to modify the schema on a report server database when you use SQL Server Authentication. This parameter is used when you upgrade an instance of Reporting Services that includes a report server database that requires a SQL Server login.

/rsupgradepassword=rsPassword
Specifies the password for an account that has permissions to modify the schema on a remote report server database. This parameter is used when you upgrade an instance of Reporting Services that includes a remote report server database.

/rsupgradedatabase
Use the switch /rsupgradedatabase=0 to prevent the Reporting Services database from being upgraded

/sapwd=SaLoginPassword
Passes the SQL Server Authentication password for the sa login to run scripts.

Note:
Do not escape characters for /sapwd. Escaping characters will cause Setup to fail.

/user=Domain\UserName
User account for connecting to a remote failover cluster node.