[Options] USERNAME="Guest Manager" COMPANYNAME="RoseStreet Systems" ;-------------------------------------------------------------------- ; INSTALLSQLDIR specifies the location for the instance specific binary files. ; Default location is: %ProgramFiles%\Microsoft SQL Server\ ; To use the default path, do not specify the following parameter. INSTALLSQLDIR= ;-------------------------------------------------------------------- ; INSTALLSQLSHAREDDIR specifies a custom location for Integration Services ; Notification Services, Client Components, SQL Server Books Online and Samples. ; To use the default path, do not specify the following parameter. Default path is %ProgramFiles%\Microsoft SQL Server\ INSTALLSQLSHAREDDIR= ;-------------------------------------------------------------------- ; INSTALLSQLDATADIR specifies the location for the SQL Server data files. ; Default: INSTALLSQLDIR\Data\ ; To use the default path, do not specify the following parameter. INSTALLSQLDATADIR= ;-------------------------------------------------------------------- ; ADDLOCAL specifies which components to install. If ADDLOCAL is not ; specified, setup will fail. ; To install all components specify 'ADDLOCAL=ALL' on the command line. ADDLOCAL=SQL_Engine ;-------------------------------------------------------------------- ; INSTANCENAME is REQUIRED; for a default instance use MSSQLSERVER ; For shared components (IS, NS and client components) INSTANCENAME is not required. INSTANCENAME=GM ;-------------------------------------------------------------------- ; The services for SQL Server and Analysis Server are set auto start. To use the *ACCOUNT settings ; make sure to specify the DOMAIN, e.g. SQLACCOUNT=DOMAINNAME\ACCOUNT ; NOTE: When installing SQL_Engine 3 accounts are REQUIRED: SQLACCOUNT, AGTACCOUNT and SQLBROWSERACCOUNT. SQLACCOUNT="NT AUTHORITY\SYSTEM" ;-------------------------------------------------------------------- ; To use the *AUTOSTART features, specify 1 to start automatically or 0 to start manually. ; NOTE: If you decide to start SQL Agent automatically, then SQL is also started automatically. ; If *AUTOSTART is not specified on the command line, startup is set to manual. SQLBROWSERAUTOSTART=1 SQLAUTOSTART=1 AGTAUTOSTART=0 ;-------------------------------------------------------------------- ; To use Mixed mode authentication, use SECURITYMODE=SQL. ; If SECURITYMODE=SQL is not specified, then Windows Authentication only will be used by default. ; If you use SQL Authentication, you are REQUIRED to provide a strong system administrator (SA) password. ; If you use Windows Authentication, the SA account will be disabled. ; To set SA password specify SAPWD. SECURITYMODE=SQL SAPWD=rose123 ;-------------------------------------------------------------------- ; The DISABLENETWORKPROTOCOLS switch is used to disable network protocol for SQL Server instance. ; Set DISABLENETWORKPROTOCOLS = 0; for Shared Memory= On, Named Pipe= On, TCP= On ; Set DISABLENETWORKPROTOCOLS = 1; for Shared Memory= On, Named Pipe= Off (Local Only), TCP= Off ; Set DISABLENETWORKPROTOCOLS = 2; for Shared Memory= On, Named Pipe= Off (Local Only), TCP= On ; Note: DISABLENETWORKPROTOCOLS if not specified has the following defaults. ; Default value for SQL Server Express/Evaluation/Developer: DISABLENETWORKPROTOCOLS =1 ; Default value for Enterprise/Standard /Workgroup: DISABLENETWORKPROTOCOLS =2 DISABLENETWORKPROTOCOLS=0 ;-------------------------------------------------------------------- ; The ENABLERANU switch is used to configure Run as Normal User (User Instances). ; Set ENABLERANU = 0 to turn User Instances off. ; Set ENABLERANU = 1 (default) to turn User Instances on. ; Note: User Instances only apply to SQL Server Express SKUs. ENABLERANU=0 ;-------------------------------------------------------------------- ; The ADDUSERASADMIN switch is used to add the setup user to the ; SQL Server 2005 System Administrator role. Members of the ; System Administrator role can perform any activity in the server. ; Set ADDUSERASADMIN=1 to add the setup user to the SQL Server System Administrator role ADDUSERASADMIN=0