Hi @Duddu Venkata Raviteja,
General troubleshooting methodology
Isolate the error by following these steps:
- Select Details from the setup process's Failure screen.
- In the %programfiles%\Microsoft SQL Server\nnn\Setup Bootstrap\Log folder, check Summary.txt under the Product features discovered section to determine whether any of the listed features report a failure. If they do, you can focus on resolving problems that affect that feature.
- Go to the subfolder that's named yyyyMMdd_HHmmss (for example 20220618_174947) that corresponds to the reported failure time that you are focusing on. The goal is to examine the feature-specific files, ERRORLOG files, and Details.txt file, if necessary.
- Go to the \MSSQLSERVER subfolder, and locate the log files that are specific to the feature that failed. For example, sql_engine_core_inst_Cpu64_1.log. For upgrade script failures, check the SQLServer_ERRORLOG_date_time.txt files that correspond to the time of the upgrade failure.
- Open the Details.txt log file, and search on the keyword "Failed." Not every failure is considered critical.
For more information, see View and Read SQL Server Setup Log Files.
In the next few sections, check for a scenario that corresponds to your situation, and then follow the associated troubleshooting steps. If there's no matching scenario, look for more pointers in the log files.
See: Troubleshoot common SQL Server Cumulative Update installation issues
Regards,
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.