Using the PDF File to Install Microsoft SQL Server

    To install SQL Server by using the PDF file
  1. Copy all directories and files from the Microsoft SQL Server CD-ROM to a package source directory.

    To create the package source directory for SQL Server, create the package source directory (for example, D:\SQL65, if you want to put the directory on the D: drive) on a server and share it with the same name (SQL65). Then copy the directories and files from the Microsoft SQL Server CD-ROM to the package source directory (you can use the xcopy command to copy the files).

  2. If you plan to install SQL Server on a drive letter other than C:, modify the drive specifications in the SMSSQL65.INI custom installation script. If you do not want to install SQL Server Books Online, change the Books Online value to 0 in the [New Options] section of the SMSSQL65.INI file.

    For information about the format of the installation script, see "Unattended Installation" in Microsoft SQL Server Setup.

  3. Using the SMS Administrator, create the package for SQL Server by importing SMSSQL65.PDF and specifying the SQL Server package source directory as the source directory for the package.
    To create a package source directory
  1. From the File menu, choose Open and select Packages.
  2. From the File menu, choose New.

    The Package Properties dialog box appears.

  3. Choose Import.
  4. Navigate to the package source directory (see the previous section).
  5. Select SMSSQL65.PDF and choose OK.

    The Package Properties dialog box now displays SQL Server 6.5 in the Name box.

  6. Choose Workstations.
  7. In the Source Directory box, specify the server and the sharename of the package source directory you created in step 1 (for example, \\myserver\sql65).
  8. Choose Close.
  9. Choose OK to close the Package Properties dialog box.

    The SQL Server package now appears in the Packages window. Use the SQL Server package to create Run Command on Workstation tasks to install SQL Server.

    Important Installation scripts must be used with the Package Command Manager client software. The installation scripts cannot be run by the Package Command Manager service.This means that you must leave the System Background Task option disabled in the Command Line Properties of the commands in the SQL Server package.

  10. Use a query to find the computers where you want to install SQL Server.

    To install SQL Server on drives other than drive C:, modify SMSSQL65.INI. We recommend that you create an SMSSQL65_drive.INI file for each target drive. Use a query to identify computers that have the customized SMSSQL65_drive.INI file and that have enough free disk space on those drives. You can also create queries that impose other requirements, such as amount of RAM or an existing SQL Server .

    For example, to find all Windows NT Server computers with enough free space on C: to fully install SQL Server and that are running Windows NT version 3.51 and greater, use the following query: 

    (
MICROSOFT|DISK|1.0:Disk Index is 'C'
AND
MICROSOFT|DISK|1.0:Free Storage (MByte) is greater than or equal 
        to '90'
)
AND
(
MICROSOFT|OPERATING_SYSTEM|1.0:Operating System Name is 
        'Microsoft Windows NT'
AND
MICROSOFT|OPERATING_SYSTEM|1.0:Version is same as or comes after 
        '3.51'
)

    After you run the query, you can add the selected computers from the query result to a machine group and then use the machine group to specify the target computers where you want to install SQL Server.

    You can also specify the query as a target. SMS will evaluate the query when it activates the job used to install the SQL Server package and will use that result as the list of target computers. For information about creating queries and machine groups, see the Microsoft Systems Management Server documentation.

  11. Using the SMS Administrator, create a Run Command on Workstation job to install SQL Server on a specified drive on specified SMS computers.
    To create a Run Command on Workstation job to install SQL Server
  1. From the File menu, choose Open and select Jobs. Or from the File menu, choose New.

    The Job Properties dialog box appears.

  2. Choose Details.
  3. For Job Target, specify the query or machine group you created in step 4.
  4. Select the Run Workstation Command check box.
  5. Select SMSSQL65.
  6. Choose OK, and choose OK again to close the Job Properties dialog box.

    When the job completes, SQL Server will be installed on all target computers on drive C: by default.