Can I have SQL 2012 AND SQL Express 2008 R2 installed on the same machine?

  • I'm looking at removing the SQL Server 2008 R2 Developer Edition that I have installed on my machine (a Windows 7 Ultimate machine), and updating to SQL Server 2012 Developer Edition. I also have SQL Server 2008 R2 Express installed, using a named instance (SQLExpress). Can I have both installed on the same machine? (I'll want SQL 2012 to be the default instance.)

    Kindest Regards, Rod Connect with me on LinkedIn.

  • I don't see a reason why not.

    Personally I would keep the 2008R2 developer instead of Express, but that's just a personal view.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Yes. The most I ever had was SQL Server 2000, 2005, 2008, 2008R2 and 2005 Express and 2008 Express. That was six instances of various versions on one desktop. No issues at all.

    Now, that's a local development machine. The same thing in a production environment would be insane.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Thank you, Koen and Grant.

    Kindest Regards, Rod Connect with me on LinkedIn.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply