We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

SQL Server 2008 Setup Hangs

Medium Priority
6,881 Views
Last Modified: 2012-08-14
The installation of SQL Server 2008 hangs with the installation of the Setup Support Files.
OS Vista SP2, quad core, x64

SQL Server 2008 was running fine before, but SQL Server 2008 SP1 would not install, and consistently wanted me to install updates and shut off my PC. So I decided to completely deinstall SQL Server 2008, and all other versions of SQL Server. The deinstallation hang. After this, I followed some guidelines from other uses to completely manually remove SQL Server 2008, as deinstallation via Config panel no longer worked. SQL Server is now completely gone.

Now when installing, The installation stops at 2/3 of "Performing Windows Installer actions", see screen shot. It starts, and after a few seconds it reaches this point. It consistenly hangs atht the same location of the progress.

Any ideas?
Sql-install-hang.jpg
SQL-SupportFiles.jpg
Comment
Watch Question

Vitor MontalvãoIT Engineer
CERTIFIED EXPERT
Distinguished Expert 2017

Commented:
WOW.
Looks like format will be better. At least you gonna start with clean installation.

Good luck.
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:
Copy the installation media from either DVD or Network share to your local machine and give it a try.

If it says of any errors like some component is already present and not able to install, then we can use Windows Installer Cleanup Utility to fix it out..

Author

Commented:
I will do this today and let you know, thanks

Author

Commented:
Sage, I copied the DVD to the hard disk and got this error during the installation:
===============================================

TITLE: Microsoft SQL Server 2008 Setup
------------------------------

The following error has occurred:

SQL Server Setup has encountered an error when running a Windows Installer file.

Windows Installer error message: Error opening installation log file. Verify that the specified log file location exists and that you can write to it.

Windows Installer file: C:\tmp\New Folder\x64\setup\SqlSupport.msi
Windows Installer log file: C:\Program Files (x86)\Microsoft SQL Server\100\Setup Bootstrap\Log\20090707_205326\SqlSupport_Cpu64_1_ComponentUpdate.log

Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.1600.22&EvtType=0xFB92A9BB

=====================================

I looked at the log folder destination and administrators do have right access to it. When I click retry, the installation hangs again.

Author

Commented:
In the log file produced at an earlier attempt, I found this message:
Product: Microsoft SQL Server 2008 Setup Support Files (English) -- Error 1402. Could not open key: UNKNOWN\Components\1FA18F7974E099CD0AF18C3B9B1A1EE8\A72592FFDC44224349E589A131850400.  System error 5.  Verify that you have sufficient access to that key, or contact your support personnel.



Hope this helps
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
Thanks Sage, I tried the complete remove before, and I now tried installing from another account, but this did not help:

MSI (s) (DC:C0) [22:56:00:140]: Product: Microsoft SQL Server 2008 Setup Support Files (English) -- Error 1402. Could not open key: UNKNOWN\Components\1FA18F7974E099CD0AF18C3B9B1A1EE8\A72592FFDC44224349E589A131850400.  System error 5.  Verify that you have sufficient access to that key, or contact your support personnel.


Vitor MontalvãoIT Engineer
CERTIFIED EXPERT
Distinguished Expert 2017

Commented:
Dunno why you don't format that server and reinstall all from the begining. For me that server it's all messed up and you'll lost more time trying to fix it.

Cheers

Author

Commented:
Because it is a developer PC with 148 programs installed.
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:
Have you installed the necessary prerequisites before installing SQL Server 2008..

http://msdn.microsoft.com/en-us/library/ms143219.aspx
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:
Kindly check this one out:

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=336399

Seems like this bug was reported to Microsoft earlier.

And hope you try to install 64 bit version of SQL Server only right.

Author

Commented:
Sage, I do have installed the prerequisites, and the installation checker confirms with 6 out 6 passed. Then it needs to install only the SQL Server Setup Files, and hangs while doing that. Sometimes it does not hang, but displays an errror message as given above.

I do have access to connect, but could not find the feedback number you mentioned. Can you check the URL? When I click it, I log in and then it says the feedback can't be found. Can you otherwize paste the essence of it? Thanks!

Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.