Maximum number of connections

Hi,

Could somebody tell what is the maximum number of concurrent connections that are supported in sql server 2005 developer edition?

thanks

SQL Server allowed 32767 connections per instance in SQL 2000. I don′t think they lowered it down. With 16 instances you could theoretically come up to 524272 connections (which is sort of unbelievable). I don′t know if your question has only an academic flavour or how many can be instantiated in the real world.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

Thanks jens but i'm talking with reference to the information posted here : http://channel9.msdn.com/ShowPost.aspx?PostID=173513

i'm pasting the relevant excerpts below.i'm only concerned with the information in red.

============================================================

Tyler Brown
Bullets change governments far surer than votes.

Mon, Mar 20 2006 4:55 PM

I'm not sure about the Express edition, but from what I understand, the Developer Edition is a full featured edition with minimal CAL's. It's meant for use in a development environment, and not a production environment, so it restricts the number of connections.

ben2004uk

Mon, Mar 20 2006 5:05 PM

AFAIK (Don't quote me) the Express has a connection limit of 25 and is designed for low-end apps / websites.

irascian
Irascible Ian

Mon, Mar 20 2006 5:42 PM

The others have answered it really. "Express" is the free lightweight version. "Developer" is the full Enterprise version with all the bells and whistles for developers to work against but limited in terms of CALs.

Ordinarily if you can get hold of it Developer Edition is the version to install, with one exception: Team Foundation Server doesn't support it and you need the Standard, Professional or Enterprise edition for that.
========================================================

Now my problem :

1) "Developer Edition is a full featured edition with minimal CAL's."

what is this minimal CAL?

2) "Express has a connection limit of 25 "

what is the connection limit for the developer edition?

Looking forward to ur reply

thanks

|||

Hi,

I don′t know about any limitation in Developer Edition, though its full featured. SQL Expresses only limitation are written in here:

http://msdn2.microsoft.com/en-us/library/ms165672.aspx

Keep in mind that the query governour has been removed, so the limitation of the MSDE is no longer valid.

HTH, Jens Suessmeyer.

http://msdn2.microsoft.com/en-us/library/ms165672.aspx

Keep in mind that the query governour has been removed, so the limitation of the MSDE is no longer valid.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

maximum number of concurrent logins ?

what is the maximum number of concurrent logins MS SQL can
support ? does it depend on the resources of the server ?
assuming the server has almost unlimited resources, is
there a max number of concurrent users that can log in?Hi,
SQL Server can support a maximum of 32767 user connections.
Does it depend on the resources of the server ?
As you said, Resouce will also play because each user connecting requires
physical memory.
Assuming the server has almost unlimited resources, is there a max number of
concurrent users that can log in?
32767
Thanks
Hari
MCDBA
"new2sql" <anonymous@.discussions.microsoft.com> wrote in message
news:810801c3e871$97bb7860$a601280a@.phx.gbl...
> what is the maximum number of concurrent logins MS SQL can
> support ? does it depend on the resources of the server ?
> assuming the server has almost unlimited resources, is
> there a max number of concurrent users that can log in?

maximum number of concurrent logins ?

what is the maximum number of concurrent logins MS SQL can
support ? does it depend on the resources of the server ?
assuming the server has almost unlimited resources, is
there a max number of concurrent users that can log in?Hi,
SQL Server can support a maximum of 32767 user connections.
Does it depend on the resources of the server ?
As you said, Resouce will also play because each user connecting requires
physical memory.
Assuming the server has almost unlimited resources, is there a max number of
concurrent users that can log in?
32767
Thanks
Hari
MCDBA
"new2sql" <anonymous@.discussions.microsoft.com> wrote in message
news:810801c3e871$97bb7860$a601280a@.phx.gbl...

quote:

---

> what is the maximum number of concurrent logins MS SQL can
> support ? does it depend on the resources of the server ?
> assuming the server has almost unlimited resources, is
> there a max number of concurrent users that can log in?

---