Home > Archive > microsoft.public.sqlserver.server > November 2002 > SQL Server License (IIS/Web)





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author SQL Server License (IIS/Web)

2002-11-28, 1:23 pm

License question I need clarified as soon as possible:

I have an IIS ASP web application that connects to an SQL Server database to
retrieve and create records.

The virtual directory where the ASP application is run from is setup using
anonymous access incorporating an NT Login username "Mydomain\Myuser" who
has access to the SQL Server and 1 CAL assigned to him.

The question is, even though a number or users access the web application
but in effect only 1 user actually connects to the SQL Server database, do I
need individual CALs for each "web user" ?

The ASP opens and shares a single a connection to the database, and that it
is closed as soon as the page is rendered.

Any advise is welcome.






Darren Green

2002-11-28, 1:23 pm

In article <ON0eb0wlCHA.2000@tkmsftngp04>, cablito@hotmail.com writes
>License question I need clarified as soon as possible:
>
>I have an IIS ASP web application that connects to an SQL Server database to
>retrieve and create records.
>
>The virtual directory where the ASP application is run from is setup using
>anonymous access incorporating an NT Login username "Mydomain\Myuser" who
>has access to the SQL Server and 1 CAL assigned to him.
>
>The question is, even though a number or users access the web application
>but in effect only 1 user actually connects to the SQL Server database, do I
>need individual CALs for each "web user" ?
>
>The ASP opens and shares a single a connection to the database, and that it
>is closed as soon as the page is rendered.
>
>Any advise is welcome.
>


For a definitive answer contact your local MS office, they will have a
licensing contact/department.

My understanding -

Simple answer is this is not allowed. This is what was termed
multiplexing in the good old days and has always been mentioned in the
SQL licences as a no.

If this is a public site then your only option is to licence SQL Server
per processor.

If this is a private/intranet site with only known users then you can
use per seat, which means 1 cal for each *device* that connects, not
necessarily the same as per user.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com


Allan Mitchell

2002-11-28, 2:23 pm

If the Web based app is open to the outside world then it doesn't matter how
many connections you get to the database i.e Many into the app - one out to
the backend the licenceing is the same, Per Processor.

That is my understanding anyway. Contact your reseller for their opinions
though

--



Allan Mitchell (Microsoft SQL Server MVP)
www.SQLDTS.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org



<cablito@hotmail.com> wrote in message news:ON0eb0wlCHA.2000@tkmsftngp04...
> License question I need clarified as soon as possible:
>
> I have an IIS ASP web application that connects to an SQL Server database

to
> retrieve and create records.
>
> The virtual directory where the ASP application is run from is setup using
> anonymous access incorporating an NT Login username "Mydomain\Myuser" who
> has access to the SQL Server and 1 CAL assigned to him.
>
> The question is, even though a number or users access the web application
> but in effect only 1 user actually connects to the SQL Server database, do

I
> need individual CALs for each "web user" ?
>
> The ASP opens and shares a single a connection to the database, and that

it
> is closed as soon as the page is rendered.
>
> Any advise is welcome.
>
>
>
>
>
>



Jasper Smith

2002-11-28, 5:23 pm

If you do not know the number of users e.g. Internet App then
you need per processor licensing. Have a look at these links

http://www.microsoft.com/sql/howtobuy/production.asp
http://www.microsoft.com/sql/howtobuy/licensingwp.asp
http://www.microsoft.com/sql/howtob...erlicensing.asp

--
HTH

Jasper Smith (SQL Server MVP)

I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org

<cablito@hotmail.com> wrote in message news:ON0eb0wlCHA.2000@tkmsftngp04...
> License question I need clarified as soon as possible:
>
> I have an IIS ASP web application that connects to an SQL Server database

to
> retrieve and create records.
>
> The virtual directory where the ASP application is run from is setup using
> anonymous access incorporating an NT Login username "Mydomain\Myuser" who
> has access to the SQL Server and 1 CAL assigned to him.
>
> The question is, even though a number or users access the web application
> but in effect only 1 user actually connects to the SQL Server database, do

I
> need individual CALs for each "web user" ?
>
> The ASP opens and shares a single a connection to the database, and that

it
> is closed as soon as the page is rendered.
>
> Any advise is welcome.
>
>
>
>
>
>



Jérôme Poudou

2002-11-30, 12:23 am

each access required 1 CAL.
if you have 25 CALs, you can connect 25 users at the same time.

If you are on the web with all the planet has client, so by processor
licensing is requiered to insure that your application will respond without
login error.

if your web application close the connection as soon as possible, so in this
case you can handle multiple users with only a few number of CALs.

<cablito@hotmail.com> a écrit dans le message de news:
ON0eb0wlCHA.2000@tkmsftngp04...
> License question I need clarified as soon as possible:
>
> I have an IIS ASP web application that connects to an SQL Server database

to
> retrieve and create records.
>
> The virtual directory where the ASP application is run from is setup using
> anonymous access incorporating an NT Login username "Mydomain\Myuser" who
> has access to the SQL Server and 1 CAL assigned to him.
>
> The question is, even though a number or users access the web application
> but in effect only 1 user actually connects to the SQL Server database, do

I
> need individual CALs for each "web user" ?
>
> The ASP opens and shares a single a connection to the database, and that

it
> is closed as soon as the page is rendered.
>
> Any advise is welcome.
>
>
>
>
>
>



Sponsored Links





Free Braindumps | MCSE braindumps software forum

Copyright 2003 - 2008 examnotes.net