Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Full text search service error 2008

Posted on 2013-12-12
1
Medium Priority
?
1,448 Views
Last Modified: 2013-12-20
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
0
Comment
Question by:johnnyg123
1 Comment
 
LVL 20

Accepted Solution

by:
Marten Rune earned 2000 total points
ID: 39720649
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For anyone that has accidentally used newSID with Server 2008 R2 (like I did) and hasn't been able to get the server running again because you were unlucky (as I was) and had no backups - I was able to get things working by doing a Registry Hive rec…
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

885 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question