SQL server, SQLServerPedia Syndication

SQL Server 2005 Full-Text NTLMSSP error.

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.


Thinking about someting? Leave a Reply...

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s