Monday, December 5, 2011

Enable FILESTREAM during SQL Express 2008 R2 Unattended Setup

A previous post about unattended setup explained about how to install SQL Server Express 2008 R2 in unattended mode. This post explains how to enable FILESTREAM by adding some additional parameters to it. FILESTREAM can be enabled either during SQL installation or by using SQL Configuration Manager after installtion. (And it can also be enabled by using SQL WMI provider. So all kinds of method using SQL WMI such as Powershell, C#, VBscript can be also used for that purpose.)
In order to enable FILESTREAM during SQL setup, both FILESTREAMLEVEL and FILESTREAMSHARENAME should be specified.

C> SETUP.exe /ACTION=Install /INSTANCENAME=SQLExpress
/FEATURES=SQLENGINE /QS /IACCEPTSQLSERVERLICENSETERMS=true
/SQLSVCSTARTUPTYPE=Automatic /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM"
/BROWSERSVCSTARTUPTYPE=Disabled /ADDCURRENTUSERASSQLADMIN=true
/TCPENABLED=1 /HIDECONSOLE
/FILESTREAMLEVEL=3 /FILESTREAMSHARENAME=SQLEXPRESS


The command above installs SQL Server Engine only in silent mode and named instance (.\SQLExpress) will be created. It enables FILESTREAM with full access level.

No comments:

Post a Comment