I was installing SQL 2005 (clustered) on a Windows 2008 R2 server. Once installed, I was trying to start up the FullText service using SQL configuration manager. The start-up failed throwing an error: The SQL Server FullText Search (MSSQLSERVER) service depends the following service: NTLMSSP. This service might not be installed.
This was a minor problem, as we did not use FullText, but I had to get it running so that the resource group did not show up as a ‘partially up’ under the cluster manager.
I found that there are two ways to resolve this issue:
1) Patch SQL server to SP2 or
2) Edit the registry (use at your own risk) so that FullText does not use NTLMSSP.
For step two: Go to Start>Run> type ‘regedit’> Then browse to: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\msftesql
Double click the DependOnService key. There should be two values: RPCSS and NTLMSSP. Remove NTLMSSP, save, and then restart your server.
After this, you should be able to start up your FullText service without issues.
NTLMSSP stands for NT LAN Manager Security Support Provider. This service does not exist on Windows 2008 and hence the errors and FullText service issue.