Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6577
  • Last Modified:

SQL Server 2008 Setup Hangs

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
petitbarzun
Asked:
petitbarzun
  • 7
  • 5
  • 2
3 Solutions
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
WOW.
Looks like format will be better. At least you gonna start with clean installation.

Good luck.
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
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
 
petitbarzunAuthor Commented:
I will do this today and let you know, thanks
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
petitbarzunAuthor 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.
0
 
petitbarzunAuthor 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
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
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
 
petitbarzunAuthor 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.


0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
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
 
petitbarzunAuthor Commented:
Because it is a developer PC with 148 programs installed.
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Have you installed the necessary prerequisites before installing SQL Server 2008..

http://msdn.microsoft.com/en-us/library/ms143219.aspx
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
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
 
petitbarzunAuthor 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!

0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
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
 
petitbarzunAuthor Commented:
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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 7
  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now