CostOS Server installer usually can perform these steps but if you have different machines hosting SQL Server and CostOS database or not enough privileges for SQL assigned user, the following steps have to be done instead.
On the Start menu, point to All Programs, point to SQL Server 2014, point to Configuration Tools, and then click SQL Server Configuration Manager (if you cant find it just search for SQLServerManager12.msc).
- In the list of services, right-click SQL Server Services, and then click Open.
- In the SQL Server Configuration Manager snap-in, locate the instance of SQL Server on which you want to enable FILESTREAM.
- Right-click the instance, and then click Properties.
- In the SQL Server Properties dialog box, click the FILESTREAM tab.
- Select the Enable FILESTREAM for Transact-SQL access check box.
- If you want to read and write FILESTREAM data from Windows, click Enable FILESTREAM for file I/O streaming access. Enter the name of the Windows share in the Windows Share Name box.
- If remote clients must access the FILESTREAM data that is stored on this share, select Allow remote clients to have streaming access to FILESTREAM data.
- Click Apply.
- In SQL Server Management Studio, click New Query to display the Query Editor.
- In Query Editor, enter the following Transact-SQL code:
EXEC sp_configure filestream_access_level, 2
RECONFIGURE
- Click Execute.
- Restart the SQL Server service.
Your new settings should apply now, so you may continue with the installation of CostOS Server & Workstation(s).