Aaron Stebner's WebLog

Thoughts about setup and deployment issues, WiX, XNA, the .NET Framework and Visual Studio

How to fix problem installing SQL Express if SQL Server 2005 is already installed

How to fix problem installing SQL Express if SQL Server 2005 is already installed

  • Comments 9

<updated on June 3, 2005 - changed the product name from "SQL Server Tools Express" to "Microsoft SQL Server 2005 Tools Express Edition CTP" based on the full official name as it appears in Add/Remove Programs>

There is a known setup interaction issue with beta versions of SQL Server 2005 (codename Yukon).  There is a conflict between the SQL Tools that are installed with SQL Express 2005 Beta and the SQL Tools that are installed with the full SQL Server 2005 Beta.  If SQL Server 2005 Beta with SQL Tools is installed then SQL Express will fail, and vice versa. 

You can workaround this issue by doing one of the following:

Scenario 1 - Install SQL Express first

  1. Install SQL Express (as a standalone product or as a part of VS 2005 beta setup)
  2. Go to Add/Remove Programs and remove the product named Microsoft SQL Server 2005 Tools Express Edition CTP
  3. Install SQL Server 2005 Beta with SQL Tools

Scenario 2 - Install SQL Server 2005 Beta first

  1. Install SQL Server 2005 Beta without SQL Tools
  2. Install SQL Express (as a standalone product or as a part of VS 2005 beta setup)
  3. Go to Add/Remove Programs and remove the product named Microsoft SQL Server 2005 Tools Express Edition CTP
  4. Re-run SQL Server 2005 Beta setup and select SQL Tools

This workaround should work for the version of SQL Express that is included with VS 2005 beta 1 and VS 2005 beta 2.  This scenario is a known issue that the SQL team is planning to address before SQL Server 2005 releases.

 

  • As of now, i've installed SSE as part of VS 2005 beta 2. I'll try to install SQL Server 2005 April CTP and see what happens.

    Meanwhile, i had some problems with Express Editions, about which i posted here:

    https://blogs.msdn.com/astebner/archive/2005/05/27/422738.aspx

    Kindly check it out. Thank You.
  • Hi,

    I tried to install SQL Server 2005 April CTP. I selected the database services and the client components. Since, i had installed SSE as part of VS 2005 beta 2, the client components wouldn't install. I quit the setup.

    So as per scenario 1, should i uninstall SSE first and then try to install SQL server 2005 CTP?

    Would SSE get installed, when i install client components in SQL Server 2005 CTP?

    I had setup the quick start tutorials. What happens to them when i remove SSE?

    Thanks.
  • For scenario 1, you should uninstall only the SQL Server Tools Express item from Add/Remove Programs. I just checked on my machine and the full name is "Microsoft SQL Server 2005 Tools Express Edition CTP".

    When you install SQL Express, there are actually several different MSIs that get installed, but this is the only one that you should need to uninstall before trying to install SQL Server 2005. You shouldn't need to worry about any other reconfiguration.

    Please let me know if this works for you....
  • Ok, i'll try it. I hope my quick start tutorials don't get messed up. I'll let you know what happens...
  • Yes! It worked like a charm! Thank You.

    Just to confirm, mine was scenario 1. I had installed SQL Express as part of VS 2005 beta 2 installation. As a result, the client components wouldn't get installed during SQL Server 2005 CTP installation. So, i went to Add/Remove Programs and removed 'Microsoft SQL Server 2005 Tools Express Edition CTP' and then installed SQL Server 2005 CTP with Database services and Client components.

    One needs to be careful here as there are 2 entries in the Add/remove programs - 'Microsoft SQL Server 2005 Tools Express Edition CTP' and 'Microsoft SQL Server 2005 Express Edition CTP.' Until the last moment, i was under the notion that i should remove the later. That was why i was worried about quick start tutorials and stuff. But after reading your instructions repeatedly, i got things right! Infact, until i realised that the instructions for scenario 2 was quite vague for me. But now it's all clear!

    Thanks again, Aaron!
  • Hey, that is great news! I'm glad to hear that this worked for you. That is a good point too - for anyone else trying these steps place make careful note of the full name of the product that needs to be removed in Add/Remove Programs. SQL Server and SQL Express create several items in Add/Remove Programs, and you only need to remove the one named "Microsoft SQL Server 2005 Tools Express Edition CTP" for this workaround to work correctly. Uninstalling the other pieces of SQL Express may cause other programs (like the quickstarts) to stop working correctly.
  • I've attempted to remove everything to do with SQL Express and no longer have anything in the Add/Remove Programs for MSSQL.

    When I attempted to install Beta 2 I am told that the old tools are still there but they don't appear in the Add/Remove programs. I've then backed out Beta 2, attempted to reinstall SQLExpress but again am told the tools are already present. They still don't appear in Add/Remove programs. Any idea how I might get rid of them?

    Thanks
    Stephen
  • Hi Stephen,

    I would suggest that you first try the VS 2005 beta cleanup tool located at http://go.microsoft.com/fwlink/?linkid=47065.

    If that doesn't work, I think the Windows Installer Cleanup Tool (located at http://support.microsoft.com/default.aspx?scid=kb;en-us;290301) might also help. Can you try to download it and run it on your system and see if it lists any SQL 2005 products? You will need to make sure that all of the items listed at http://blogs.msdn.com/astebner/archive/2005/06/14/429203.aspx are uninstalled from your system, so if you see any of them in the cleanup tool's product list, make sure to remove them.

    Hope this helps!

  • I spent many hours trying to uninstall all the beta components and this tool (below) did the trick. Thank you.

    If that doesn't work, I think the Windows Installer Cleanup Tool (located at http://support.microsoft.com/default.aspx?scid=kb;en-us;290301) might also help. Can you try to download it and run it on your system and see if it lists any SQL 2005 products?
Page 1 of 1 (9 items)
Leave a Comment
  • Please add 1 and 8 and type the answer here:
  • Post