Sample Header Ad - 728x90

SQL SERVER FileTable/FILESTREAM share suddenly becomes unavailable

3 votes
2 answers
3695 views
We had difficulty setting up a FileTable share on a SQL 2014 instance and after giving up on trying to name it after our instance name, we left the name of the share as mssqlserver, but it finally came online, online meaning if you right click in SSMS on the FileTable table you can "Explore FileTable Directory", however it seems to randomly go offline again after some time and you receive the usual canned error message: ![](https://raresql.files.wordpress.com/2014/02/file-location-cannot-be-opened-1-1.png) So, after magically disabling/enabling FILESTREAM at the server level, database level via t-sql/ssms/configuration manager it some how comes back, but I have to mess with the setting at all of those spots for it to come back! and there seems to be no magical sequence of steps that makes it come back. Has anyone out there experienced this? Will a restart of the service/server help this? If not, will a repair of sql server help?
Asked by Eric Swiggum (694 rep)
Mar 3, 2017, 02:36 PM
Last activity: Apr 25, 2022, 04:29 PM