We have a problem with the Launchpad Service shutting down and doesn't come back up. The service is has startup type "automatic", but when the server is restarted, or the sevice is stopped for some other reason, it's unable to start Launchpad Service back up. The service is ran by our own service account to get the proper rights (and not by Local Service/System). Every time this happens (which is about once a week) we have to go through the following procedure:
- Enter the SQL Server Configuration Manager
- Try to start Launchpad Service - which fails
- Change the account to Local Service
- Try again to start Launchpad Service - now it starts
- Change the account back to our own account
- The service is restarted and now it's working
This is the system we are running:
- Windows Server 2019 Standard 10.0, Version 1809 (OS Build 17763.2458)
- SQL Server 2019 15.0.4178.1
This did not occur before when running on Windows Server 2016 and SQL Server 2016. So it seems to be some bug in the later Windows Server/SQL Server versions.
Has anyone else experienced this? Any ideas of how to solve this?
When trying to start the service again this popup appears:
"The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details."
In the event log there's one System log containing:
"The SQL Server Launchpad (MSSQLSERVER) service terminated unexpectedly. It has done this 2 time(s)."
And a bunch of audit failure secutiry logs:
We have tried to give the service account all the required priveliges. When the service is restarted in step 6 we also get the same Security event logs but no error popup and the service is starting and running as it should.