Solved

SQL Server 2008 Setup Hangs

Posted on 2009-07-01
16
6,422 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
  • 7
  • 5
  • 2
16 Comments
 
LVL 45

Expert Comment

by:Vitor Montalvão
Comment Utility
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
Comment Utility
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
Comment Utility
I will do this today and let you know, thanks
0
 
LVL 1

Author Comment

by:petitbarzun
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 45

Expert Comment

by:Vitor Montalvão
Comment Utility
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
Comment Utility
Because it is a developer PC with 148 programs installed.
0
 
LVL 57

Expert Comment

by:Raja Jegan R
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

743 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now