Reputation: 3
SQL2008 Express Edition: two instances on same computer?
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.
Upvotes: 0
Views: 5805
Answers (2)
Reputation: 36146
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.
Upvotes: 2
Reputation: 891
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
Upvotes: 2
Related Questions
- Is it possible to run multiple instances of SQL Server on the same machine
- Can we install Express edition and Standard edition of SQL Server on same PC User?
- Limitations of Running Multiple Instances of MS SQL EXPRESS
- Using two SQL Server instances
- How can I setup an application that uses SQL Server 2008 Express on a machine that already has SQL Server 2005 Express
- SQL Server 2008R2 Express and LocalDB on same machine
- SQL Server 2008: multiple instances on single computer
- Two Instances of Sql Server (2005 and 2008)
- Can SQL Server 2008 Express exist with SQL Server 2000 on the same server?
- Use a own instance for SqlServer Express?