SQL server 2016 installation freeze

Question

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 ?

Answer 1

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.

Answer 2

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.

Answer 3

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.

Answer 4

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

Answer 5

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 .

Answer 6

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