MSDN version of SQL Server 2005 Connections

If I put an MSDN version of SQL Server 2005 on a server that has IIS
for testing does the IIS users get limited to 10 connections to SQL at
once or is it considered 1 connection?
I need to know so we can use it as a test platform of load testing of
several hundered 100 or so users before moving to the production
version of SQL...which is not here yet...I dont want to think any
problems of connections or timeouts are due to using the MSDN version
for testing and development.
Thanks, Ed,No. Whether it's from MSDN or not has no bearing on the feature set, that
simply depends on what edition you use
(Dev/Standard/Enterprise/Workgroup/Express). What it does have a bearing on
is licensing.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"gencode" <google@.gencode.com> wrote in message
news:1131130353.177316.126630@.g14g2000cwa.googlegroups.com...
> If I put an MSDN version of SQL Server 2005 on a server that has IIS
> for testing does the IIS users get limited to 10 connections to SQL at
> once or is it considered 1 connection?
> I need to know so we can use it as a test platform of load testing of
> several hundered 100 or so users before moving to the production
> version of SQL...which is not here yet...I dont want to think any
> problems of connections or timeouts are due to using the MSDN version
> for testing and development.
> Thanks, Ed,
>|||Sorry, forgot to say
SQL 2005 "Enterprise Edition"
I know some MSDN things like OS limit to 10, worried that it will limit
me
Ed,|||What I am wondering is if I use the MSDN Enterprise Edition of SQL for
the backend of my development web server will it only allow 10 people
to connect to my web pages that have codebehind accessing the database,
or get some type of connection error in my code after 10 users or will
it not limit me for my testing of over 100 web users?
All users connect via IIS, none have direct connections to SQL
Thansk again Jasper|||No, there's no feature limitation (that I'm aware of) - it's purely a
licensing thing
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"gencode" <google@.gencode.com> wrote in message
news:1131146290.037020.56980@.g14g2000cwa.googlegroups.com...
> What I am wondering is if I use the MSDN Enterprise Edition of SQL for
> the backend of my development web server will it only allow 10 people
> to connect to my web pages that have codebehind accessing the database,
> or get some type of connection error in my code after 10 users or will
> it not limit me for my testing of over 100 web users?
> All users connect via IIS, none have direct connections to SQL
> Thansk again Jasper
>|||Thanks|||Thanks