Solved

cant install sql 2005

Posted on 2013-12-27
5
443 Views
Last Modified: 2013-12-30
windows server 2008 r2 64 bit
when I run in the installer for sql express 2005 it fails.
I look through the error log for the install and it fails because it is denied permission to the registry key
here is an example of one

error 1402. Could not open key: UNKNOWN\Components\DEC74B4E79E7CB5469A8407B258B1502\EE3C5F35DE50038499B4052B0F5DF0EC.  System error 5.  Verify that you have sufficient access to that key, or contact your support personnel.

I go to the registry and give the user I am installing the sql express with full permissions and the install will then work up until it hits another registry key that it doesn't have permission to.  so then it fails again..
I have given myself permission to over 20 registry keys and then a new one will pop up everytime.   any ideas.....

on the other front, I have a corrupted install of sql 2005 express.... this is what I am trying to fix with the above process.  I have used the Microsoft fixit tool.  I have tried to uninstall it through ARP..     I can't get the program uninstalled or install on top of it...
no good backup of system state available.  I'm reading the next step is to reinstall the os and I really am trying to avoid that.
0
Comment
Question by:jamesmetcalf74
  • 3
  • 2
5 Comments
 
LVL 19

Expert Comment

by:Patricksr1972
ID: 39741815
Hi

Did you try to launch the installer "as administrator"?
0
 

Author Comment

by:jamesmetcalf74
ID: 39741958
yes
I have tried that... it doesn't work
uac turned off
0
 
LVL 19

Expert Comment

by:Patricksr1972
ID: 39741971
Do all these registry keys fall under one parent node? If yes, can you go apply full control for the parent node as well and try again?
0
 

Author Comment

by:jamesmetcalf74
ID: 39741980
they seem to but...
there are thousands of registry keys underneath it
have a look

hklm/software/microsoft/windows/currentversion/installer/userdata/s-1-5-18/components

if I propagate those security settings and some of the keys have other users attached to it...
ie... network, system
those permissions would get wiped and everything would become unstable
0
 
LVL 19

Accepted Solution

by:
Patricksr1972 earned 500 total points
ID: 39742027
I agree... i found a link from microsoft which offer 3 workarounds for your situation, please check which one is suitable for you.

There is one where they advise you to do give full control to the HKLM\Software\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Components\
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

To effectively work with Diskpart on a Server Core, it is necessary to write some small batch script's, because you can't execute diskpart in a remote powershell session. To get startet, place the Diskpart batch script's into a share on your loca…
A safe way to clean winsxs folder from your windows server 2008 R2 editions
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

708 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

18 Experts available now in Live!

Get 1:1 Help Now