Prerequisites for using your own SQL server

<< Click to Display Table of Contents >>

Navigation:  Troubleshooting and Tech Help > SQL Server Requirements >

Prerequisites for using your own SQL server

 

❖ Database Server Requirements when using your own MSSQL Server

 

 

 

Database Server Requirements

 

Docsvault needs either an empty database or a database with Docsvault data in it. Databases that have some other data in them cannot be used.

 

Your SQL Server must meet the following requirements for Docsvault:

 

•FILESTREAM must be enabled

•Full-Text Search must be enabled.

•Required iFilters must be installed and enabled for supported document formats.
 

1.Ensure FILESTREAM is enabled:
 

•Open SQL Server Configuration Manager (Start > Programs > Microsoft SQL Server 2022 > Configuration Tools > SQL Server Configuration Manager)

 

•Navigate to the SQL Server Services node and from the right pane open the properties dialog for the SQL Server service from its right click menu.
 

•Click the FILESTREAM tab and select the checkbox to enable FILESTREAM for Transact-SQL access.

 

clip0005

 

2.Ensure Full-Text Search feature is installed and enabled:
 
SQL Full-Text Indexing service named ‘SQL Full-text Filter Daemon Launcher’ should be installed and running on the server hosting the SQL database for Docsvault. If you do not have the full text feature installed, you will need to install that before you can configure the Docsvault database.
 

3.Ensure proper search iFilter are installed  

Full-text (content) search in Docsvault requires an iFilter to be installed on the server hosting the Docsvault SQL Server database. They are not required on client/workstation machines.

 

Windows includes iFilters for some formats out of the box; others must be installed separately.

 

•.doc, .docx, .xls, .xlsx, .ppt, .pptx - Supported when Microsoft Office is installed on the SQL Server machine. If Office is not installed, you can install the Microsoft Office 2010 Filter Pack (free, no Office license required). 

 

•.pdf - Modern Windows operating systems include support for PDF indexing. If PDF files are not being indexed, install and register a supported PDF iFilter.
 

•.msg - The Microsoft Office 2010 Filter Pack support for Outlook (.msg) files. If .msg files are not indexed, install Microsoft Outlook 2010 or later, which registers the required MSG iFilter.
 

•.eml - Supported using the built-in Windows MIME iFilter; no additional installation is required.
 

•Additional File Types: Install the appropriate iFilter for the required file type from IFilter.org or IFiltershop.com.

 

For SQL Server 2025, external iFilters are managed using the Version 2 Full-Text Search component system and version_overrides.json. Refer How to Enable External iFilters in SQL Server 2025 for installation and configuration instructions.