Connection Limit of express's reporting services

Hi,
Do you know the connection limit of express's reporting services?
As i know standard's version is unlimited, so how about the adv version.
Can I use this free version as web reporting tool for more than 100 users?
Many Thanks....Hi,
yes, you have no query governor anymore, but you are restricted to the
hardware limitations of SQL Server Express, so scaling up with Express
is limited. There are also no connection limitations.
HTH, Jens K. Suessmeyer.
--
http://www.sqlserver2005.de
--|||Hi Jens,
Thanks.
Do you have any benchmarking info between express & standard in term of RS
performance (no db installed in express) where express only support One CPU
& allocate 1G Mem.
What I want to know how RS consume server resources so i can make a decision
to choose express RS or standard RS for my web report which will support 100
users.
Many thanks again.
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1169538427.949486.105720@.v45g2000cwv.googlegroups.com...
> Hi,
> yes, you have no query governor anymore, but you are restricted to the
> hardware limitations of SQL Server Express, so scaling up with Express
> is limited. There are also no connection limitations.
> HTH, Jens K. Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>|||Hi,
this is really hard to tell, there is no rule of thumb as it has many
influencing factors. What about processing time for the reports, how
often do they access the reports, how big are the reports, which
reporting format will they produce, etc. You will have to run a load
test on the machine to see how your report are performing for getting a
performance measure to scale you machine.
HTH, Jens K. Suessmeyer.
--
http://www.sqlserver2005.de
--|||Thanks jens, will try and test.
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1169584143.023207.298610@.j27g2000cwj.googlegroups.com...
> Hi,
> this is really hard to tell, there is no rule of thumb as it has many
> influencing factors. What about processing time for the reports, how
> often do they access the reports, how big are the reports, which
> reporting format will they produce, etc. You will have to run a load
> test on the machine to see how your report are performing for getting a
> performance measure to scale you machine.
>
> HTH, Jens K. Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>

Connection Issue

Hello EveryBody,
If SQL SERVER is configured as a Maximun concurrent user connections = 1 (I
know 0 = unlimited) in Connection tab of server property ? Who will able to
login to server ?
Because i have a similar case and not able to login with any other sql
server Login.
Is SQL SERVER admin (sa) will able to login ?
Pls let me know
I assume your single login is being used by Agent when it starts up so
nobody will be able to log in.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"mvp" <mvp@.discussions.microsoft.com> wrote in message
news:88C5F9E7-30C7-4B59-A9F5-06BDBF159CA7@.microsoft.com...
> Hello EveryBody,
> If SQL SERVER is configured as a Maximun concurrent user connections = 1
> (I
> know 0 = unlimited) in Connection tab of server property ? Who will able
> to
> login to server ?
> Because i have a similar case and not able to login with any other sql
> server Login.
> Is SQL SERVER admin (sa) will able to login ?
> Pls let me know

Connection Issue

Hello EveryBody,
If SQL SERVER is configured as a Maximun concurrent user connections = 1 (I
know 0 = unlimited) in Connection tab of server property ? Who will able to
login to server ?
Because i have a similar case and not able to login with any other sql
server Login.
Is SQL SERVER admin (sa) will able to login ?
Pls let me knowI assume your single login is being used by Agent when it starts up so
nobody will be able to log in.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"mvp" <mvp@.discussions.microsoft.com> wrote in message
news:88C5F9E7-30C7-4B59-A9F5-06BDBF159CA7@.microsoft.com...
> Hello EveryBody,
> If SQL SERVER is configured as a Maximun concurrent user connections = 1
> (I
> know 0 = unlimited) in Connection tab of server property ? Who will able
> to
> login to server ?
> Because i have a similar case and not able to login with any other sql
> server Login.
> Is SQL SERVER admin (sa) will able to login ?
> Pls let me know