SQL 2008 Express and SQL 2008 Standard on same server

Posted on 2011-05-03
Last Modified: 2012-08-13
I have a machine with Server 2008 Standard, 32 bit, that has SQL 2008 Express installed. The SQL 2008 Express was installed when I upgraded to ArcServe Backup version 15.  This machine will also need SQL 2008 Standard or SQL 2008 Workgroup to run the new version of our accounting program.  Will there be a problem with SQL 2008 Express and SQL 2008 Standard or Workgroup being on the same machine?
 Also, can I run SQL 2005 Standard (instead of SQL 2008 Standard) with SQL 2008 Express?

Question by:cja-tech-guy
    LVL 25

    Expert Comment

    by:Lee Savidge
    There shouldn't be a problem with that. I have a machine with SQL 2008 on it and SQL 2005 express and they don't interfere with each other. The Express install was installed to a named instance rather than the default instance so there shouldn't be any issues.

    Author Comment

    Can I run SQL 2005 Standard with SQL 2008 Express on the same server?
    LVL 25

    Accepted Solution

    Yes, you can just put each database version in it's own named instance and they won't affect each other.
    LVL 32

    Assisted Solution


    Yes you can

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
    SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    760 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

    7 Experts available now in Live!

    Get 1:1 Help Now