Solved

cant install sql 2005

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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Database maintenance 36 134
Exchange password change on mobile 2 94
Master DC completely died 15 66
Migrate SQL 2005 DB to SQL 2016 4 20
You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

739 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