How to enable FILESTREAM from the command line.
Tuesday, June 03, 2008
The FILESTREAM feature in SQL 2008 is off by default. It must be enabled by a box administrator either during instance setup or post-setup using the SQL Configuration Manager UI.
The VBScript below allows you to enable FILESTREAM for a particular instance post-setup from the command line. The caller must be box admin to run the script.
Also note, that once a box administrator has enabled the feature on the box, the SQL admin must connect to the instance and configure the feature using sp_configure.
More details are at:
Download the script by clicking on the Releases
tab, then clicking on EnableFilestream.zip.
Machine: Target machine name. If not specified, local machine is the default.
Instance: Target instance. If not specified, default instance (MSSQLSERVER) is default.
Level: Level of FILESTREAM functionality to enable, a integer between 0 and 3. If not specified, level 3 is default.
- FILESTREAM functionality disabled.
- Enable FILESTREAM for T-SQL access.
- Enable FILESTREAM for T-SQL and file I/O streaming access but do not allow remote clients file I/O streaming access.
- Enable FILESTREAM for T-SQL and file I/O streaming access and allow remote client streaming access.
Share: Name of windows share that is created for file I/O streaming access to FILESTREAM data. If not specified, instance name is default.
This will enable FILESTREAM on the local machine for the default instance MSSQLSERVER. The feature will be enabled for T-SQL and file I/O streaming access and the windows share MSSQLSERVER will be created.
cscript filestream_enable.vbs /Machine:. /Instance:SQLEXPRESS /Level:2 /Share:SQLEXPRESSLOCAL
This will enable FILESTREAM on the local machine for the instance SQLEXPRESS. The feature will be enabled for T-SQL and file/IO streaming access. Remote client file I/O streaming access is disabled. The windows share SQLEXPRESSLOCAL will be created.