Home > File Table > Enabling FileTable Prerequisite

Enabling FileTable Prerequisite

The FileTable feature builds on top of SQL Server FILESTREAM technology

Enabling the Prerequisites for FileTable

To enable the prerequisites for creating and using FileTables, enable the following items:

  • At the instance level:

    • Enable FILESTREAM at the Instance Level

      • Enable using PowerShell

        # Enable FILESTREAM CLS $instance = "MSSQLSERVER" $wmi = Get-WmiObject -Namespace "root\Microsoft\SqlServer\ComputerManagement11"-Class FilestreamSettings | where {$_.InstanceName -eq $instance} $wmi.EnableFilestream(3, $instance)

        • Restart SQL Server Services
      • Enable using Configuration Manager

        FILESTREAM Enabled

      • Enable using Registry Key

        By default [EnableLevl] is set to 0, change it to 3 and restart the SQL Server Services.SQL Server Services will create the Share Name by itself.

        image

        Connect to SQL Server instance from SQL Server Management Studio and Enable FILESTREAM for file I/O streaming access

        image

        OR

        sp_configure ‘filestream access level’,2

        reconfigure with override

  • At the database level:

Administrative Considerations

About FILESTREAM and FileTables

  • You configure FileTables separately from FILESTREAM. Therefore you can continue to use the FILESTREAM feature without enabling non-transactional access or creating FileTables.

  • There is no non-transactional access to FILESTREAM data except through FileTables. Therefore, when you enable non-transactional access, the behavior of existing FILESTREAM columns and applications is not affected.

About FileTables and non-transactional access

  • You can enable or disable non-transactional access at the database level.

  • You can configure or fine-tune non-transactional access at the database level by turning it off, or by enabling read only or full read/write access.

Categories: File Table
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: