Install and Configure SQL Server for Aligned Elements
Last updated
Was this helpful?
Last updated
Was this helpful?
1. Download SQL Server Download the SQL Server or SQL Server Express edition from Microsoft.
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”.