Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question
add comment

2 Answers

up vote 2 down vote accepted

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

share|improve this answer
2  
You can install SQL Server as the default instance, then any other install as a named instance. All Express installs are named instances and I don't think there is a limit on how many you can install (express or otherwise). It would be available resources that would define this upper limit. Also if you install SQL Server full version, that management studio can be used to administrate your express versions –  Wayne Jan 17 '10 at 4:01
add comment

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)

share|improve this answer
    
Jim B: Voted you up since the information on minimizing admin overhead is very helpful. Thanks. –  jmsmcfrlnd Jan 17 '10 at 15:27
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.