Core component of SQL Server for storing, processing, and securing data
Again, this is quite obviously something in your environment. I asked if this was in a corporate context, because in that case your IT department might have set up some funny group policy or similar that you were unaware of. Since this is your home environment, you are your own IT department.
The error suggests one of:
- The install process does not have permission to start services.
- The service account for the service does not have the permission to log on as a service.
The text of the message makes me more think of the first alternative, but since the install service was able to start a few more services, and you were able to get these started by changing to a domain account, it has to be the second one.
There does not seem to be a way to set the service accounts for the telemetry services, but it will always be NT Service\SSISTELEMETRY170 and NT Service\SQLTELEMETRY. But since these accounts now have been created, you could manually grant these accounts the required permissions.
Normally, you should not have to do that, but this is something that SQL Server Setup takes care of. Why this did not happen in your case, I don't know.