Configuring Microsoft SQL Server to perform full text searches in documents
This post describes the steps needed to install and configure Microsoft SQL Server to perform full text searches within documents like Word, pdf, rich text format etc. These instructions require no prior knowledge of using or installing SQL Server - all steps from installation to implementation are included. 1. Install SQL Server. Go to MSDN Subscriber downloads: https://msdn.microsoft.com/en-us/subscriptions/downloads/ If you have not yet done so create an account with them. Check the boxes that apply to you – 32/64 bit architecture, language etc. I chose the free version of SQL Server Express 2014 with Advanced Services. Advanced Series is what you will need if you wish to install full text searches. The ordinary installers not appear to include this. Once downloaded, run the installer. Just click OK when prompted to choose the destination folder: And let it run Then choose to run a new installation of SQL Server 2014: And continue through the inst...