Thursday, August 21, 2008

SQL Server FullText Search service could not be started

After you have installed SQL Server 2005 on Window Vista, you might find your the service above could not be started, and it returns you error like "the dependency service is missing or marked for future deletion".

The problem is that one of the service named "NTLMSSP" does not exist in Window Vista environment. If you want to know better about NTLMSSP, Live-Search it.

The solution is simple, install SQL Server SP2 for Vista. Then you will find the dependency service removed.

If the problem persisted, DIY method at below:

  1. type in "regedit" in Search to open Registry Editor.
  2. Go to HKEY_LOCAL_MACHINE -> SYSTEM -> CurrentControlSet -> Services
  3. Select msftesql. Check that the display name is SQL Server FullText Search.
  4. Find the item named "DependOnService". Right Click -> Modify
  5. remove the NTLMSSP from the list and Click Ok
  6. Reboot and you can try starting the service again.

Hope it helps.

No comments: