SQL Server 2005 and SQL Server Express 2008 installed on same server

Posted on 2011-05-12
Last Modified: 2012-06-27
I currently have a situation were I need to install SQL Server Express 2008 on a server that already has SQL Server 2005 installed on it. Please can you advise if this is recommended and what are the best practices for such an install.

Thanks in advance for you're assistance
Question by:MartynLawson
    LVL 16

    Accepted Solution


    You can do side by side install SQL Server 2008 and 2005. No consequence of installing both. It really depends on what you want.
    for more information please review the following:

    LVL 18

    Assisted Solution

    there can be only one default instance per server, you'll have to install a named instance, other limitations are edition wise.
    LVL 9

    Assisted Solution

    There is no issue of running SQL Server 2005 side by side with 2008. I use 2005, 2008 and R2 on the same box in my laptop. Is this a prduction server? Then you have to consider the resource allocation as there can be perfomance issues you will run into.
    LVL 21

    Assisted Solution

    by:Alpesh Patel
    Its' not an issue.
    LVL 1

    Author Closing Comment

    Thanks for all your comments. I've successfully installed the SQL 2008 on the server.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    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 …
    New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
    This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
    This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

    755 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

    24 Experts available now in Live!

    Get 1:1 Help Now