database engine services failed to install sql 2019

Kelvin Nam 0 Reputation points
2024-01-22T08:47:05.1366667+00:00

sql_engine_core_shared_Cpu64_1.log hi i've been installing sql server and wanted to enable tcp/ip connection to connect with other. but as you can see in the picture, there is no Network Configuration tab for me to enable it (my is 64-bit) so i tried to install the cummulative update and it declared error while installing database engine services, i've attached the log file i really need this so if you could solve this problem or tell me alternative way to enable tcp/ip connection thanks Screenshot 2024-01-22 at 15.45.13

SQL Server Other
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator
    2024-01-22T22:41:59.3866667+00:00

    First I thought the installation of the CU might be failing due to the accident you seem to have with SSCM. But looking in the log file, this seems to be where things to wrong:

    MSI (s) (80:E0) [15:36:27:978]: Note: 1: 1722 2: InstallService.754C9258_CE8E_4420_9B81_7AD051B1479F 3: C:\Program Files\Microsoft\AzureAttestService\AzureAttestServiceInstaller.exe 4: -Install AzureAttestService.dll CustomAction InstallService.754C9258_CE8E_4420_9B81_7AD051B1479F returned actual error code -2147019873 (note this may not be 100% accurate if translation happened inside sandbox)MSI (s) (80:E0) [15:36:27:993]: Product: SQL Server 2019 Database Engine Shared -- Error 1722. There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor. Action InstallService.754C9258_CE8E_4420_9B81_7AD051B1479F, location: C:\Program Files\Microsoft\AzureAttestService\AzureAttestServiceInstaller.exe, command: -Install AzureAttestService.dll

    And I can't see the direct connection between AzureAttestService and SSCM. I do have a recollection of other having had some sort of trouble with AzureAttestService, but it was a couple of years back, and I don't remember the details.

    In any case, I would try to run a Repair of your installation to see if that brings SSCM back to life.

    If the option of opening a support case is available to you, I would consider doing that.

    0 comments No comments

  2. ZoeHui-MSFT 41,491 Reputation points
    2024-01-23T03:14:47.17+00:00

    Hi @Kelvin Nam,

    As mentioned in the error log, there is a problem with this Windows Installer package.

    Please check this for a try.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.