SQL Database Server Requirements

  • The ‘Full Text Search’ component must be installed as part of the SQL Server installation. This is a sub-component of the ‘SQL Server Database Services’ component within SQL Server installation wizard.
  • The account under which the SQL Server is running must be trusted for delegation. This can be found in the Active Directory of the respective user account properties under Delegation tab.
  • The server must use TCP/IP.
  • The SQL Server browser service must be started.
  • The SQL Server service should run under a domain account and not a local system account.
  • The collation setting for ‘Model’ Database on the SQL server is SQL_Latin1_General_CP1_CI_AS.
  • Ensure that the compatibility level of the ‘Model’ database on the SQL server 2014 is 120 (that is, Native) otherwise IRC services will not be activated. In case of SQL Server 2012 the compatibility level of the ‘Model’ database is 110 and for SQL Server 2008 R2, the compatibility is 100 .
  • The account under which the new Full Text Daemon Launcher service is running should be a member of the SQLServerFDHostUsers$InstanceName group on your machine (Local user and Groups->Groups section in Computer Manage on your machine). Unless this is done, the Global Search functionality will not run on SQL Server.
  • Ensure that ClrIntegrationEnabled is set to ‘ True’ as follows:
  1. Go to Start- > SQL Server Management Studio and connect to the SQL Server.
  2. Right click on the server name and select Facets.
  3. From the Facet drop-down list, select Surface Area Configuration.
  4. Check that ClrIntegrationEnabled is set to ‘True’.