title: create a file system group pointing at a SAN
body: <p>I am working with creating a FileTable in sql server 2012. I want to store the files on a SAN (Storage Area Network). I have mapped it to a drive on sql server.</p>
  
  <p>To use the FileTable, I need to set up a file system group. I am using the following script but failing to get it correct:</p>
  
  <pre><code>ALTER DATABASE [MyDatabase]
  ADD FILE 
  (
      NAME = FileStreamFile,
      FILENAME= '\\123.456.789.001\MyFolder',
      MAXSIZE = UNLIMITED
      )
  TO FileGroup MyFileStreamGroup
  END
  </code></pre>
  
  <p>The entry I have for the FileName always seems to fail. How can I set up a FileStreamGroup to point at SAN and which in turn I will use to create a file table from it?</p>