Solved

cant install sql 2005

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

Expert Comment

by:Patrick Bogers
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 20

Expert Comment

by:Patrick Bogers
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 20

Accepted Solution

by:
Patrick Bogers 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

A procedure for exporting installed hotfix details of remote computers using powershell
A safe way to clean winsxs folder from your windows server 2008 R2 editions
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
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…

820 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