SQL 2008 and SQL Express 2005 Coexist

Posted on 2010-01-04
Last Modified: 2012-05-08
I have a server running on windows 2008 with SQL 2008, for some reason I need to install the SQL express 2005 to the same server, any expert have experience about this? any risk need to bear?

Question by:gcl_hk
    LVL 13

    Accepted Solution

    Yea, they co-exist fine.
    I have a environment running sql server 2008, express 2008 and express 2005.
    Some applications require specific version of express to run (ie: SQL 2005 databases are not compatibale with Sql 2008 databases - you cannot backup a sql 2008 db and restore it directly to sql 2005 express  etc...)
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    yes, they can coexist with no problems.
    the only setting you need to configure on both instances is the "max memory setting" to ensure they will not try to both fetch all the RAM, which would result in "paging", which would slow down both instances AND the server to almost "halting" ...
    LVL 30

    Expert Comment

    by:Reza Rad
    you can do this, you can install any instance of sql server you want
    but if you run under windows server 2008, so why you don't use sql server 2008 enterprise edition?, this is full feature

    LVL 5

    Expert Comment

    You can have as many servers  as you can installed with different versions on the same machine

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Suggested Solutions

    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 …
    Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    737 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

    20 Experts available now in Live!

    Get 1:1 Help Now