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
Post a Comment