© 2018 Capita Business Services Ltd. All rights reserved.

Capita Education Software Solutions is a trading name of Capita Business Services Ltd. Our Registered office is 30 Berners Street, London, W1T 3LR and our registered number is 02299747. Further information about Capita plc can be found in our legal statement.

FMS6 - Scanned Documents

Scanned Documents in FMS / SQL Storage option

In order to use Scanned Documents functionality and store the documents in SQL, FMS customers will need to:

  1. Enable FILESTREAM in SQL Server
  2. Apply a licensing and configuration patch to enable filestream to be able to be used in FMS.
  3. Select the filestream option in FMS

This will enable supporting documents to be added to FMS Invoices et al.

How to enable File Stream in SQL

In order to enable FILESTREAM please follow the following steps:

  1. Go to: https://docs.microsoft.com/en-us/sql/relational-databases/sql-server-configuration-manager?view=sql-server-2017
  2. Choose the version of SQL that you are using and run the command shown:

SQL Version

Configuration Manager

SQL Server 2017

C:\Windows\SysWOW64\SQLServerManager14.msc

SQL Server 2016

C:\Windows\SysWOW64\SQLServerManager13.msc

SQL Server 2014 (12.x)

C:\Windows\SysWOW64\SQLServerManager12.msc

SQL Server 2012 (11.x)

C:\Windows\SysWOW64\SQLServerManager11.msc 

2. In the list of services, right click SQL Services, and then click Open

3. In the SQL Server Configuration Manager snap-in, locate the instance of SQL Server in which you want to enable FILESTREAM

Configuring SQL
SQL Configuration

4. Right-click the instance and then click Properties highlighted above.

5. In the SQL Server Properties dialog box, click the FILESTREAM tab.

Configuring SQL
SQL Configuration
  • Select the Enable FILESTREAM for Transact-SQL access check box.
  • Click Apply.

How to Apply the Patch

  1. Download patch 16361
  2. https://pmapis.azure-api.net/guidance/
  3. Unzip the patch in to a folder say c:\temp\16361
  4. Run dbUpgrade (Start | Run DbUpgrade)
FMS 6 - Apply patch
Apply patch
  1. Press Install

Enabling File Stream in FMS

Confgure SQL
Configure FMS File Storage

Check the box for ‘Store scanned documents in the database.  Please note that this is a one-way process.  If partners need systems that work with and without file stream enabled, they would need to install 2 FMS databases.