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


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

Comments (1)

  1. markdave says:

    depens the following1. menstrua2. meno3. premenstrual