Activate FileStream on SQL Server 2012 only with code (query) -


i'm desperately trying activate filestream queries. following msdn procedure ok, enable without using sql server configuration manager or sql server management studio.

on several website read query enough activate feature (this query done in msdn procedure after configuration in sql server configuration manager ) :

exec sp_configure 'filestream_access_level', 2; go reconfigure go 

the message l option de configuration filestream access level est passée de 2 à 2. pour installer, exécutez l'instruction reconfigure." gave if check service's proprieties filestream steal disabled, if execute reconfigure again. if try open connection base featuring filestream columns message confirming filestream not enabled.

i tried query :

use master go exec sp_configure 'show advanced options' go exec sp_configure filestream_access_level, 3 go exec sp_filestream_configure  @enable_level = 3 , @share_name = n'fs'; go reconfigure override go 

without succes, althougth sp_filestream_configure seems not exist.

this website tell issue default language of server, after change default language english nothing better. https://stackoverflow.com/questions/1...tream-access-l

i hope able me. thanks. sorry bad english, i'm french ;)

you have both. 1 enabling feature in configuration manager. other setting access level.

here's msdn guide walk through: https://msdn.microsoft.com/en-us/library/cc645923.aspx

you're doing step 11, need first 10 steps well.


Comments

Popular posts from this blog

Android : Making Listview full screen -

javascript - Parse JSON from the body of the POST -

javascript - Chrome Extension: Interacting with iframe embedded within popup -