If you are using Full text index, then you should have a service named 'MSSQLFDLauncher', and usually it should be stopped automatically when you stop SQL Server serivce. This is the expected behavior because SQL Server will send request to service control manager to stop the FDlauncher.
But recently I'm trying to configure my SQL Server service account with the GMSA account, however, when I stopped SQL Server, the FDLauncher was not stopped automatically. So I collected a service ETL log, and found below errors:
[6] 0008.41C8::03/07/22-14:00:27.5646147 [SCM] scopen_cxx1027 ScOpenService() - ScOpenService: ScAccessValidate Failed 5, service MSSQLFDLauncher
The GMSA account was configured with all of the permissions required by below public doc before I used it,
But seems it requires more priviledge to control the service, so after a short time research, I got to know how to grant the permission to control a service, we have several ways actually:
After granted the 'Read Control','Service Start','Service Stop' permission to the account, the FDlauncher can be stopped correctly.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.