title: Is there an alternative of using a VBScript for enabling FileStream after SQL Server installation?
body: <p>To use Filestream on a DB 3 steps must be done:</p>
  
  <p>1) enable it a server/instance level</p>
  
  <p>2) enable it (<code>sp_configure</code>) at DB level</p>
  
  <p>3) create a <code>varbinary(max)</code> field that supports filestream</p>
  
  <p>(2) and (3) are done easily with T-SQL</p>
  
  <p>(1) is doable manually from SQL Server Configuration Manager, basically what I need is to check all the 3 checkboxes:</p>
  
  <p><a href="https://i.stack.imgur.com/4pqUs.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/4pqUs.jpg" alt="alt text"></a><br>
  <sub>(source: <a href="http://www.sql-server-performance.com/admin/article_images_new/2008_images/Configure_Filestream_in_SQL_Server_2008/Image2.jpg" rel="nofollow noreferrer">sql-server-performance.com</a>)</sub>  </p>
  
  <p>but how is it possible to automize it?</p>
  
  <p>I found this artcile <a href="https://archive.codeplex.com/?p=sqlsrvengine" rel="nofollow noreferrer">"Enabling filestream usin a VBScript"</a>, is there another way to do it than using VBScripts? May be something that is possible to do only with 2008R2?</p>
  
  <p>In case it VBScript is the only solution, which are the possible downsides?</p>