SQL Server 2000 Administration in 15 Minutes a Week: Advanced Installations - Page 2
May 17, 2002
Click to Enlarge
Review the following link to learn about the different sections of the Installation Setup Initialization file (this is important for the exam): http://msdn.microsoft.com/library/en-us/instsql/in_runsetup_6nz9.asp
Once you have created your custom Installation Setup Initialization file you need a way to initiate the installation. You can initiate the installation by entering the appropriate commands at the command prompt or by creating a batch file to start the installation.
Beginning an unattended installation from the command prompt is not a big deal if you only have a few systems, located locally, that you need to install SQL Server on. Imagine if you needed to install the client tools on hundreds of workstations. To simplify that daunting task we can use a batch file and SMS (Systems Management Server - http://msdn.microsoft.com/library/en-us/instsql/in_runsetup_43eb.asp) to install SQL Server 2000 without having to visit every computer. You can also use a batch file if the task of installing SQL server will be done by someone who has very little knowledge of the network or SQL Server. For more information on batch files look at the examples provided with SQL Server.
No matter which way you choose to start the Unattended Installation, both methods run setupsql.exe located in the \x86\setup directory of your SQL Server CD (ex: D:\x86\setup\setupsql.exe). You can then use command-line parameters to specify how setup should run.
The table below shows you the command line parameters available with setupsql.exe:
After you have selected the system you would like to install SQL Server on, click Next.
Not a lot of options on the next screen:
Select "Create a new instance of SQL Server, or install Client Tools" and click Next
The next Setup screen is unique to the Remote Installation. This screen prompts for the account and path information that will be used to install the SQL Server. The account you choose should have Administrative privileges on the remote system. An important thing to note is the account you enter on this screen is only used during the installation and has nothing to do with the Services or Logon accounts of SQL Server.
The Target Path you enter should be given in the Universal Naming Convention form. In this example I am installing the files on the "C" drive of SQL2. The Setup Source Files textbox specifies the location of the SQL Setup files. In this example the files are located on the server named CDSRV and are located in the SQL_ENT share.
Enter the appropriate information and click Next.
From this point on the Remote Installation will prompt you for the Installation Type, Service Accounts, Authentication mode, Collation, etc. (just like a basic installation). Once Setup has all the information it needs, it will then begin an Unattended Installation on the remote system automatically.