The SQL Server FullTextSearch (MSSQLSERVER) service depends the following service: NTLMSSP. This service might not be installed.

  • Article

SQL Server 2005 FullText Search on Windows 2008 [Longhorn] Cluster fails to come online. Below is the error noticed in System event log

Generic application 'SQL Server Fulltext' could not be brought online (with error '1075') during an attempt to start the service. Possible cause: the specified service parameters might be invalid.

The SQL Server FullTextSearch (MSSQLSERVER) service depends the following service: NTLMSSP. This service might not be installed.

 

Resolution 1

==============

Locate the below registry entry on the nodes where FTS is not coming online

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\msftesql\DependOnService

Remove "NTLMSSP" & restart OS (You may want to follow KB 322756 [How to back up and restore the registry in Windows] before you make the registry changes)

 

Resolution 2

==============

Refer to KB 936302 & check problem 3 stated in there

Install SQL Server 2005 SP2 to fix this issue