Microsoft SQL Server 2008 R2 Unleashed- P27:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 214 CHAPTER 8 Installing SQL Server 2008 Specify if errors can be reported to Microsoft to improve future SQL Server releases. Specify 1 or True to enable and 0 or False to disable this feature. ERRORREPORTING True Specify the root installation directory for native shared components. INSTALLSHAREDDIR C Program Files Microsoft SQL Server Specify the installation directory. INSTANCEDIR C SQL2008R2 Specify that SQL Server feature usage data can be collected and sent to Microsoft. Specify 1 or True to enable and 0 or False to disable this feature. SQMREPORTING True Specify a default or named instance. MSSQLSERVER is the default instance for non-Express editions and SQLExpress for Express editions. This parameter is required when installing the SQL Server Database Engine SQL Analysis Services AS or Reporting Services RS . INSTANCENAME MSSQLSERVER Agent account name AGTSVCACCOUNT SQLADMIN Auto-start service after installation. AGTSVCSTARTUPTYPE Automatic Startup type for Integration Services. ISSVCSTARTUPTYPE Automatic Account for Integration Services Domain User or system account. ISSVCACCOUNT SQLADMIN Startup type for the SQL Server service. SQLSVCSTARTUPTYPE Automatic Level to enable FILESTREAM feature at 0 1 2 or 3 . FILESTREAMLEVEL 1 Specifies a Windows collation or an SQL collation to use for the Database Engine. SQLCOLLATION SQL_Latin1_General_CP1_CI_AS Account for SQL Server service Domain User or system account. SQLSVCACCOUNT SQLADMIN Download from Installing SQL Server Using a Configuration File 215 Windows account s to provision as SQL Server system administrators. SQLSYSADMINACCOUNTS SQLADMIN The default is Windows Authentication. Use SQL for Mixed Mode Authentication. SECURITYMODE SQL The Database Engine root data directory. INSTALLSQLDATADIR C SQL2008R2 Default directory for the Database Engine backup files. SQLBACKUPDIR C SQL2008R2 MSSQL Backup Default directory for the Database Engine user databases. SQLUSERDBDIR C
