Hi @Franko,
Thank you for reaching out and welcome to Microsoft Q&A.
From your detail log, we can see that the first issue is here:
This is due to the MSI incomplete install. Please check out this article, hope this can help you well and ensure the specified instance has been installed.
In addition, you can try to reinstall SQL Server. Erland provides a useful thread; it explains the steps in detail.
Feel free to share your issue here if you have any confusions.
Best regards,
Lucy Chen
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
https://docs.microsoft.com/en-us/answers/support/email-notifications