FullText Search Error 1075: The dependency service does not exist or has been marked for deletion

Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses.
Error: FullText Search Error 1075: The dependency service does not exist or
has been marked for deletion

Infrastructure: SQL server 2005 and onward

Scenario: While I was working on Migration project for one of my prime customer from SQL2005 32-bits to SQL2005 64bits few years ago, after SQL sever build I wanted to restore databases backup taken to the destination one by one.

but while doing so, I received an error FullText Search Error 1075: The dependency service does not exist or has been marked for deletion and this error led me not to restore databases backup.

then I checked the FullText service and tried to start it but could not cross the bridge.

Resolution:

I then went inside the event logs just to see if any other error details could be found and yeah, I was right I found more info which guided me to the corrective action.

that way I got to know Full text service was not running because it depended service RPCSS NTLMSSP was actually not available at all.

Follow the below steps in order to resolve this error.

1. Open the registry key HKEY_LOCAL_MACHINE\System\CurrentControlSet
\Services\msftesql

2. Rename the value DependOnService to anything or make the entry blank but take the backup of registry while doing so.

3. Restart the server

Hope this helps!