Solved

cant install sql 2005

Posted on 2013-12-27
5
447 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Scenario:  You do full backups to a internal hard drive in either product (SBS or Server 2008).  All goes well for a very long time.  One day, backups begin to fail with a message that the disk is full.  Your disk contains many, many more backups th…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…

910 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

23 Experts available now in Live!

Get 1:1 Help Now