Share via

SQL Server 2008 Express (Registry Error)

  • Article
  • 07/30/2008

Question

Wednesday, July 30, 2008 11:56 PM

I'm trying to install SQL Server 2008 Express on my Windows XP Pro machine and I've already been through the loops of having .net 3.5 (and ended up needing .net 3.5 SP1 Beta). Now my last, and hopefully final, issue is to fix the following error:

 

When I begin my install SQL 2008 runs "Setup Support Rules" and I fail on the last step which is labelel 'Consistency validation for SQL Server registry keys'.

"Rule 'Consistency validation for SQL Server registry keys' failed". The SQL Server registry keys from a prior installation cannot be modified. To continue, see SQL Server Setup documentation about how to fix registry keys.

 

1.) I can't find the documentation

2.) How do I fix this?

 

Note: I did have SQL 2005 Express installed which I uninstalled prior to my attempt of installing SQL 2008 Express

 

Thanks,

 

James

All replies (26)

Tuesday, August 26, 2008 12:03 AM ✅Answered

Having just installed Visual Studio 2008 on my XP Pro, I could not install SQL Server 2008 due to Registry Key error :

 

AclPermissionsFacet Checks if the SQL Server registry keys are consistent.

 

It turns out that Sql Server 2008 will not install if you have already installed VS 2008 due to SQL server 2005 packages that get installed.

 

To fix this follow above instructions and make sure you remove ALL instances of 2005 related SQL components with add/remove programs. 

 

If you are planning to use Visual Studio 2008 and SQL Server 2008 then INSTALL VS 2008 FIRST !!!

 

Thanks to forum for help.

Thursday, July 31, 2008 9:10 PM

I found an answer to my problem. Follow the intructions below....

 

1) Stop ALL SQL services - Control Panel - Administrative Tools -
Services - Right Click - Stop

  1. Double click each Service and note the "Service Name:xxx"

  2. From the Command line (Start - Run - CMD) type: sc delete xxx (enter
    the Service Name from above) Example: sc delete MSSQLSERVER - Do this
    for each SQL Service

  3. Control Panel - Add/Remove Programs - Select and Remove all Microsoft
    SQL Server programs

  4. From REGEDIT (Start - Run - REGEDIT) Back up your Registry Editor
    (Highlight My Computer - File - Export - Save)

  5. From REGEDIT go to folders: HKEY_LOCAL_MACHINE/ SOFTWARE/MICROSOFT
    then right click ALL Microsoft SQL folders and select DELETE

  6. From Windows Explorer go to Program Files then right click all
    Microsoft SQL folders and select DELETE

  7. ***THIS STEP IS OPTIONAL - I SKIPPED THIS STEP AND SQL 2008 Express Installed OK***

Run the Microsoft Cleanup Utility - remove all SQL programs

 

9) Reboot

  1. Install SQL Express 2008

Thursday, October 16, 2008 8:03 PM

Thanks James

It works fine. I did not delete the services, just stop the services, uninstalled all Microsoft
SQL Server programs and delete from the registry

regards
Dibakar

Monday, October 20, 2008 11:47 AM

I have this problem.

Monday, October 20, 2008 12:08 PM

sql server 2008 developer

Monday, October 20, 2008 12:31 PM

I have this problem.

1)Aclpermissionsfacet.(rule name)error

2)checks if the sql server registery keys are consistent (rule description)

3)sql server registry keys from a prior installation cannot be modified .to continue ,see sql server setup documentation about how to fix registry keys.

i have VS 2008 without sp1, and sql server express 2005,i stop all sql server (also labtop vaio  sony sql)service in services in control panel, then install service pack 1 VS 2008 ,then pass "consistency validation for sql server registry keys" that  report to me. and successfully install.

thank you .

Iam from iran- tehran -GIS software Eng.roozbeh noroozy.

roozbeh.n@gmail.com and @live.com

Friday, December 5, 2008 3:52 PM

I am getting this error when it is the first time install.... there is no sql running and not can be found in the registry when I run regedit.  Any suggestions?

 

Monday, December 8, 2008 11:22 PM

I stop in administrative tools services:"SQLAgent$VAIO_VEDB" and SQLAgent$MICROSOFTBCM services.my labtop is vaio manufactured by sony co.

 

Tuesday, December 16, 2008 4:32 PM | 3 votes

I was just installing tool and had the problem.  In the .\Microsoft SQL Server\100\Setup Bootstrap\LOG directory, I found a text file and found the Consistency validation logs in it.  It said the hive that was having a problem.  Using Regedit, right clicked the registry and added local administrators to the structure.

PHuhn

Thursday, December 18, 2008 4:30 PM

Trying to do step 6 but get an error on trying to delete.

Janet Heath

Thursday, December 18, 2008 4:33 PM

I am on a Windows XP Professional.

Janet Heath

Monday, April 27, 2009 8:22 AM

I am using SONY VAIO VGN-C150P and Windows XP Professional SP3.

The source of error was the running service named MSSQL$MICROSOFTBCM.

After stopping the service, I could install SQL SERVER 2008 without ERRORS.
No need to delete or play with registries.

Goodluck!

Wednesday, July 1, 2009 6:20 PM

For me it was access to a registry key.  I ran Sysinternals Procmon, filltered on Result=Access Denied to find the path.
I then edited the path permissions in RegEdit to allow Admin accounts full control.
Hope this helps.

Tuesday, July 21, 2009 1:35 PM | 1 vote

**********************   EVERYONE ,   PLEASE  READ  *****************

ALL  I  Had  To  Do  Was  STOP  EVERY   (and  i  do  m EVERY)  SQL  SERVICE ,  NOTHING  MORE.

I  Did  NOT  Do  Any  Removals  Of Any  Kind.

This  method  worked  on  win xp , SP3 , GUARANTEED  !

I  DID  NOT  HAVE  TO  DO  ANYTHING  TO  THE  REGISTRY  ,  NOT  ONE  SINGLE  CHARACTER.

I  BELIEVE  IN  FINDING  THE  QUICKEST  METHOD  FIRST ,  So  I  hope  this  discovery  helps  you  all.

 

techman2000 , out.

Monday, August 17, 2009 12:14 AM

i second techman2000 ... i also stopped all the services and the rules validated .. thanks techman2000

Wednesday, September 9, 2009 9:07 AM

How did you run Sysinternals Procmon?  Where is it?

Wednesday, September 9, 2009 6:42 PM

BUMP...
I've tried all answers here and still can't get SQL Server installed. My problem is I installed full Office Outlook Pro 2003 with Business Contact Manager and on top of that, I installed Office 2007 Pro Plus with Outlook. BCM never worked on 2007 (maybe because it wasn't preinstalled, but who cares. It never worked with 2003 anyway). And now, I cannot uninstall BCM 2003. I've already uninstalled, reinstalled Office 2003. Then tried to remove the update of BCM 2003 and that's where it all stops. Cannot uninstall it. Cannot reinstall it. Cannot repair it. Cannot remove it.

Perhaps because of the above, I cannot remove a registry key of Microsoft SQL Server which contains the following (and much more which I removed by hand):
Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server]

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MICROSOFTBCM]

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MICROSOFTBCM\MSSQLServer]

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MICROSOFTBCM\MSSQLServer\SuperSocketNetLib]

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MICROSOFTBCM\MSSQLServer\SuperSocketNetLib\Lpc]
"LPCVersion"=dword:08000332

It just won't get eliminated. I tried many tricks, including exporting and reimporting the key with a "-" (negative) sign in front of each or the top key. Both approaches.

Please Obi Wan Kenobi, you're my only hope...

Luis

Thursday, March 11, 2010 1:04 AM

This Really Works...

I have the same problem when try to install SQL Server 2008 Standart Edition in a OS Win7 (after uninstall mi old version SQL Server 2005)... and the registry key:
"HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\009" has values and
"HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\00A" was emty.
So, I do a copy from 009 to 00A (values Counter/Help);
And that's it!!!

Here we could find some values for diferent regional configurations (LCID), if we needed: http://javascripts.astalaweb.com/Ayuda/html/vsmsclcid.asp

Yo tenia el mismo problema cuando trate de instalar SQL Server 2008 Standart Edition en un OS Win7 (después de desinstalar mi vieja version de SQL Server 2005)... y la llave del registro:
"HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\009" tenía valores y
"HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\00A" estaba vacía.
Asi que hice una copia del valor 009 al 00A (valores Counter/Help);
Y eso es todo!!!

Acá podemos encontrar algunos valores para diferentes configuracione regionales (LCID), si los necesitamos: http://javascripts.astalaweb.com/Ayuda/html/vsmsclcid.asp

Best Regards...

Saturday, March 27, 2010 1:34 PM

Thanks Techman2000,

 

I read everything dow to your **** Everyone **** note so I tried it.  I checked services and MICROSOFTSQLMCB (or something like that) was running.  I stopped it, re-ran the installation checks and the registry consistenecy passed. 

 

Thanks

Monday, December 27, 2010 7:22 PM

James,

you omitted to add "sc delete  xxx" will work after you boot the system on safe mode

also, I recommend to do a regedit and  right click on the "HKEY_LOCAL_MACHINE" select permission, select advance and clear what youcan of the " Inherited from".

MAKE SURE YOU SC DELETE MSSQLMICROSOFT$BCM.

Good luck. 

Thursday, January 6, 2011 1:59 PM

I just had a similar problem, but with a fresh Windows Server 2008 R2 installation (nothing else installed yet):

My problem vanished after re-booting. When shutting down, two Windows updates had been installed...

So I guess that some (particular) Windows update packages waiting for being installed my also cause the installer to fail.

Vote here for a new Microsoft Connect feedback channel on Windows 7!

Saturday, May 21, 2011 3:12 AM

I need help. Everytime I run SQL Server 2008 R2 Express It doesn't seem to work. I have tried deleted the Microsoft SQL Server folder and all registry item related to SQL but no resolve.  Please help. After each install I get this directory structure but nothing elese: C:\program files\Microsoft SQL Server\Tools\.. I don't get anything else. Why?

Sunday, May 22, 2011 8:22 AM

What do you expect to get? SQL Server Express ist just a service. It doesn't have a GUI or some other visible parts.

I you want to access your SQL Server Express installation, you could write a small programm using ODBC, OLE DB oder .NET SQL Native Client to access your database SQL Server Express installation.

Or you might want to download SQL Server Express Management Tools to get SQL Server Management Studio, a tool to access SQL Server.

 

Vote here for a Microsoft Connect feedback channel on Windows - and win a better Windows!

Saturday, February 18, 2012 7:15 AM

I am using SONY VAIO ** vpceg2aen** and Windows 7 home basic sp1 64bit

The source of error was the running service named database,data agent,error problem

After stopping the service, I could install SQL SERVER 2008 without ERRORS.
No need to delete or play with registries.

plz msqlserver download ....

Saturday, February 18, 2012 7:16 AM

I am using SONY VAIO ** vpceg2aen** and Windows 7 home basic sp1 64bit

The source of error was the running service named database,data agent,error problem

After stopping the service, I could install SQL SERVER 2008 without ERRORS.
No need to delete or play with registries.

Or you might want to download SQL Server Express Management Tools to get SQL Server Management Studio, a tool to access SQL Server.

Tuesday, February 28, 2012 5:21 AM

techman2000 to the rescue!!!