Your Ad Here

Home Articles | Tutorials | Troubleshooting | Tweaks | Windows Server 2012 | Subsribe to RSS Feed Subscribe to RSS Affiliated sites

Follow me  Follow gusac on Twitter  Subscribe  Email  Subscribe to RSS

Your Ad Here

SQL FullText Search service fail to start–Dependency failure

12.Jun.2011 | by Gusac | Filed in: Articles, Troubleshoot

Issue: Windows 2008 Server, SQL server 2005. When you start the service SQL FullText Search, it throws error 1075: The dependency service does not exist or has been marked for deletion

If you check the dependency in the service properties, it shows only RPC service which is started.

 

More Information: SQL FullText Search service is also dependent on NTLMSSP (NTLM Security Support Provider) which has been deprecated in Windows 2008 server.

If you navigate to the following registry:

HKLM\System\CurrentControlSet\Services\msftesql

 

If you check the DependOnService value, it has two entries: RPCSS and NTLSSM

sql

 

Solution:

  • Remove the entry NTLMSSP as this does not exist on Windows 2008 server. However, the full-text search service depends on the NTLMSSP service.
  • Install the SQL Server service pack 3 as a workaround. This is what Microsoft recommends.