507
Chapter 19: Confi guring SQL Server
19
■ (^) If you want to allow remote clients to access the FILESTREAM data stored on
this share, select the Allow Remote Clients to Have Streaming Access to the
FILESTREAM Data check box.
■ Click Apply.
After enabling FILESTREAM during setup or by using SQL Server Confi guration Manager, the
next step is to confi gure it in SQL Server using the FILESTREAM_access_level confi gu-
ration option. Following are the possible FILESTREAM access settings:
■ 0 : Disables FILESTREAM support for this SQL Server instance
■ (^1) : Enables FILESTREAM for Transact-SQL access only
■ 2 : Enables FILESTREAM for Transact-SQL and Win32 streaming access
The following example confi gures FILESTREAM for both Transact-SQL and Win32 streaming
access.
EXEC sp_configure 'filestream_access_level', 2;
RECONFIGURE;
Extensible Key Management
The Extensible Key Management (EKM) feature in SQL Server 2012 enables third-party EKM
and hardware security module vendors to register their devices in SQL Server. This capa-
bility makes it possible for DBAs to use third-party EKM products along with SQL Server’s
built-in encryption.
The EKM feature is available only on the Enterprise, Developer, and Evaluation edition of SQL Server 2012. Trying to
allow this option on other editions can result in an error. By default, the EKM feature is 0 (OFF) for all editions.
To turn the EKM feature ON in code, do the following:
EXEC sp_configure 'show advanced options', 1;
RECONFIGURE;
EXEC sp_configure 'EKM provider enabled', 1;
RECONFIGURE;
Default Full-Text Language
The default language for full-text index columns can be set using the
default full-text language confi guration option. Linguistic analysis of full-text
indexed data is dependent on the language of the data.
The default value for the default full-text language option is the language of the SQL Server instance.
Also, the default value set by this option applies only when no language is indicated in the CREATE or
ALTER FULLTEXT INDEX statement.
c19.indd 507c19.indd 507 7/30/2012 5:43:06 PM7/30/2012 5:43:06 PM
http://www.it-ebooks.info