SQL2008 Express Edition: two instances on same computer?

Question

Can we installed two instances of Express edition? I have one instance installed and when I try to install 2nd one, Product Key page/optionbs is grayed out (Specify Free Eidtion / Enter Prod. Key)

Is it by design or due to something I am missing here? Thanks.

score 2 · Answer 1 · edited Aug 02 '17 at 13:25

2

The maximum limit to the number of SQL Server Express instances is 16 on the same machine. These instances must be uniquely named for the purpose of identifying them.

edited Aug 02 '17 at 13:25

tom redfern

30,562
14
91
126

answered Apr 04 '12 at 16:01

Diego

34,802
21
91
134

May you share a link to the source of that quote? Thanks. – binki Feb 19 '14 at 16:47
by googlin there are many links, like http://www.symantec.com/business/support/index?page=content&id=TECH62586 – UnDiUdin Nov 17 '14 at 11:19

score 2 · Answer 2 · answered Apr 04 '12 at 16:01

Yes you can install Sql Express for multiple instances.

To install a new instance, please make sure you do a Custom installation and set a different name for the new instance.

The full Sql Express features can be found here. As you can see, Multi-Instance support is set to YES

SQL2008 Express Edition: two instances on same computer?

2 Answers2