BUG: DocErr: Unattended Setup INI File in Books Online

• Microsoft SQL Server, version 6.0

SYMPTOMS

If you attempt an unattended setup using the sample .INI file from the Microsoft SQL Server Books Online as a template, it causes a 'Noncritical Error' saying:

   External library procedure GetPrivProfStr reported the following
   error

CAUSE

This is a documentation error. The unattended installation will work correctly using the .INI template below.

WORKAROUND

The following .INI file can be used as a template for creating an actual .INI file with these caveats:

- Use the following setup command (including any other necessary

  switches) to use a file named MYPC.INI for initialization. The
  capitalization of 'IniFilePath' and the spaces before and after
  the equal sign (=) must match the example; the drive letter, path, and
  filename are customizable:

     setup /t IniFilePath = e:\setini\mypc.ini

  A file containing the word 'go' is sufficient.

  line must still be present in the .INI file.

  treat the line as a comment.

  issue a 'Reboot Now' or 'Reboot Later' command.

  machine, dialog boxes will appear waiting for Registered Owner and
  Install/Upgrade confirmation before continuing with the installation. The
  unattended setup cannot be used for upgrading an existing server to
  version 6.0.

  will display a "Warning: Invalid Machine Name" dialog and wait for
  user input. As stated in SQL Server Books Online, "The server name used
  by SQL Server is taken from the computer's name. Before installing
  Microsoft SQL Server on a server computer, make sure that the server's
  computer name is a valid SQL identifier. The first character must be a
  letter or an underscore (_). Characters following the first character can
  include letters, numbers, or the symbols #, $, or _. No embedded spaces
  are allowed."

  the Service Control Manager issues a "#SCM3 - 1057" error. Verify
  the user has 'Log on as a service' user right, and that the domain
  (or machine name) with a backslash is used when specifying the user.

[License]

  FullName=Royce Aydel
  OrgName=CLXD5 Corporation
  ProductID=AB1234567
  Mode=0
  PerServerUsers=50

  SQLPath=\SQL60
  LogicalSQLDrive=D:

  MasterSize=30
  LogicalDBDrive=D:
  MasterDBPath=\SQL60\DATA
  MasterDBFileName=MASTER.DAT

  AutoServerService=CHECKED
  AutoExecutiveService=CHECKED
  BooksOnline=1

  CharSet=cpISO

  SortFileName=nocase.iso
  SortConfigValue=52

  NetLibList={"SSNMPN60","SSMSRP60"}
  ServerNMPipe=\\.\pipe\sql\query
  MultiProtEncrypt=NOTCHECKED

  LocalSystem=NOTCHECKED
  Username=ExecService
  UserPassword=ABC1234

  CustScPath=C:\TEMP
  CustomScriptList={"script1.sql","script2.sql","script3.sql"}

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.0. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

There are three errors in the SQL Server Books Online, SQL Server Setup, Appendix B, "A Sample Setup Initialization File" section. These were found by comparing the GetPrivProfStr calls in Setup.INF with the sample file. (NOTE: The August 1995 TechNet CD is more out of date than the Books Online.)

   Password=ABC1234        should be  UserPassword=ABC1234
   CustomScPath=C:\TEMP    should be   CustScPath=C:\TEMP
   CustScriptList={ ... }  should be  CustomScriptList={ ... }

There are three additional errors in this Books Online section that might cause problems:

- In the Books Online section [Charset] (which should be [CharSet]),

  the entry 'cp 850' should be 'cp850' (no space).

  be 'OrgName' (uppercase 'N').

  the table at the bottom of the page has 'SSMSS060' for TCPIPSockets;
  this should be 'SSMSSO60' (the first zero should be the letter 'O').