Find this
2024-04-15 17:05:42.75 spid15s Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.
If you are installing SQL Server on a domain controller, you need to pay attention to this article.
Otherwise,
Here are a few suggestions for you to try:
- Change the Sql server's Log on account to a local account in Services, restart the service, and try reinstalling.
- Create a self-signed certificate.
Specific steps you can refer to this similar issue.
Additionally
This link resolves the issue of being unable to access the certificate due to user configuration errors after setting up an SSL connection.
https://thesqldude.com/2011/08/03/sql-server-service-does-not-start-after-enabling-ssl-encryption/