Wednesday, April 6, 2011

Is there any way to enable Full Text Search on installed sql2008,without uninstalling it again

Is there any way to enable Full Text Search on installed sql2008,without uninstalling it again

From stackoverflow
  • Full-text search is on by default but it is possible to toggle it on specific tables. Here is a tutorial on how to enable and disable full-text search in SQL Server 2008.

    peter : But when iam going to enable in the same way what tutorial said,that option is not active can u pleas give me the solution for this,or i have to reinstall again???
  • If you didn't install it as an optional component at the time of install, then running the installer again should detect the existing SQL Server instance. You can then pick it as an additional option to install and it will only install that component.

    You should be able to re-run the installer from add/remove programs or the SQL Server DVD.

    peter : So i need to reinstall it again,,thanks
    Nick Kavadias : no, you don't need to re-install. The setup will not re-install components that are already there!
    Brent Ozar : We've got a failure to communicate here. PRG - if you think "reinstall" means rerunning setup.exe, then yes, you're right, but this won't require uninstalling and installing the SQL Server instance.
  • If you believe you installed it but it isn't working, you may find that your "SQL Server Full-text Daemon Launcher" service is disabled. Go to Control Panel -> Administrative Tools -> Services. Find the "SQL Server Full-text Daemon Launcher" entry, right click and select properties then enable it and start the service.

    Eric Ness : Awesome! This is exactly what I needed. Thanks!

0 comments:

Post a Comment