Showing posts from April, 2015

SharePoint Server 2013 and SQL Server Full-Text Search

There's long been some debate as to whether or not SharePoint requires you to install the SQL Server Full-Text Search feature on the database server. I've worked on the premise that it doesn't - SharePoint has its own search engine, etc. However, the Access Services service application DOES require the Full-Text Search feature. If this feature is not installed, you'll get an error when you attempt to provision an Access Services service application that states "The Application Database Server does not have the Full-Text Search feature installed". Access Services actually places a whole bunch of extra demands on the database server in addition to the Full-Text Search requirement. For example: The database server must be running at least SQL Server 2012 (SharePoint Server 2013 will run happily on SQL Server 2008 R2 SP1) The SQL Server instance must support mixed mode authentication. The SQL Server instance must support Named Pi