I am getting below error while doing the installation on ec2 instance and trying to install sql server 2019 enterprise edition. I am able to install it on ec2 manually. but its throwing error while installation from packer.
Below is the summary of error messages I am getting in the logs:
-
The directory monitor thread is interrupted due to the following exception while monitoring the notifications for directory ‘C:\Program Files (x86)’
-
Error: Action “Microsoft.SqlServer.Configuration.SmartSetupExtension.SearchUpdatesAction” threw an exception during execution.e[0m
2023-07-03T16:42:46.0622412Z e[0;32m amazon-ebs.windows: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) —> System.UnauthorizedAccessException: Access is denied. (Exception from HRESULT: 0x80070005 -
Attempting to write hklm registry key Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20230703_163831\Registry_SOFTWARE_Microsoft_Microsoft SQL Server.reg_e[0m
2023-07-03T16:42:46.0679497Z e[0;32m amazon-ebs.windows: Sco: Attempting to write hklm registry key Uninstall to file C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20230703_163831\Registry_SOFTWARE_Microsoft_Windows_CurrentVersion_Uninstall.reg_e[0m
2023-07-03T16:42:46.0681120Z e[0;32m amazon-ebs.windows: Sco: Unable to open hklm registry key SOFTWARE\Microsoft\MSSQLServer, error The system cannot find the file specified. -
Exception type: Microsoft.SqlServer.Chainer.ExtensionCommon.JobExecutionExceptione[0m
2023-07-03T16:42:46.1048104Z e[0;32m amazon-ebs.windows: Message:e[0m
2023-07-03T16:42:46.1049818Z e[0;32m amazon-ebs.windows: Setup encountered a failure while running job UpdateResult.e[0m
2023-07-03T16:42:46.1050751Z e[0;32m amazon-ebs.windows: HResult : 0x876e0003e[0m
2023-07-03T16:42:46.1051575Z e[0;32m amazon-ebs.windows: FacilityCode : 1902 (76e)e[0m
2023-07-03T16:42:46.1052375Z e[0;32m amazon-ebs.windows: ErrorCode : 3 (0003)e[0m -
Attempting to write hklm registry key Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20230703_163831\Registry_SOFTWARE_Microsoft_Microsoft SQL Server.reg_e[0m
2023-07-03T16:42:46.1244632Z e[0;32m amazon-ebs.windows: Sco: Attempting to write hklm registry key Uninstall to file C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20230703_163831\Registry_SOFTWARE_Microsoft_Windows_CurrentVersion_Uninstall.reg_e[0m
2023-07-03T16:42:46.1245405Z e[0;32m amazon-ebs.windows: Sco: Unable to open hklm registry key SOFTWARE\Microsoft\MSSQLServer, error The system cannot find the file specified.
I am provisioning an ec2 system → downloading the setup files from our jfrog artifactory → executing setup.exe with configuration present in Configuration.ini file. → creating an ami with this and using this ami setting up another ec2 instance
It completed successfully but I am getting above mentioned errors in the logs and also when creating final ec2 instance for my use I could not see complete installation.
With manual installation I could find below packages in add\remove programs:
- Microsoft Visual Studio Tools for Applications 2019
- Microsoft SQL Server 2019 Setup (English)
- Microsoft SQL Server 2019 (64-bit)
- Browser for SQL Server 2019
- Microsoft SQL Server 2019 T-SQL Language Service
- Microsoft VSS Writer for SQL Server 2019
and with packer only getting on packe installed:
- Microsoft Visual Studio Tools for Applications 2019