July 15, 2010

Rule SQL Server 2005 Express tools failed.

When installing Sql server 2008, sometime user gets following error.

Rule "SQL Server 2005 Express tools" failed.

The SQL Server 2005 Express Tools are installed. To continue, remove the SQL Server 2005 Express Tools.

Solution:

By following the steps described you can also have both sql server 2005 and 2008 installed on the machine at the same time. The trick is simple, just change a registry directory name of the sql server 2005 studio with registry editor. After the installation, you can then change it back.

1. Go to Windows > Run, enter “regedit” and click ok.
2. Browse to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsft SQL Server\90.
3. Rename “90″ to something else, like “old”

You can now rerun the process in the Sql Server 2008 Express installation wizard. After installation completed, you will notice that the old Sql Server 2005 doesn’t run when you try to launch it. No worry, to fix it you can change the newly created directory “90″ to “70″. Then change “old” that you changed from “90″ before back to “90″. It should now work for both Sql Server 2005 and 2008 Studio Express

Originally found on
smallworkaroundsd(dot)blogspot(dot)com/2009/08/can-uninstall-sql-server-2005-express.html

38 comments:

Anonymous said...

Thanks a lot. it worked like a charm.

Dave said...

Works for me too.. Good job =)

Dave said...

Worked for me too.. Good job =)

Nirav N Soni said...

an excellent trick.... superb... thnx a ton....

Niket Bhatt said...

Thanks buddy it works..........

Niket Bhatt said...

Thanks buddy It works :)

lifeasyoutakeit@blogspot.com said...

thanks a lot ..it really works :)

lifeasyoutakeit@blogspot.com said...

thanks a lot - it really helped :)

Anonymous said...

This worked perfectly! Thank you so much.

Anonymous said...

for 64 bit operating sys tem do this in wow6432Node

Naveen Bhat said...

Thank! it saved my time...:-)

Technology Freak said...

Thanks a lot!

Anonymous said...

Genius!

David Fusco said...

Excelente!

Anonymous said...

Note that for 64bit installs you have to rename:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsft SQL Server\90

The one listed in the article is there, but empty and has no affect on this issue.

Anonymous said...

T.Q. Dear.

RicardoPDV said...

work fine thanks

Anonymous said...

Really Helps

Unknown said...

thank u very much , it is a very excellent trick

Anonymous said...

Worked for Me too. Thanks for the great tip! :)

Hemant said...

thanks, this works.

Anonymous said...

Thank you!

Anonymous said...

you are god !

Anonymous said...

Thanks...Your suggestion worked...

Anonymous said...

Fanny Tastic....

Lino Garcia Vallejo said...

Excellent workaround!! Save my day

Anonymous said...

thanks a lot..

Anonymous said...

Thanks a lot bro!!!
wrked for me..!!
may god speed you..

Anonymous said...

Thanks a lot. What was MS thinking?

Anonymous said...

Muchas gracias por el tip. Saludos

Anonymous said...

You save me all day, man!
Thank so much about this :-D

Hoàng An said...

You save me all day man,
Thanks for this :-D

Hoàng An said...

You save me all day man,
Thanks for this :-D

Anonymous said...

Keka sir , Your great you solved my problem thanks you very much....

Regards,
Pr@WIN

Anonymous said...

Yaaa.....grt trick......worked for me....thankx a ton.

Sameer said...

Thanks. Awesome.

Anonymous said...

THANKS A LOT x10 :)

Anonymous said...

Thank you very much from the bottom of my heart.