Number of allowed connections for SQL Server 2005 Standard on XP P

I assume that the number of connections that SQL Server 2005 Standard can
concurrently have will be limited by the operating system it is running on.
If that OS is XP Pro, how many concurrent connections can SQL Server 2005
Standard have?
MichaelI believe that is a wrong assumption. There is no limit based on the OS that
I know of other than the fact that 64 bit can support more memory for
connections. But if you are worried about lots of connections then why would
you want to use XP Pro? The # of connections will ultimately be limited by
the amount of memory and the hardware.
Andrew J. Kelly SQL MVP
"michael" <michael@.discussions.microsoft.com> wrote in message
news:0EA3B57E-6583-4A59-B38B-FB4C89AB5D74@.microsoft.com...
>I assume that the number of connections that SQL Server 2005 Standard can
> concurrently have will be limited by the operating system it is running
> on.
> If that OS is XP Pro, how many concurrent connections can SQL Server 2005
> Standard have?
> --
> Michael|||Yup... and the amount of CPU time you can dedicate to the threads SQL Server
will generate to handle the operations.
Let's hear more about your connection strategy and application architecture.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OSgPZMRiHHA.4596@.TK2MSFTNGP05.phx.gbl...
>I believe that is a wrong assumption. There is no limit based on the OS
>that I know of other than the fact that 64 bit can support more memory for
>connections. But if you are worried about lots of connections then why
>would you want to use XP Pro? The # of connections will ultimately be
>limited by the amount of memory and the hardware.
> --
> Andrew J. Kelly SQL MVP
> "michael" <michael@.discussions.microsoft.com> wrote in message
> news:0EA3B57E-6583-4A59-B38B-FB4C89AB5D74@.microsoft.com...
>