Home / server / Questions / 103452
Accepted
qxotk
Asked: 2010-01-17 19:04:16 +0800 CST

Can I install MS SQL Server Express 2008 on the same box as MS SQL Server 2008?

  • 772

I am a developer and I wanted to ensure that I have a full MS SQL Server at my disposal if need be.

Can I also install MS SQL Express 2008 on the same box, so I can do small dev projects using SQLExpress instead of MS SQL Server?

sql-server-2005 installation sql-server-2008

2 Answers

  1. Best Answer

    Yes. You will need to install them as Named Instances (say \SQLEXPRESS and \SQL2k8) but they will work just fine.

    • 2

  2. Yes you can, sql express will install as a named instance. However you can also install up to 16 instances of the full sql server (standard) on the same box. There is no development diference between sql server express and standard. The list of features supported by edition is here. I would probably reccomend sticking with just the full SQL server to cut down on system administration headaches as the express edition service packs are usuallly different than the sql ones (althought they provide the same functionality)

    • 1