Install and Configure SQL Server for Aligned Elements

1. Download SQL Server Download the SQL Server or SQL Server Express edition from Microsoft.

Note! If using SQL Server Express, be sure to install the Advanced Service edition, since it supports Full Text search on which Aligned Elements relies. (The “regular” SQL Server Express does not support Full Text search and can thus not be used for Aligned Elements.)

In e.g. SQL Server Express 2022 this is achieved by:

1) Starting the SQL Server installer

2) Select "Download Media" to dowload all files

3) In the subsequent dialog "Specify SQL ....", select "Express Advanced" (the second option from the top)

2. When installing SQL Server, make sure that during „Feature Selection“, the „Full Text...“ option is selected.

3. Make sure that a case-insensitive collation is used.

4. Make sure that the SQL Server Authentication mode is set to „Mixed mode“.

5. You now need to install a filter pack to allow sQLserver to read the content of different document types (e.g. doc, docx)

Download from https://www.microsoft.com/en-US/download/details.aspx?id=17062.

Select the correct version depending on your OS (32 or 64 bit)

Start installation by clicking on FilterPackx86.exe (or FilterPackx64.exe)

For further informations: http://support.microsoft.com/kb/945934

a. Start SQL Server Management Studio.

b. In SQL Server Management Studio, select the instance in which you want to enable IFilters, and then run the following command (query) in that instance:

sp_fulltext_service 'load_os_resources', 1

c. Restart the SQL Server service

6. Set up a login for Aligned Elements. In the “Security” folder, select the “Logins” folder, right click and select the option “New Login…”.

• Create a new user name with the name “AlignedElement” (not “AlignedElements”).

• Set the password to the password that you have obtained from your Aligned contact.

• Uncheck “Enforce Password Policy” and uncheck “Enforce password expiration”.

• Make sure that the default language for the user is set to English.

• Make sure that the user “AlignedElement” is assigned to the Server Roles “public” and “sysadmin”.