Silent SQL Server 2005 Installation is possible in two steps.
1) Creating an .ini file
The SQL Server CD contains a template file called template.ini . Based on that create another required .ini file which includes a single [Options] section containing multiple parameters, each relating to a different feature or configuration setting.
2) Run Setup on command prompt
On command prompt type following script
setup.exe /settings <path TO .ini FILE>
If location of sqlinstall.ini file is at C:\SQLSetup folder. The command to initiate silent installation is:
setup.exe /settings C:SQLSetup sqlinstall.ini
Specify the /qn switch to perform a silent installation (with no dialog boxes) or the /qb switch to specify that only progress dialog boxes should be displayed.
Reference : Pinal Dave (http://blog.SQLAuthority.com)
pinaldave
Hi!
Could you help me please?
I’m building a setup for my application that requires SQL Server Express Edition installed …
So, before I start copying files, I launching the executable for the installation of SQL Server from an INI file in silent mode (/qn parameter).
My question is: how do I know automatically when the SQL Server installation is ended successfully or not?
Are there some return values on which I can rely?
Thanks
Mark
Mark
Hi
If I would like to install SQL Server 2005 Express as a prerequisites with my application which is created using VS 2008, How can I set the above parameters?
thanks
Khayralla
Hi ,
I am trying to install SQL SERVER 2005 in silent mode.
While proceeding after completion of 1st CD, I got “Insert CD 2″ message box.
I inserted the 2nd CD; but still am getting the “Insert CD 2″ message box.
Please give me your inputs
Regards,
Palani
Hi Palanivel Rajan
The alternative method is ,copy two cds in to hard disk and try
definatly it will come
Regards
Ravishankar Chinnur
Hi Palanivel Rajan
But my question is how can we hide all ui screens in sql server
2005.i.e., it should not display any set up windows while installing
Thanks a lot
Ravishankar Chinnur
To hide all setup dialogs use the /qn switch instead of the /qb switch.
Hello,
Do you have any idea why a SQL Server security patch continues to attempt to install itself even when auto-update is disabled? KB959195 has attemped to install and failed every night around midnight, breaking my cluster and leaving SQL Server resources in a failed state. What in the world is it that Windows or SQL Server is ‘looking’ at that kicks off an unattended patch install like this?
How can I ensure the that auto-update leaves my SQL Server patches alone?
I’d appreciate any insight. Thanks!
Cindy
I note all examples specify the full path (including drive letter) of the .ini file.
I want to install from a CD, or USB memory stick, and do not know what the drive letter will be on the target machines.
If I only use a relative path, the installer looks for the ini file in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\ and of course it is not there.
How can I use a relative path to the .ini file?
Hello,
i try to create my own sql server 2005 express installation with SSME.ini as below, but my Mixed Mode Dialog Box Password Still Blank.
Did anyone can help me
[Options]
USERNAME=ABC => Status Ok
COMPANYNAME=XYZ => Status Ok
ADDLOCAL=ALL => Status Ok
INSTANCENAME=SQLEXPRESS => Status Ok
SECURITYMODE=SQL => Status Ok
*****************************************
SAPWD=sql => Status Ng
Why Mixed Mode Dialog Password Still Blank ??
Did i miss some Setting ??
*****************************************
SQLBROWSERAUTOSTART=1 => Status Ok
DISABLENETWORKPROTOCOLS=0 => Status Ok
Hi David!
Try this:
copy setup.ini %TEMP%\setup.ini
setup.exe /settings %TEMP%\setup.ini /qb