troubleshooting Question

Full text search service error 2008

Avatar of johnnyg123
johnnyg123Flag for United States of America asked on
Microsoft SQL ServerWindows Server 2008
1 Comment1 Solution1863 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Marten Rune
SQL Expert/Infrastructure Architect

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros