You can perform an unattended installation using SQL Server Setup to install Microsoft® SQL Server™ without having to respond to prompts. Instead, the Setup program reads the installation settings from a setup initialization file. An unattended setup can be convenient if you want to install several instances of SQL Server with identical configurations. You can also use Microsoft Systems Management Server (SMS) to perform unattended installations on multiple Microsoft Windows NT® Servers in your enterprise.
For installing SQL Server, the SQL Server compact disc contains two setup initialization files. The compact disc also includes two command files that detect the platform of the computer and run the appropriate version of the Setup program with a corresponding initialization file.
For removing SQL Server, the SQL Server compact disc contains an executable file that removes SQL Server.
Batch file | Initialization file | Action |
---|---|---|
sql70cli.bat | sql70cli.iss | Installs the SQL Server management tools |
sql70ins.bat | sql70ins.iss | Installs a typical installation of SQL Server1 |
sql70cst.bat | sql70cst.iss | Installs a custom installation of SQL Server1,2 |
sql70rem.bat | Removes SQL Server | |
1 These files assign the SQL Server services to the local system account. If you want the unattended installation to assign domain user accounts, create a custom setup initialization file.
2 Installs all SQL Server components. |
You can also create custom setup initialization files to automate any set of installation options.
To run an unattended installation