Does SQL Server 2008 Standard Support Named Instances ?

Question

Hi,

Has anyone tried to install a default and a named instance in SQL Server 2008 Standard ?

I heard named instances is only available in Enterprise edition.

Please advise.

TIA !

Answer 1

Named instance is available in all editions(EXPRESS , ENTERPRISE , STANDARD , DEVELOPER) of SQL server.
Typically You can have 16 named INSTANCE of SQL standard edition in a single machine.

SQL Server 2005 Enterprise or Developer supports 50
SQL Server 2005 Other Editions supports 16
SQL Server 2008 Enterprise 50
SQL Server 2008 Other Editions supports 16

---

Thanks, Leks

Answer 2

Hi,

The reason why I asked about the above was because when I was reading the Microsoft SQL Server 2008 : Implementation and Maintenance Self-paced Training Kit by Mike Hoten, I noticed this note :

NOTE MULTIPLE SQL SERVER INSTANCES
Only SQL Server 2008 Enterprise supports the installation of multiple instances on a single machine.

Answer 3

Can you get me the link for this page ? I am not sure why this has been written like this !!
AFAIK , standard supports up to 16 named instances.

---

Thanks, Leks

Answer 4

It's a microsoft book. Not web page.

 

http://www.microsoft.com/learning/en/us/book.aspx?ID=12858&locale=en-us

Answer 5

I can confirm this, book says:

Only SQL Server 2008 Enterprise supports the installation of multiple instances on a single machine.

and

SQL Server supports up to 50 instances installed on a single machine; however, only

the Enterprise Edition has multi-instance support.

 

Answer 6

Hi,

Please refer to http://msdn.microsoft.com/en-us/library/cc645993(SQL.100).aspx

According to this document, standard version supports multi-instance.

Please try to instance multiple instance on a single machine, I think it will succeed.

 

---

This posting is provided "AS IS" with no warranties, and confers no rights.

Answer 7

I found corrections from Microsoft Press here just in case some one needs the answer: http://support.microsoft.com/kb/968609

---

Sunshinesvn

Answer 8

Nice find. I was researching each bit I thought sounded suspect.

Thanks for the link!!!

Anyone have thoughts on Page 12 where they state the Maximum Size of a SQL Express DB to be 4 GB?

I see 10 GB all over the web. Is that correct? with only Compact still at 4 GB???

---

Chris Jennings