Developer 2005 Connection Limit

Hi Jim
Maximum Capacity specifications are available at
http://msdn2.microsoft.com/en-us/library/ms143432.aspx You can have 32,767
user connections.
John
"Jim Norton" wrote:

> I have looked online but cannot find a clear answer to whether Microsoft S
QL
> Server 2005 Developer Edition has a maximum connection limit? I see that
> SQL Express has 25 maximum connections.
> If anyone knows that answer it would be greatly appreciated.
> Thanks!
>
>Hi Jim
I would be interested where you got 25 connections from!
http://www.microsoft.com/technet/pr...sqlexpress.mspx
states
Note: If SQL Server 2005 Express is running on Windows XP Home, it is
limited to five simultaneous connections. If it is running on Windows 2000 o
r
Windows XP Professional, it is limited to 10 simultaneous connections.
However, these are limitations of the operating system and not of SQL Server
2005 Express.
But nothing about any other limit!
John
"John Bell" wrote:
[vbcol=seagreen]
> Hi Jim
> Maximum Capacity specifications are available at
> http://msdn2.microsoft.com/en-us/library/ms143432.aspx You can have 32,767
> user connections.
> John
> "Jim Norton" wrote:
>|||Hi John,
Funny, I can't find where I found that but it appears you are correct. I
saw some references online that the Devloper edition of SQL may or may not
have a CAL or connection limit imposed because it is intended for
development purposes only and I am trying to determine if that will impact
my test environment before I set it up. The Max Capacity specs dont really
break down the different versions so I am still a little nervous.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:81BA8EF8-E085-4377-BC85-68F5722434E7@.microsoft.com...[vbcol=seagreen]
> Hi Jim
> I would be interested where you got 25 connections from!
> http://www.microsoft.com/technet/pr...sqlexpress.mspx
> states
> Note: If SQL Server 2005 Express is running on Windows XP Home, it is
> limited to five simultaneous connections. If it is running on Windows 2000
> or
> Windows XP Professional, it is limited to 10 simultaneous connections.
> However, these are limitations of the operating system and not of SQL
> Server
> 2005 Express.
> But nothing about any other limit!
> John
> "John Bell" wrote:
>|||I have looked online but cannot find a clear answer to whether Microsoft SQL
Server 2005 Developer Edition has a maximum connection limit? I see that
SQL Express has 25 maximum connections.
If anyone knows that answer it would be greatly appreciated.
Thanks!|||Hi Jim
Maximum Capacity specifications are available at
http://msdn2.microsoft.com/en-us/library/ms143432.aspx You can have 32,767
user connections.
John
"Jim Norton" wrote:

> I have looked online but cannot find a clear answer to whether Microsoft S
QL
> Server 2005 Developer Edition has a maximum connection limit? I see that
> SQL Express has 25 maximum connections.
> If anyone knows that answer it would be greatly appreciated.
> Thanks!
>
>|||Hi Jim
I would be interested where you got 25 connections from!
http://www.microsoft.com/technet/pr...sqlexpress.mspx
states
Note: If SQL Server 2005 Express is running on Windows XP Home, it is
limited to five simultaneous connections. If it is running on Windows 2000 o
r
Windows XP Professional, it is limited to 10 simultaneous connections.
However, these are limitations of the operating system and not of SQL Server
2005 Express.
But nothing about any other limit!
John
"John Bell" wrote:
[vbcol=seagreen]
> Hi Jim
> Maximum Capacity specifications are available at
> http://msdn2.microsoft.com/en-us/library/ms143432.aspx You can have 32,767
> user connections.
> John
> "Jim Norton" wrote:
>|||Hi John,
Funny, I can't find where I found that but it appears you are correct. I
saw some references online that the Devloper edition of SQL may or may not
have a CAL or connection limit imposed because it is intended for
development purposes only and I am trying to determine if that will impact
my test environment before I set it up. The Max Capacity specs dont really
break down the different versions so I am still a little nervous.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:81BA8EF8-E085-4377-BC85-68F5722434E7@.microsoft.com...[vbcol=seagreen]
> Hi Jim
> I would be interested where you got 25 connections from!
> http://www.microsoft.com/technet/pr...sqlexpress.mspx
> states
> Note: If SQL Server 2005 Express is running on Windows XP Home, it is
> limited to five simultaneous connections. If it is running on Windows 2000
> or
> Windows XP Professional, it is limited to 10 simultaneous connections.
> However, these are limitations of the operating system and not of SQL
> Server
> 2005 Express.
> But nothing about any other limit!
> John
> "John Bell" wrote:
>|||"Jim Norton" <joe@.joe.com> wrote in message
news:%23dETmctmGHA.4728@.TK2MSFTNGP05.phx.gbl...
> Hi John,
> Funny, I can't find where I found that but it appears you are correct. I
> saw some references online that the Devloper edition of SQL may or may not
> have a CAL or connection limit imposed because it is intended for
> development purposes only and I am trying to determine if that will impact
> my test environment before I set it up. The Max Capacity specs dont
really
> break down the different versions so I am still a little nervous.
The Developer edition is "basically" the Enterprise Edition, but licensed
for developer use only.
I haven't heard about SQL 2005 Express having any inherent limits itself.

> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:81BA8EF8-E085-4377-BC85-68F5722434E7@.microsoft.com...
http://www.microsoft.com/technet/pr...sqlexpress.mspx[vbcol=seagreen]
2000[vbcol=seagreen]
>|||"Jim Norton" <joe@.joe.com> wrote in message
news:%23dETmctmGHA.4728@.TK2MSFTNGP05.phx.gbl...
> Hi John,
> Funny, I can't find where I found that but it appears you are correct. I
> saw some references online that the Devloper edition of SQL may or may not
> have a CAL or connection limit imposed because it is intended for
> development purposes only and I am trying to determine if that will impact
> my test environment before I set it up. The Max Capacity specs dont
really
> break down the different versions so I am still a little nervous.
The Developer edition is "basically" the Enterprise Edition, but licensed
for developer use only.
I haven't heard about SQL 2005 Express having any inherent limits itself.

> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:81BA8EF8-E085-4377-BC85-68F5722434E7@.microsoft.com...
http://www.microsoft.com/technet/pr...sqlexpress.mspx[vbcol=seagreen]
2000[vbcol=seagreen]
>|||Hi Jim
You could look at SELECT @.@.MAX_CONNECTIONS to see what value you have! It
could be that your system is overloaded in other areas before the maximim
number of connections is reached.
John
"Jim Norton" wrote:

> Hi John,
> Funny, I can't find where I found that but it appears you are correct. I
> saw some references online that the Devloper edition of SQL may or may not
> have a CAL or connection limit imposed because it is intended for
> development purposes only and I am trying to determine if that will impact
> my test environment before I set it up. The Max Capacity specs dont reall
y
> break down the different versions so I am still a little nervous.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:81BA8EF8-E085-4377-BC85-68F5722434E7@.microsoft.com...
>
>