Launch the installation in unattended mode
- Copy the sources in a local folder. Let’s say D:\Sources\SQL2K8\
- Create a file called sql2k8install.ini in the D:\Sources\SQL2K8\ folder. This file will contain described in the chapter C dans le chapitre Sql2k8install.ini file content
- In the Start menu, right click on Command, and click on Run as administrator
- Enter the right commands to reach the sources folder (D:\ then CD Sources)
- Enter the following command : start /wait setup.exe /configurationfile=Sql2k8install.ini /IACCEPTSQLSERVERLICENSETERMS /SAPWD=”Password”
Sql2k8install.ini file content
;SQLSERVER2008 Configuration File [SQLSERVER2008] ;----------------------------------------- ; -- Set the following parameters ;----------------------------------------- INSTANCEID="InstanceName" INSTANCENAME="InstanceName" SQLCOLLATION="FRENCH_CI_AS" FEATURES=SQLENGINE,REPLICATION,FULLTEXT,CONN,BC SQLSVCACCOUNT="Domain\User" SQLSVCPASSWORD="xxxxx" SQLSVCSTARTUPTYPE="Automatic" AGTSVCACCOUNT="Domain\User" AGTSVCPASSWORD="xxxxx" AGTSVCSTARTUPTYPE="Automatic" BROWSERSVCSTARTUPTYPE="Automatic" ; Directories INSTANCEDIR="E:\APPLI\SQL2K8" INSTALLSQLDATADIR="E:\APPLI\SQL2K8" SQLUSERDBDIR="E:\APPLI\SQL2K8" SQLUSERDBLOGDIR="F:\APPLI\SQL2K8" SQLSYSADMINACCOUNTS="Domain\Group" ;----------------------------------------- ; -- Touch carefully ;----------------------------------------- ACTION="Install" ;UIMODE="Normal" QUIETSIMPLE="True" ERRORREPORTING="False" INSTALLSHAREDDIR="C:\Program Files\Microsoft SQL Server" INSTALLSHAREDWOWDIR="C:\Program Files (x86)\Microsoft SQL Server" SECURITYMODE="SQL" ;----------------------------------------- ; -- OPTIONS ;----------------------------------------- ; 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="False" ; Startup type for Integration Services. ;ISSVCSTARTUPTYPE="Automatic" ; Account for Integration Services: Domain\User or system account. ;ISSVCACCOUNT="NT AUTHORITY\NetworkService" ; Controls the service startup type setting after the service has been created. ;ASSVCSTARTUPTYPE="Automatic" ; The collation to be used by Analysis Services. ;ASCOLLATION="FRENCH_CI_AS" ; The location for the Analysis Services data files. ;ASDATADIR="Data" ; The location for the Analysis Services log files. ;ASLOGDIR="Log" ; The location for the Analysis Services backup files. ;ASBACKUPDIR="Backup" ; The location for the Analysis Services temporary files. ;ASTEMPDIR="Temp" ; The location for the Analysis Services configuration files. ;ASCONFIGDIR="Config" ; Specifies whether or not the MSOLAP provider is allowed to run in process. ;ASPROVIDERMSOLAP="1" ; Level to enable FILESTREAM feature at (0, 1, 2 or 3). ;FILESTREAMLEVEL="0" ; Specify 0 to disable or 1 to enable the TCP/IP protocol. ;TCPENABLED="1" ; Specify 0 to disable or 1 to enable the Named Pipes protocol. ;NPENABLED="0" ; Specifies how the startup mode of the report server NT service. When ;Manual - Service startup is manual mode (default). ;Automatic - Service startup is automatic mode. ;Disabled - Service is disabled ;RSSVCSTARTUPTYPE="Automatic" ; Specifies which mode report server is installed in. ;Default value: “FilesOnly” ;RSINSTALLMODE="FilesOnlyMode" ; Add description of input argument FTSVCACCOUNT ;FTSVCACCOUNT="NT AUTHORITY\LOCAL SERVICE" ;OPTIONS Description ;SQLENGINE : Sql Engine ;REPLICATION : Replication components ;FULLTEXT : Fulltext component ;SQL : Sql Engine + Replication components + Fulltext component ;AS : Analysis Services ;RS : Reporting Services ;IS : integration Services ;BC : Backward compatibility ;BOL : Book on Line ;BIDS : Business Intelligence Development Studio ;CONN : Connectivity ;SSMS : SQL Server Management Studio ;ADV_SSMS : SQL Server Management Studio + Analysis Services + Reporting Services + integration Services + Profiler + Tuning Advisor + Utility Management ;SDK : Software Developer Kit ;TOOLS : BC+BOL+BIDS+CONN+ADV_SSMS+SDK