Avatar of johnnyg123
johnnyg123
Flag for United States of America asked on

Full text search service error 2008

We were having an issue with the sql server full text service not being able to start on our recent installation of sql server 2012 sp1 standard edition on a server with windows 2008 r2 sp1



The MSSQLFDLauncher service was unable to log on as NT Service\MSSQLFDLauncher with the currently configured password due to the following error:
Logon failure: the user has not been granted the requested logon type at this computer.
 
Service: MSSQLFDLauncher
Domain and account: NT Service\MSSQLFDLauncher
 
This service account does not have the required user right "Log on as a service."
 
User Action
 
Assign "Log on as a service" to the service account on this computer. You can use Local Security Settings (Secpol.msc) to do this. If this computer is a node in a cluster, check that this user right is assigned to the Cluster service account on all nodes in the cluster.
 
If you have already assigned this user right to the service account, and the user right appears to be removed, check with your domain administrator to find out if a Group Policy object associated with this node might be removing the right.


Our network folks tried a few things but we still had a problem


I read somewhere that it might be corrupt and to try uninstalling and reinstalling the full text feature

I was able to uninstall but when I attempted to add full text search back I got the dreaded

no mapping between account names and security ids was done

Click to retry the failed action or click cancel

Not sure what this means or how I go about resolving it
Microsoft SQL ServerWindows Server 2008

Avatar of undefined
Last Comment
Marten Rune

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Marten Rune

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes