Using the Full Text Search

In Citavi for DBServer it's possible to add a full text search feature to the SQL Server. This feature can be used with Citavi to index attached files similar to how an online search engine would do it. As a result searching across thousands of attached files is very fast.

In Citavi DBServer Manager you can check under Actions > Databasek > Configure full text search if the SQL Server full text search is already installed or not. If you see that notification The full text search is not installed on the SQL server, enable or install the feature.

Please note:

If you're working with Microsoft SQL Server 2017 Express or Microsoft SQL Server 2016 Express and used the Citavi program SQL Server Express for Citavi Setup, the SQL Server Full Text search is already installed and enabled.

Enabling the SQL Server Full Text Search

If your Microsoft SQL Server is installed with Advanced Services, open the SQL Server installation center and follow the steps under Install Microsoft SQL Server 2017/2016/2014 Express with Advanced Services starting from step 5.

Installing the SQL Server Full Text Search

Install Microsoft SQL Server 2017/2016/2014 Express with advanced services

1.Log in to Windows using a domain account with administrator rights.
Important: A non-administrator account that is "elevated" with UAC after starting the Setup will not work.

2.Download the appropriate Setup from the Microsoft website. You can use the links below to quickly jump to the Microsoft page for the Setup you need:

a.Microsoft SQL Server 2017 Express

b.Microsoft SQL Server 2016 Express

c.Microsoft SQL Server 2014 Express

3.Select the appropriate advanced Setup file, for example ExpressAdv 64-bit\SQLEXPRADV_x64_ENU.exe if the existing SQL Server has an English interface and is running on a computer with a 64-bit operating system.

4.Extract the Setup file by double-clicking the .exe file you just downloaded. The Setup asks you to select a folder for the extracted files. Usually you will use the Setup program to create a folder in the same folder you saved the Setup file in that has the same name as the Setup program, for example SQLEXPRADV_x64_ENU.

5.After some time the SQL Server Installation center finishes the extraction and opens automatically.

6.Under Installation, click New SQL Server stand-alone installation or Add features to an existing installation.

7.Select Add features to an existing instance of SQL Server 2017/2016/2014 and then select the instance from the drop-down menu, for example CITAVISERVER. Click Next.

8.In the next step you will see an overview of the available features. Under Instance Features select the Full-Text and Semantic Extractions for Search checkbox and then click Next.

9.Continue through the rest of the installation.

Install Microsoft SQL Server 2012 Express with Advanced Services

1.Log in to Windows using a domain account with administrator rights.
Important: A non-administrator account that is "elevated" with UAC after starting the Setup will not work.

2.Download the appropriate Setup from the Microsoft website.

3.Select the appropriate advanced Setup file, for example SQLEXPRADV_x64_ENU.exe if the existing SQL Server has an English interface and is running on a computer with a 64-bit operating system.

4.Follow the steps under Install Microsoft SQL Server 2017/2016/2014 Express with advanced services  starting from step 3. When extracting the Setup file a temporary folder is automatically created and the SQL Server Installation Center will open. Otherwise the steps are the same as described under Install Microsoft SQL Server 2017/2016/2014 Express with advanced services.

Install Microsoft SQL Server 2008 R2 Express with Advanced Services

If you're using Microsoft SQL Server 2008 R2 Express you will first need to install an upgrade to the SQL Server 2008 R2 Express Edition with Advanced Services. After that, the full text feature is visible and can be installed.

1.Log in to Windows using a domain account with administrator rights.
Important: A non-administrator account that is "elevated" with UAC after starting the Setup will not work.

2.On the Microsoft website, click Download. Select the appropriate advanced Setup file, for example, SQLEXPRADV_x64_ENU.exe if the existing SQL Server has an English interface and is running on a computer with a 64-bit operating system.

3.Open a command prompt window with administrator rights.

4.Switch to the folder in which the Setup file was saved and enter the following command line:
start "" /wait <Name der Setup-Datei, z.B. SQLEXPRADV_x64_ENU.exe> /ACTION=editionupgrade /INSTANCENAME=<Instanzname, z.B. CITAVISERVER> /IACCEPTSQLSERVERLICENSETERMS /FEATURES=SQL,RS /INDICATEPROGRESS /Q

5.After pressing the Enter key, the edition upgrade runs in the background. Wait until the console is available again.

6.Follow the steps under Install Microsoft SQL Server 2017/2016/2014 Express with advanced services starting from step 3. When extracting the Setup file a temporary folder is automatically created and the SQL Server Installation Center will open. Otherwise the steps are the same.