Solved

SQL Server 2008 Setup Hangs

Posted on 2009-07-01
16
6,478 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
0
Comment
Question by:petitbarzun
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 5
  • 2
16 Comments
 
LVL 50

Expert Comment

by:Vitor Montalvão
ID: 24772891
WOW.
Looks like format will be better. At least you gonna start with clean installation.

Good luck.
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24779488
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..
0
 
LVL 1

Author Comment

by:petitbarzun
ID: 24783290
I will do this today and let you know, thanks
0
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 
LVL 1

Author Comment

by:petitbarzun
ID: 24797225
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.
0
 
LVL 1

Author Comment

by:petitbarzun
ID: 24797642
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
0
 
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 150 total points
ID: 24799820
Check this out for similar errors:

http://support.microsoft.com/kb/236427

I suspect an improper installation occured earlier and hence it hangs after that.

Use windows installer cleanup utility to remove SQL Server installation components completely.

http://support.microsoft.com/kb/290301

Remove the installation completely and try the installation from some other admin user in your system.

Hope this helps
0
 
LVL 1

Author Comment

by:petitbarzun
ID: 24804591
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.


0
 
LVL 50

Expert Comment

by:Vitor Montalvão
ID: 24805116
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
0
 
LVL 1

Author Comment

by:petitbarzun
ID: 24805171
Because it is a developer PC with 148 programs installed.
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24811511
Have you installed the necessary prerequisites before installing SQL Server 2008..

http://msdn.microsoft.com/en-us/library/ms143219.aspx
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24811558
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.
0
 
LVL 1

Author Comment

by:petitbarzun
ID: 24812056
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!

0
 
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 150 total points
ID: 24816016
Contents below as per your request:

Description
With build 1300.13 on Itanium, cannot install database engine or analysis services - and cannot uninstall either. Logs available at \\varmints\public\Carlr\logs

<excerpt from log>
MSI (s) (EC:70) [11:19:12:649]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\\Setup 3: 161
Info 1402. Could not open key: HKEY_LOCAL_MACHINE\\Setup. System error 161. Verify that you have sufficient access to that key, or contact your support personnel.
MSI (s) (EC:70) [11:19:12:649]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\\Setup 3: 161
Info 1402. Could not open key: HKEY_LOCAL_MACHINE\\Setup. System error 161. Verify that you have sufficient access to that key, or contact your support personnel.
</excerpt from log>
Comments
The title of registry key is red herring.    We can ignore it.

Carl Rabeler (customer) and I spent a lot of time on this case behind scene. In summary cleaning of an old build and installing of a new Katmai repeated several times due to several failures. None of them is related to setup functionality, but it jeopardized confidence. The good news is that we have some improvement done already in CTP6 Refresh that supports repairing of a failed install, so customers can continue to work around the failed install instead of completely uninstalling one.

Here is the detail of what happened.

Initially the uninstall failed in SqlRun_SQL.msi CA RestoreSetupParams.

<Func Name='RestoreSetupParams'>
&&
Error Code: 29527
MSI (s) (6C!F8) [13:36:03:912]: Product: Microsoft SQL Server 2008 (64-bit) -- Error 29527. The setup has encountered an unexpected error in datastore. The action is RestoreSetupParams. The error is : Source File Name: datastore\machineconfigscopeproperties.cpp
Compiler Timestamp: Thu Jan 31 03:20:06 2008
     Function Name: SqlInstallConfigScope.ProductCode
Source Line Number: 186

I started to debug that CA, and the CA just run fine. Then I stopped the debug, and back to repeat Katmai uninstall from Add/Remove control panel.    It succeeded and Katmai was uninstalled. In conclusion I didnt do any tweak, and uninstall succeeded. The machine was ready for Carl Rabeler to install a new build. What happened after that is:

"    First attempt of install  failed on SSCERuntime package because a previous one Microsoft SQL Server Compact 3.5 SP1 Beta English was remained and affected its installation. We uninstalled the failed one, cleaned up the machine, and ready for the next install.
"    Second attempt of install  failed on SQL Engine configuration as it reported network path was not found. The error message suggests some network glitch, but we dont have further log information to confirm what the real cause is.    We uninstalled the failed one, cleaned up the machine, and ready for the next install.
"    Third attempt of install  Succeeded.

It is not a good experience with the customer. One of reasons is that we didnt support Repair of a failed install in CTP6.    This has been changed in CTP6 Refresh that supports repairing, and can have customers avoid this kind of situation like this case.
 Posted by Microsoft on 4/11/2008 at 5:27 PM
I have resolved this issue a duplicate of one of our work items tracking making this experience better in the future. I believe Yuhong helped you work around your problem but if you are still having issues please reactivate this bug and provide details on your current issues.

Thanks,
0
 
LVL 1

Accepted Solution

by:
petitbarzun earned 0 total points
ID: 24835769
Solved! I have upgraded to Windows 7, this repaired the registry enough to enable me to install SQL Server

Thanks for the support
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I'm a big fan of Windows' offline folder caching and have used it on my laptops for over a decade.  One thing I don't like about it, however, is how difficult Microsoft has made it for the cache to be moved out of the Windows folder.  Here's how to …
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question