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.
Earlier, I have written blogs for setup hang situations which are below but they are not for the same problem.
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.
Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.
Discover more from SQL Authority with Pinal Dave
Subscribe to get the latest posts sent to your email.
1 Comment. Leave new
Dear Team,
we have one issue during install sql express editon 2012 below exception
Error writing to file the microsoft.datawarehouse.interface.dll verify that you have access to that directory