Can I install a new instance of SQL Server 2008 Express on a machine that is already running an existing instance of SQL Server 2005 Express?

Posted on 2009-05-01
Last Modified: 2012-05-06
The server at work is running an instance of SQL Server 2005 Express and I want to build a new database on it using SQL Server 2008 Express. Can I have both running or will the different versions cause a conflct? The server is running Windows 2003 Business Server operating system
Question by:Rob4077
    LVL 14

    Accepted Solution

    Although you should have no problem running a 2005 instance of the database engine beside a 2008 instance, The tools are installed into a shared directory, so you can't have two versions of the tools installed. Fortunately, the 2008 tools are backwards-compatible.

    Before installing the 2008 tools, you need to remove any and all "shared" components from 2005. Try going to your Add/Remove programs control panel, find Microsoft SQL Server 2005, and click "Change." Then choose "Workstation Components" and remove everything there (this will not remove your database engine).

    I believe the 2008 installer also has an option to upgrade shared components only.
    LVL 31

    Expert Comment

    I think there shouldn't be any problem if you are installing named instance of SQL 2008 express edition. Link provided by wolfman007 is good, worth to refer.

    Author Comment

    Thanks for the comments and tips. Appreciate the link too wolfman007

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now