SQL server 2016 installation freeze

问题:

Hope someone can help me here . I have no further information other than that at a later stage in setup the whole process hangs showing install_confignonrc_cpu64
I am unable to cancel out of it even , the only way was to kill it . Is there any solution for that ?

回答1:

My problem was that the installer tries to download Microsoft R Open , if you have a slow connection you will see the installation freeze for a very long time without any progress bar updates or so . I fixed the problem by deselecting all R components since i dont need them then the installation went smooth .

回答2:

Just leave it "Stuck" - it is doing a Download in the background, I left the PC for a couple hours while doing some errands, and then..boom- All set.

回答3:

just had the same problem which is why I found this question. Fixed the problem by closing the original media install menu window (where I'd selected "New SQL Server standalone" which is the first option). The install window then carried on.

回答4:

Disable and stop the windows update service and then start the installation. After the installation is complete put the service back on.

回答5:

I have faced same problem with you, the simple way that i have find is turn on Windows firewall then wait a minute after that it will auto complete setup success. Hope this work in your case .

Thanks, Cuong.

回答6:

SQL Install gets stuck on sqlrsconfigaction_install_confignonrc_cpu64 (SQL Server 2016 using standalone installer, also when installing on Azure VMs)

Resolution:

1. Stop the install (Taskman -> Kill Process)
2. Open regedit

3. Navigate to:

   HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Policies\Microsoft\Windows\
   

4. Add New Key Called: AppCompat

   You should have this once added:

   HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Policies\Microsoft\Windows\AppCompat
   

5. Add New DWORD entries as stated below to the AppCompat key:

   DWORD: DisableEngine Value = 1
   DWORD: DisablePCA Value = 1
   DWORD: SbEnable Value = 0
   

6. Check the following location as the above key you added should also be here:

   HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\
   

7. Restart the installation.

回答7:

I closed everything and rebooted. Not sure if maybe having Visual Studio open or something else prevented it from installing, but it got stuck.