For some reason I can't get SQL Server 2017 installed on my Windows 10 machine.
First thing to do with this buggy installer is that I had to uninstall VCRuntime 2017 in order for the installer to work.
And now, the installer is stuck at this point exactly every time I try to install it:
What I've tried so far:
- Killing msiexec process
- Running the setup with additional parameter as mentioned here
Setup.exe /SkipInstallerRunCheck- Restarting ... reinstalling ... turning off anti-virus ...
[Solved]
The problem was due to a background download that was taking forever especially on a low internet speed (i.e. python or R-support component).
[Solution]
- If you really need python or R-support just wait until download is complete
- Else, deselect python and R-support from the component list.
- (or) kill the child process for python or R-support component downloader from task manager.
4条答案
按热度按时间jum4pzuy1#
UPDATE:
The actual problem turned out to be the R-support component(s) slowly downloading in the background locking up the installation GUI with no notification or warning show to the user as to what is actually going on.
So it seems this "locked install problem" can be caused by installing several different components, at least by Python or R-support. As mentioned below, please check any available logs or event logs for clues.
In summary, options:
Stuck Download?
UPDATE: Did you see this blog ? Looks like the setup tries to download and install the Python runtime, and this can take forever. Are you behind a proxy btw? No direct connection to the Internet? If so I suppose this could also cause further problems. Probably not the cause, but worth a mention.
Apparently you can check the following log file for progress for the installation:
%ProgramFiles%\Microsoft SQL Server\140\Setup Bootstrap\Log\DATE_TIME\RSetup.logDATE_TIME in the above path must be converted to your valid values. For example:
20170804_162723(date part and time part).See this answer as well: SQL server 2016 installation freeze. You could also try the suggestion to deselect all components you do not need to prevent any background downloads?
General Debugging
Leaving in the general purpose debugging suggestions below.
Generic Advice: From experience I would create a new local admin user and try to install using that account. This is to avoid any "unclean" or special conditions that have occurred in your user profile or registry during regular Windows use. Might not do much, but sometimes it gets the job done with surprising ease. Worth a try I think.
Some Further Things: I wrote up a little check list a while back, I'll add it and see if it inspires some new ideas that can help you. See under "Core Deployment Problems". That first "check list" was condensed from a longer and somewhat excessive first writeup - one of those answers that unintentionally turned into a blog and maybe a hard one to read.
Logging: Did you check log files and / or event logs properly for clues as to what is happening? I find the best approach for deployment to enable logging for all MSI installations. The performance hit it triggers is minuscule compared to the benefit of having a real log-file always available when you suddenly need one. You can enable logging for all MSI files as explained on installsite.org (section: "Globally for all setups on a machine"). MSI log files will then just sit in your
%TEMP%folder after installation. They have a random hex name, and you can flush them all regularly if you do not need them. You sort by modify date / time to find the latest one(s) created - obviously.***
Jedi trick***: You will want to go home and re-think your life if you don't enable logging for all MSI files. Moral of the story: MSI log files are cool. They are very verbose, but they are beautiful. There are some hints on interpreting them here (bottom).uelo1irk2#
My 2 cents: SQL Server Installer consists of several small MSI installers. MSI installers can only be installed one after each other (as fas as I know). In my case, I launched another MSI setup while installing SQL Server. This caused SQL Server Setup to hold until I finished the concurrently running setup.
So, at least in my case the problem was self-made.
ruarlubt3#
For me the solution was different.
I spent 2 days trying to figure out how to install SQL Server 2022 in my laptop (Samsung book 2) Aparently the ssd of my system doesn't have the proper configuration for the sector size.
I finally found this post
The short solution is to add a key to windows registry so that Sql server gets the expected size. You have to run this command with elevated privileges:
REG ADD "HKLM\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" /v "ForcedPhysicalSectorSizeInBytes" /t REG_MULTI_SZ /d "* 4095" /f
Restart windows and when I tried to install again it doesn't get stuck in sqlengineconfigaction_install_confignonrc_cpu64 anymore.
l2osamch4#
You have to remove configuration settings for SQL Server from Windows Registry editor.