SQL Server 2005 Express Installation Problem: Incompatible components from beta version of .NET Framework

SQL Server 2005 Express Installation Problem: Incompatible components from beta version of .NET Framework

• Tone Southerland

  I had the same message.
  1. uninstall any sql 2005 develop or express editions
  2. rename the folder "C:\Program Files\Microsoft SQL Server\MSSQL.1" to
  something like "MSSQL.1-Old"  (any database you would have created would still be in the "..mssql\data" folder.
  
  3. re install mssql express (it should work fine)
  
  4.  you may need to copied any previous database into the new folder and reattach them.
  
  good luck!

  
  

• rachakunta

  Thank you for sharing this -- I was having the same uninstall problems, and after deleting the product keys under the ...Installer/UserData section the install worked now.

  Thanks again

  
  

• XiNO

  Yes, Beta 2 version of .NET Framework 2.0 is the wrong version.  Did you install the Sept CTP version of SQL Express   If so, please re-visit the page and read carefully the set of Instructions near the bottom of the page, it should give you a link that points you to the .NET Framework 2.0 you need to install.

   

  
  

• Sean Stapleton

  You're great!!!

  I Faced the same problem and your solution worked well.

  Thanx a lot

  Lorenzo

   

  
  

• quincin

  I maybe late but my specific solution to this problem was to uninstall the SQL NATIVE CLIENT. thats all i had to do and my installation worked fine.
  
  

• AeQuitaZ

  Hi Steve,
  I cannot answer your question. I just need more information on the solution you found to your problem. I am in about the same situation as you were and want to know if you would suggest me to remove entries in the registry, move that find hazardous. I would not like to have to reinstall Windows XP Pro and risk to lose a lot of work.
  When I try to install SQL Server 2005 September CTP, the setup program gives me the following error message:
  "SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme."
  Some other question arise from this message:
  1- Where can I find the "SQL Server 2005 Readme"
  2- Since the Add or Remove Programs does not display any SQL software, what should I do
  3- Would it be best to just wait for November 7th, expected date for the final release
  Thank you for your time and wish you good luck.
  J.T.
  

• hulle

  Agree - I just removed the sql native client and now the installation runs without any error.
  

• Blue Stone Post

  I'm having the same problem as Scott, except with the 2.0 version Not the beta.  Using Windows XP SP2. The SQL Express install tells me I have incompatible programs but doesn't identify exactly which software it doesn't like. (It knows what the problem is but it doesn't tell me - that wouldn't seem to difficult for Microsoft to correct.) The Build Uninstall wizard tells me I have a component that needs to be uninstalled:  "Microsoft SQL Server Tools Express Edition CTP, product Level 9.00.1116 - but when I click next I get a message that there is nothing beta or .Net component to uninstall. But I get the same incompatibility message when I go back to SQL 2005 install. I run the BUW again and again with no change.  I have spent hours unstalling programs one by one, reinstalling .Net 2.0 (the new version, Not the beta), etc., and then retrying the SQL 2005 install.  No luck.  I have followed the instructions but keep getting the "Visual Studio Beta or .Net incompatible" message.  I'm out of programs to uninstall, even removing MSDE and SDKs, SQLXML 3 and 4, Web Matrix, who the heck knows which program it doesn't like.  Followed this by manually deleting from "Program Files" (risky) all files and directories that have "SQL" in them.  I may have to reinstall Windows now.  Best case is I have to reinstall a lot of programs, then reconfigure them for my existing projects. Really disgusted. 
  
  HOURS LATER:  For what it's worth, I went through the Registry and deleted about 5 keys returned by a search on the string "9.00.1116" - the offending build number.  Seems to be installing Ok now. 
  
  Will I be able to reinstall the other "Beta" software now   I want to use the Visual Web Builder.  Thank you.

  
  
  

• Sunil Sarlaya

  Without knowing all the details, I'd suggest doing a complete uninstall of sql server and .net framework 2.0.  In the Readme, look for the section "Build Cleanup Wizard" and see if any of it applies to your scenario. 

  Then makes sure to install the correct version of .NET Framework 2.0, and install SQL Server 2005.  I know this sounds tedious, but please remember this is still a beta product.

  
  

• Udhaya Kumar D

  I actually did downloaded a copy of the latest .net 2 from the page you mentioned.  Installed it and installed sql 2005 and still get the same error. 
  
  I am pretty much clueless now.
  
  
  
  

• Claus Stahnke

  I found this information from my install log:

  Before this, I deleted the key under products: {2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F} and {2750B389-A2D2-4953-99CA-27C1F2A8E6FD} It turns out:

  Loaded DLL:C:\WINDOWS\system32\msi.dll Version:3.1.4000.2435
  Error: MsiGetProductInfoW INSTALLPROPERTY_VERSIONSTRING failed for Product Code {2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}
  MsiGetProductInfoW INSTALLPROPERTY_INSTALLEDPRODUCTNAME returned 1608
  MsiQueryProductState returned 1
  Error: MsiGetProductInfoW INSTALLPROPERTY_VERSIONSTRING failed for Product Code {2750B389-A2D2-4953-99CA-27C1F2A8E6FD}

  For the undeleted key: "{44568A1C-53F6-49A5-A163-CD9ADC0F76D5}" it turns out.

  MsiGetProductInfoW INSTALLPROPERTY_INSTALLEDPRODUCTNAME returned 1608
  MsiQueryProductState returned 1
  Product "{44568A1C-53F6-49A5-A163-CD9ADC0F76D5}" versioned 2.0.50727 is not compatible with current builds of SQL Server.Expected at least version: 2.0.50727.42
  The Product Name is "Microsoft .NET Framework 2.0"
  Loaded DLL:C:\WINDOWS\system32\msi.dll Version:3.1.4000.2435
  Error: Action "PerformSCC

  I guess I did the wrong thing to delete the first two keys. Could you help me out please Thank you so much

  
  
  

• Fabio Cozzolino

  Thanks friends, it was usefull for me
  

• Pat_ON

  Unfortunately your suggestion doesnt work with yesterdays release. I made the mistake of installing Visual Studio first. Now im hosed.
  
  
  
  Its about an hour later now and I resolved the issue. I made several attempts using the manual MsiExec.exe /I{product id} approach. I believe this did remove some of the peices I was missing. However, there were still remnants of SQL 2005 Beta 2 in the registry. Ultimately I used the {product id} provided in the SQL installer logs to locate the offending registry information. Once I deleted the information, my install worked perfectly. I know Microsoft frowns on editing the registry directly, so use caution if you attempt this.
  
  I probably deleted more information than I needed to. Ultimately, I think the problem registry information was located in the installer section of HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Windows/Installer/UserData/someuser/Products
  
  Good luck. I hope this is helpful
  
  

• tcw

  Thanx friends.

   

  I have the same problem and resolve it now.

   

  
  
  
• SQL Server 2005 Express Installation Problem: Incompatible components from beta version of .NET Framework