Wednesday, March 7, 2012

cannot install SQL Server Express, keep getting errors

I am trying to install SQL Server 2005 Express, but it fails.
SQL Server Setup has detected incompatible components from Beta version of Visual Studio, .NETFramework or SQL Server 2005. Use Add or Remove to

I had earlier installed Beta 2 Version of Dev Studio 2005 and SQL Server 2005 Beta 2. I also had DevStudio 2003 and SQL Server installed. I have gone through and un-installed everything, but I keep getting this error.

I have also tried
msiexec /x {2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}
msiexec /x {2750B389-A2D2-4953-99CA-27C1F2A8E6FD}
Both of these un-install start, but fail with error messages.

Would appreciate if anyone can help.

Saleem Yusuf
Saleem_Yusuf@.hotmail.com

Try the following.
1. Uninstall all visible Beta components in Add/Remove Programes.

2. Detect the Beta components infromation in the the log file located in %Program Files%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetupNo_%machinename%_Core(Local).log.

3. Search the whole registry keys, remove those registy keys related to those Beta components. This is time-consuming.

4. Kill all Beta SQL Services (including SQL, OLAP, RS, SQLBROWSER, SQLAGENT, etc.) if they are existing with command sc.

5. Reboot the machine.

6. Start Setup again.|||I looked at the log and tried to uninstall old version, but it does not exists.
However, in the logs, I saw a version number and seach registry. They are many entries of SQL Server Express. I deleted some of them, but no luck yet. I am quite sure if I get rid of all the old registry setting, it should fix the problem.
Thanks for your help,

Saleem|||Problem fixed. I can now install SQL Server Express. Thanks for you help.
This is what I did.
Looked in file \Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG.
It had referecne to other log files. I opened one of the files, HostName_core.log
(notepad C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0012_<My_HostName>_Core.log)

This file had multiple reference to older versions of SQL Server Express. Example
Product "{2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06
The Product Name is "Microsoft SQL Server 2005 Express Edition CTP"

First I tried to uninstall, (MsiExec.exe /x {2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}). Un-install failed.

Then I searched for 9.00.1399.06. I found multiple entried. I deleted them all.
After that I was able install SQL Server Express.
|||

I tried 3 other fixes on other forums (asp.net,etc.) and this is the only one that worked.

My log file had a similar message. However, I deleted the entries related to the older version (in the case above, that would be 9.00.1116); not the later or "expected at least" version (9.00.1399.06).

With this fix, I did not have to remove .net 1.0 beta or .net 1.1

|||Thanks for posting - that worked for me too - I had just spent my own money buying VS2005 Pro and couldn't install SQL Express because previously installed beta stuff was fouling up the install.

Perhaps the SQL guys at MS could revise the install script in future releases to 'clean up' before installing... Just a suggestion.

Anyway, just re-installed trhe whole .Net DVD and it's running now, so thanks!

Mark

No comments:

Post a Comment