MSDE or SQL-SERVER ?? help

Hello can someone help me out, i need to know if i buy the 5 User Cal license of MS-SQL server, does that mean that only 5 people on the network or through the web can access the database? Is that true?
How can i use the SQL Server in the following way:
2-4 users running on a local area network
10-15 concurrent users online
Database size will grow each year by 800-1000mb, i know the MSDE limit is 2Gig,
How can i get a solution to the above problem? what is my best bet to utilize SQL-Server? MSDE Or some other type of sql product?
MSDE has been shown to support far more than 10-15 users. It all depends on
how well the application is written and how your code manages the connection
and the server resource. SQL Express which is due out in 2005 ups the limit
to 4GB. However, with appropriate archiving, you can keep within the limits.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
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.
__________________________________
"Artmic" <Artmic@.discussions.microsoft.com> wrote in message
news:703D7809-DB32-4557-825D-0C7F1F689BEC@.microsoft.com...
> Hello can someone help me out, i need to know if i buy the 5 User Cal
license of MS-SQL server, does that mean that only 5 people on the network
or through the web can access the database? Is that true?
> How can i use the SQL Server in the following way:
> 2-4 users running on a local area network
> 10-15 concurrent users online
> Database size will grow each year by 800-1000mb, i know the MSDE limit is
2Gig,
> How can i get a solution to the above problem? what is my best bet to
utilize SQL-Server? MSDE Or some other type of sql product?
>
|||Ok thanks, i guess i will go ahead with the MSDE and switch to SQL Express when it is available... it is just not economic for a small site to buy a multi-thousand dollar processor license for Online volume that is laughable IMO.
"William (Bill) Vaughn" wrote:

> MSDE has been shown to support far more than 10-15 users. It all depends on
> how well the application is written and how your code manages the connection
> and the server resource. SQL Express which is due out in 2005 ups the limit
> to 4GB. However, with appropriate archiving, you can keep within the limits.
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> 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.
> __________________________________
> "Artmic" <Artmic@.discussions.microsoft.com> wrote in message
> news:703D7809-DB32-4557-825D-0C7F1F689BEC@.microsoft.com...
> license of MS-SQL server, does that mean that only 5 people on the network
> or through the web can access the database? Is that true?
> 2Gig,
> utilize SQL-Server? MSDE Or some other type of sql product?
>
>

MSDE liciense

was that MSDE is a free distribute software and have not
access limitation for the number of the user?
where i can find the more license infor for MSDE
thanks in advance
Try http://www.microsoft.com/sql/msde/default.asp and
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
Regards,
John
"How" <how_world@.hotmail.com> wrote in message
news:914401c4334f$ee4f8bc0$a501280a@.phx.gbl...
> was that MSDE is a free distribute software and have not
> access limitation for the number of the user?
> where i can find the more license infor for MSDE
> thanks in advance

MSDE Licensing In Web App?

I have an ASP.NET web application that will be accessed from the Internet.
Does the MSDE redistributable license cover this situation?
Thanks,
<WARNING: I'm not a lawyer>
Yes. It's commonly used that way. The biggest limitation is usually the
database size limit if you make good use of connection pooling.
</WARNING: I'm not a lawyer>
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Hani Atassi" <hani@.community.nospam> wrote in message
news:89E6E948-F597-41DF-9F8A-61F0DBC2177D@.microsoft.com...
>I have an ASP.NET web application that will be accessed from the Internet.
> Does the MSDE redistributable license cover this situation?
> Thanks,
|||you may also need a Windows Server External Connector License.
If you are running on Windows Server and the external connections are not
from employees, then you need the EC. If they are employees, then you need
CALs for those employees.
-Dino
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:eSlqRs9xEHA.3840@.tk2msftngp13.phx.gbl...
> <WARNING: I'm not a lawyer>
> Yes. It's commonly used that way. The biggest limitation is usually the
> database size limit if you make good use of connection pooling.
> </WARNING: I'm not a lawyer>
> HTH,
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "Hani Atassi" <hani@.community.nospam> wrote in message
> news:89E6E948-F597-41DF-9F8A-61F0DBC2177D@.microsoft.com...
>

MSDE License when used with non-Microsoft database.

MSDE would make a great local cache in my app that uses dialup networking.
However, the App comminicates with sybase running on Linux.
Am I allows to use MSDE this way? Or should I use an open source database
for a local cache?
Thanks
From http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp it looks like
you're ok using MSDE.
joe.
"Karl" <Karl@.discussions.microsoft.com> wrote in message
news:F055A34F-DE27-4B55-A0B7-3E1B14F33097@.microsoft.com...
> MSDE would make a great local cache in my app that uses dialup networking.
> However, the App comminicates with sybase running on Linux.
> Am I allows to use MSDE this way? Or should I use an open source database
> for a local cache?
> Thanks
>

msde license

dear all,
can develop use msde to connect the testing server to implement without buy
any license or CAL
MSDE doesn't include the client tools so it won't help you connect to a
Standard or Enterprise server. For development and testing purposes you can
purchase Developer Edition for US$50.
David Portas
SQL Server MVP

msde license

dear all,
can develop use msde to connect the testing server to implement without buy
any license or CALMSDE doesn't include the client tools so it won't help you connect to a
Standard or Enterprise server. For development and testing purposes you can
purchase Developer Edition for US$50.
David Portas
SQL Server MVP
--

MSDE License

I have a question
We have recently developed a application in ASP that is being shipped to a
client server in Ireland. The ASP application has a database backend in
SQL2000. The clients server is likely to have between 25 and 40 users
accessing the application.
There will be no SQL development or amendments needed on the client server.
We will however need to replicate the data back to our HQ.
Will MSDE cover the Licensing requirements
Many Thanks in advance of your help
Carl Lightfoot
Hi Carl,
Unless the clients are all likely to be hitting the web app constantly and
you can live with the 2G database limit, I think it should be fine.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Carl Lightfoot" <CarlLightfoot@.discussions.microsoft.com> wrote in message
news:F4985F31-77EA-4570-A354-C337704B913B@.microsoft.com...
> I have a question
> We have recently developed a application in ASP that is being shipped to a
> client server in Ireland. The ASP application has a database backend in
> SQL2000. The clients server is likely to have between 25 and 40 users
> accessing the application.
> There will be no SQL development or amendments needed on the client
server.
> We will however need to replicate the data back to our HQ.
> Will MSDE cover the Licensing requirements
> Many Thanks in advance of your help
> --
> Carl Lightfoot
|||Carl,
Remeber that the limit for simultaneous connections is 25.
The database starts to lag at 8.
[]'s
Bruno
>--Original Message--
>Hi Carl,
>Unless the clients are all likely to be hitting the web
app constantly and
>you can live with the 2G database limit, I think it
should be fine.
>HTH,
>--
>Greg Low [MVP]
>MSDE Manager SQL Tools
>www.whitebearconsulting.com
>"Carl Lightfoot"
<CarlLightfoot@.discussions.microsoft.com> wrote in message[vbcol=seagreen]
>news:F4985F31-77EA-4570-A354-C337704B913B@.microsoft.com...
being shipped to a[vbcol=seagreen]
database backend in[vbcol=seagreen]
25 and 40 users[vbcol=seagreen]
on the client[vbcol=seagreen]
>server.
HQ.
>
>.
>
|||Hi Bruno,
There is no 25 simultaneous connection limit. The only limit in this regard
relates to concurrent workloads.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Bruno Avanco" <brunojfk@.hotmail.com> wrote in message
news:83a401c495c1$c2fc2df0$a501280a@.phx.gbl...[vbcol=seagreen]
> Carl,
> Remeber that the limit for simultaneous connections is 25.
> The database starts to lag at 8.
> []'s
> Bruno
> app constantly and
> should be fine.
> <CarlLightfoot@.discussions.microsoft.com> wrote in message
> being shipped to a
> database backend in
> 25 and 40 users
> on the client
> HQ.

msde license

dear all,
can develop use msde to connect the testing server to implement without buy
any license or CALMSDE doesn't include the client tools so it won't help you connect to a
Standard or Enterprise server. For development and testing purposes you can
purchase Developer Edition for US$50.
--
David Portas
SQL Server MVP
--

MSDE EULA licensing

Can I use MSDE 2000 (Release A) for websites public on Internet ?
In EULA I found: "for your internal use" .. then NO ?
[EULA (license.txt)]
1.1 General License Grant. Microsoft grants to you for your internal
use a nonexclusive, limited, royalty free license to install and use the
Software.
Thanks.
Maurizio
hi Maurizio,
Maurizio Sanguinetti wrote:
> Can I use MSDE 2000 (Release A) for websites public on Internet ?
> In EULA I found: "for your internal use" .. then NO ?
> [EULA (license.txt)]
> 1.1 General License Grant. Microsoft grants to you for your
> internal use a nonexclusive, limited, royalty free license to install
> and use the Software.
AFAIK, MSDE Rel A is free to install and use, for internal as long as for
web scenarios usage..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply