SQL SERVER FileTable/FILESTREAM share suddenly becomes unavailable
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 MySQL server, 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:
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? What is SQL Server FileTable?
SQL Server FILETABLE is a next generation feature of SQL FILESTREAM. We can use it to store unstructured objects into a hierarchal directory structure. SQL Server manages SQL FILETABLE using computed columns and interacts with the OS using extended functions. We can manage SQL FILETABLEs similar to a relational table. In your case, it appears that after setting it via configuration manager the issue went away.