Solved

cant install sql 2005

Posted on 2013-12-27
5
458 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 23

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 23

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 23

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

Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
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.
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
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…

705 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