• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1072
  • Last Modified:

SQL Full-Text Search Service won't start

I have a Windows NT server that i migrated to another domain. Everything works accept that the Microsoft Search Service (Full-Text Search) won't start.

I'm getting an error event ID 7023 "the Microsoft Search Service terminated with the following error: No mapping between account names & security IDs was done."

I don't understand because the service is starting under the local system account

Thanks in advance
0
inf2300
Asked:
inf2300
1 Solution
 
imran_fastCommented:
Try putting the user name and password instead of using the local account.
0
 
lokeshgm7Commented:
The issue occurs because of change of SQL Server service account.
Check this KB for more info

http://support.microsoft.com/?id=308787


1. Delete the following keys under HKLM\Software\Microsoft\Search\1.0 :
 • ...\Applications\SQLServer\AccessControl
 
• ...\Gathering Manager\AccessControl
 
• ...\Gathering Manager\Applications\SQLServer\AccessControl
 
• ...\SearchService\AccessControl  


 
2. Start the MS Search service under the Local System Account. The preceding keys are populated to their default values.  
3. In Enterprise Manager, change the account that SQL Server runs under to the Local System Account.  
4. Change back to the account you want for SQL Server from Enterprise Manager.  


0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now