SQL SERVER – Installation Wizard Hang Forever – Please Wait on Feature Selection Page

SQL
No Comments

Here is one of the situations which I encountered with SQL Server 2014 on Windows Server 2012 R2. I wanted to add “Analysis Services” features to an existing installation. I came up with the feature selection screen on SQL setup and pressed next it hangs with “Please Wait”. I click on it and went for lunch, when I came back, it was still in the same state. Let us learn how to fix the issue related to Installation Wizard Hang Forever.

SQL SERVER - Installation Wizard Hang Forever - Please Wait on Feature Selection Page setup-hang-please-wait-01-800x604

Earlier, I have written blogs for setup hang situations which are below but they are not for the same problem.

SQL SERVER – Slow Installation Wizard on Cluster – Please Wait While Microsoft SQL Server 2016 Setup Process the Current Operation

Solarwinds

SQL SERVER – Installation Wizard Hangs at Service Account Page – The RPC Server is Unavailable

I went ahead and looked into Detail.txt to see what is causing the hang.

Baseline Package Id: sql_engine_core_inst_Cpu64, ProductCode: {17531BCD-C627-46A2-9F1E-7CC920E0E94A}, The cached MSI file C:\Windows\Installer\1b04c4ec.msi is missing.
Error: Action “Microsoft.SqlServer.Configuration.MsiExtension.SetPatchInstallStateAction” threw an exception during execution.
Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: The cached MSI file ‘C:\Windows\Installer\1b04c4ec.msi’ is missing.
Its original file is ‘sql_engine_core_inst.msi’ and it was installed for product ‘SQL Server 2014 Database Engine Services’ from ‘R:\x64\setup\sql_engine_core_inst_msi\’, version ‘12.1.4100.1’, language ‘ENU’.

To resolve this problem, recover the missing file from the installation media and start setup again.

WORKAROUND/SOLUTION

If you read the information in Detail.txt, it is clear that I have deleted some files from C:\Windows\Installer folder which are needed for SQL Server installation process. This is my lab server and I sometimes do cleanup space. As a DBA, you should never delete files from C:\Windows\Installer folder.

To solved my problem, I used Microsoft’s knowledge base article.

Once I cached the missing files, I was able to move forward and add the feature.

Reference: Pinal Dave (https://blog.sqlauthority.com)

Solarwinds
, , , ,
Previous Post
SQL SERVER – Unable to Start SQL Server Agent. Error – Driver’s SQLAllocHandle on SQL_HANDLE_ENV failed
Next Post
SQL SERVER – Install Error: Standalone SQL Server on WFC Cluster Cannot Have Files on Shared Disk Locations

Related Posts

Leave a Reply

Menu