CAL users - 1 or many?

If you have an application that uses a single SQL logon to access the database, but that application is used by many people to access the database, do we require one CAL (for the app) or many (for each user)?For server/CAL licensing the licence agreement requires that you purchase a
licence for each user or device using the server. A user is an actual
person, not a login. That's my understanding.
From the licensing FAQ:
"A user CAL allows a particular user to gain access to licensed server
software from any number of devices."
http://www.microsoft.com/sql/howtobuy/faq.asp
--
David Portas
SQL Server MVP
--

CAL users - 1 or many?

If you have an application that uses a single SQL logon to access the databa
se, but that application is used by many people to access the database, do w
e require one CAL (for the app) or many (for each user)?For server/CAL licensing the licence agreement requires that you purchase a
licence for each user or device using the server. A user is an actual
person, not a login. That's my understanding.
From the licensing FAQ:
"A user CAL allows a particular user to gain access to licensed server
software from any number of devices."
http://www.microsoft.com/sql/howtobuy/faq.asp
David Portas
SQL Server MVP
--

CAL users - 1 or many?

If you have an application that uses a single SQL logon to access the database, but that application is used by many people to access the database, do we require one CAL (for the app) or many (for each user)?
For server/CAL licensing the licence agreement requires that you purchase a
licence for each user or device using the server. A user is an actual
person, not a login. That's my understanding.
From the licensing FAQ:
"A user CAL allows a particular user to gain access to licensed server
software from any number of devices."
http://www.microsoft.com/sql/howtobuy/faq.asp
David Portas
SQL Server MVP

CAL question

I have a CAL to access a SQL Server that is installed on a local network. I
also have MSDE installed on my local machine.
Can I use this CAL to install the client tools of SQL Server (viz Enterprise
Manager, Query Analyzer) on my local machine to access my MSDE '
Thanx in advance,
Amol.A CAL lets you install the SQL Client tools on your PC BUT as far as
managing MSDE I'm afraid you need to be a lawyer to work that out. There are
some circumstances that allow you to use the client tools against it legally
but you would really need to speak to MS to understand what they are and
they probably won't really know either - it's a bit of a nightmare :-(
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
"Amol Kasbekar" <apk@.nospam.cbord.com> wrote in message
news:%23cymQ9ptEHA.260@.TK2MSFTNGP11.phx.gbl...
>I have a CAL to access a SQL Server that is installed on a local network. I
>also have MSDE installed on my local machine.
> Can I use this CAL to install the client tools of SQL Server (viz
> Enterprise Manager, Query Analyzer) on my local machine to access my MSDE
> '
> Thanx in advance,
> Amol.
>|||Wasn't the license for the Client Tools granted only with Visual Studio,
Office Developer and SQL Server?
AFAIK, having a CAL to access SQL Server doesn't give you the rights to use
their client tools to do so, and less if you plan to admin a *gasp* free
product.
Now regarding MSDE, there are some free alternatives to EM like DbaMgr and
Visendo SQL Admin. Go google them!
Regards,
Eric Garza
AMIGE
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:eN2BLcstEHA.2788@.TK2MSFTNGP09.phx.gbl...
> A CAL lets you install the SQL Client tools on your PC BUT as far as
> managing MSDE I'm afraid you need to be a lawyer to work that out. There
are
> some circumstances that allow you to use the client tools against it
legally
> but you would really need to speak to MS to understand what they are and
> they probably won't really know either - it's a bit of a nightmare :-(
> --
> 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
> "Amol Kasbekar" <apk@.nospam.cbord.com> wrote in message
> news:%23cymQ9ptEHA.260@.TK2MSFTNGP11.phx.gbl...
I[vbcol=seagreen]
MSDE[vbcol=seagreen]
>

CAL question

I have a CAL to access a SQL Server that is installed on a local network. I
also have MSDE installed on my local machine.
Can I use this CAL to install the client tools of SQL Server (viz Enterprise
Manager, Query Analyzer) on my local machine to access my MSDE '
Thanx in advance,
Amol.A CAL lets you install the SQL Client tools on your PC BUT as far as
managing MSDE I'm afraid you need to be a lawyer to work that out. There are
some circumstances that allow you to use the client tools against it legally
but you would really need to speak to MS to understand what they are and
they probably won't really know either - it's a bit of a nightmare :-(
--
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
"Amol Kasbekar" <apk@.nospam.cbord.com> wrote in message
news:%23cymQ9ptEHA.260@.TK2MSFTNGP11.phx.gbl...
>I have a CAL to access a SQL Server that is installed on a local network. I
>also have MSDE installed on my local machine.
> Can I use this CAL to install the client tools of SQL Server (viz
> Enterprise Manager, Query Analyzer) on my local machine to access my MSDE
> '
> Thanx in advance,
> Amol.
>|||Wasn't the license for the Client Tools granted only with Visual Studio,
Office Developer and SQL Server?
AFAIK, having a CAL to access SQL Server doesn't give you the rights to use
their client tools to do so, and less if you plan to admin a *gasp* free
product.
Now regarding MSDE, there are some free alternatives to EM like DbaMgr and
Visendo SQL Admin. Go google them!
--
Regards,
Eric Garza
AMIGE
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:eN2BLcstEHA.2788@.TK2MSFTNGP09.phx.gbl...
> A CAL lets you install the SQL Client tools on your PC BUT as far as
> managing MSDE I'm afraid you need to be a lawyer to work that out. There
are
> some circumstances that allow you to use the client tools against it
legally
> but you would really need to speak to MS to understand what they are and
> they probably won't really know either - it's a bit of a nightmare :-(
> --
> 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
> "Amol Kasbekar" <apk@.nospam.cbord.com> wrote in message
> news:%23cymQ9ptEHA.260@.TK2MSFTNGP11.phx.gbl...
> >I have a CAL to access a SQL Server that is installed on a local network.
I
> >also have MSDE installed on my local machine.
> > Can I use this CAL to install the client tools of SQL Server (viz
> > Enterprise Manager, Query Analyzer) on my local machine to access my
MSDE
> > '
> >
> > Thanx in advance,
> > Amol.
> >
>

CAL Question

If I have 3 programs on my desktop that connect to two
different SQL Server databases (two to 1 and 1 to the
other) , yeah! looks funny, I know.
How many SQL Server CAL's do I need? Are these server CALs
or Device CALs or does it matter?
If I am using all three programs at the same time does it
make a difference? I would appreciate any input or even
clarifications on my question.
Ta!
A CAL (user or device, there is no such thing as a server CAL) allows you to
access any SQL Servers in your organisation. You still need licenses for
every server on which you install SQL Server of course.
Jacco Schalkwijk
SQL Server MVP
"dr. Fil" <anonymous@.discussions.microsoft.com> wrote in message
news:6cf401c475c9$5a3ed500$a601280a@.phx.gbl...
> If I have 3 programs on my desktop that connect to two
> different SQL Server databases (two to 1 and 1 to the
> other) , yeah! looks funny, I know.
> How many SQL Server CAL's do I need? Are these server CALs
> or Device CALs or does it matter?
> If I am using all three programs at the same time does it
> make a difference? I would appreciate any input or even
> clarifications on my question.
> Ta!

CAL question

I have a CAL to access a SQL Server that is installed on a local network. I
also have MSDE installed on my local machine.
Can I use this CAL to install the client tools of SQL Server (viz Enterprise
Manager, Query Analyzer) on my local machine to access my MSDE ?
Thanx in advance,
Amol.
A CAL lets you install the SQL Client tools on your PC BUT as far as
managing MSDE I'm afraid you need to be a lawyer to work that out. There are
some circumstances that allow you to use the client tools against it legally
but you would really need to speak to MS to understand what they are and
they probably won't really know either - it's a bit of a nightmare :-(
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
"Amol Kasbekar" <apk@.nospam.cbord.com> wrote in message
news:%23cymQ9ptEHA.260@.TK2MSFTNGP11.phx.gbl...
>I have a CAL to access a SQL Server that is installed on a local network. I
>also have MSDE installed on my local machine.
> Can I use this CAL to install the client tools of SQL Server (viz
> Enterprise Manager, Query Analyzer) on my local machine to access my MSDE
> ?
> Thanx in advance,
> Amol.
>
|||Wasn't the license for the Client Tools granted only with Visual Studio,
Office Developer and SQL Server?
AFAIK, having a CAL to access SQL Server doesn't give you the rights to use
their client tools to do so, and less if you plan to admin a *gasp* free
product.
Now regarding MSDE, there are some free alternatives to EM like DbaMgr and
Visendo SQL Admin. Go google them!
Regards,
Eric Garza
AMIGE
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:eN2BLcstEHA.2788@.TK2MSFTNGP09.phx.gbl...
> A CAL lets you install the SQL Client tools on your PC BUT as far as
> managing MSDE I'm afraid you need to be a lawyer to work that out. There
are
> some circumstances that allow you to use the client tools against it
legally[vbcol=seagreen]
> but you would really need to speak to MS to understand what they are and
> they probably won't really know either - it's a bit of a nightmare :-(
> --
> 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
> "Amol Kasbekar" <apk@.nospam.cbord.com> wrote in message
> news:%23cymQ9ptEHA.260@.TK2MSFTNGP11.phx.gbl...
I[vbcol=seagreen]
MSDE
>

cal number of days in between dates

select a.RelocateID,a.DateEntered,a.CompanyID,b.FileClose dDate from test1 a inner join test b on
(a.RelocateID = b.RelocateID) where
CompanyID ='5710' and DateEntered >= '01/01/2004' and convert(varchar,FileClosedDate,101) < '31/12/2004'

Hi I was wondering if somebody could help me alter this query so I an calulate the difference in days in between DateEntered and FileClosedDate having the above criteria.
I can't seem to be able to get the datediff function right in this particular examplewhy are you converting FileClosedDate to varchar?

let the database compare dates as dates ;) :)

what are the datatypes of the two date columns?|||Try using # Sign before and After Dates like
select a.RelocateID,a.DateEntered,a.CompanyID,b.FileClose dDate from test1 a inner join test b on
(a.RelocateID = b.RelocateID) where
CompanyID ='5710' and DateEntered >= #01/01/2004# and convert(varchar,FileClosedDate,101) < #31/12/2004#|||Try using # Sign before and After Dates like
select a.RelocateID,a.DateEntered,a.CompanyID,b.FileClose dDate from test1 a inner join test b on
(a.RelocateID = b.RelocateID) where
CompanyID ='5710' and DateEntered >= #01/01/2004# and convert(varchar,FileClosedDate,101) < #31/12/2004#

This is the SQL Server forum, not the MS Access forum, darvesh...

Cal Measure % against total

How to define calculated member whose value should be the row value divided by total of all rows. Example, sales of 2005 was 50k and sales for 2006 was 100k. The % 2005 sales is 33% of total (150k) and 2006 is 67%.

Hi

For example to get the percentage of the Unit Sales for one customer of all customers, you write:

[Measures].[Unit Sales] / ([Measures].[Unit Sales], [Customers].[All Customers])

The key is, to divide by a MDX tuple ([Measures].[Unit Sales], [Customers].[All Customers]) which brings the value for all customers.

Hans

|||

Thank Hans

This problem is solved. Please guide me to get the same result with multiple dimensions.

Also, i have a variance calculated member, which is on the date time diminsion [Sale of 2005] - [Sale of 2006] = [Variance 2005]. I would like to see three measures, [Year 2005 Sale], [Year 2006 Sale] and variance. But i get Sales and variance figure under Year 2005 and same under Year 2006. How to get the desired result.

Thanks

Shekhar

|||

Hi Shekhar,

I'm not sure, if I did understand you right, but I think it's because your [Variance] is on the Time Dimension. I do it in my projects so, that I create a calculated member like:

MEMBER [Measures].[Year variance] AS ([Measures].[Unit Sales],[Time].Currentmember.Prevmember) - [Measures].[Unit Sales]

If Currentmember is Year 2007, den Prevmember is Year 2006 and so on.

If you use now all 3 in a select, you can see it "flat"

select

{ [Measures].[Year 2005 Sales], [Measures].[Year 2006 Sale], [Measures].[Year variance]} on columns,

.....

Hans

CAL Licensing for SQL Servers

Hi,
I am not responsible for licensing issue. There are 5 SQL 2000 Standard
Servers in our sites. 3 of them are running applications like - Finance /
Payroll / CRM. When I set up each of them, I was told the license to be
entered is 20 CALs.
We also have another 2 SQL Server Standard for small application. I was
told to use 5 CALs when I set up the Server.
I would like to know for our cases, there are 5 SQL Servers, if we bought 20
CALs, is it possible for us to access all of the SQL Servers simultaneously
? OR 20 CALs for each server ?
If we have bought 20 CALs at our site, does it mean that I should enter 20
CALs for every SQL Server (Instead of 5 in 2 of them) ?
Thanks
Jason
Under Server / CAL licensing you need to purchase a CAL for each end user or
client device who will be connecting to SQL Server. A CAL is valid for any
number of servers so a user with a single CAL can access multiple servers.
As far as I'm aware, entering different CAL quantities for different servers
won't affect the status of your licensing in any material way. That's my
understanding. The best place to look for answers on licensing issues is:
http://www.microsoft.com/sql/howtobuy/default.mspx
David Portas
SQL Server MVP
|||you are right.
1 CAL give access to all your SQL Server instance.
so 1 CAL give access to your 5 servers.
tools like the SQL agent consumme 1 CAL.
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:3JadnaHYaJDNv2LfRVn-2w@.giganews.com...
> Under Server / CAL licensing you need to purchase a CAL for each end user
> or client device who will be connecting to SQL Server. A CAL is valid for
> any number of servers so a user with a single CAL can access multiple
> servers. As far as I'm aware, entering different CAL quantities for
> different servers won't affect the status of your licensing in any
> material way. That's my understanding. The best place to look for answers
> on licensing issues is:
> http://www.microsoft.com/sql/howtobuy/default.mspx
> --
> David Portas
> SQL Server MVP
> --
>
|||Dear David,
Does it mean that for all SQL Servers, I can enter 20 as the CALs ?
Jason
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:3JadnaHYaJDNv2LfRVn-2w@.giganews.com...
> Under Server / CAL licensing you need to purchase a CAL for each end user
> or client device who will be connecting to SQL Server. A CAL is valid for
> any number of servers so a user with a single CAL can access multiple
> servers. As far as I'm aware, entering different CAL quantities for
> different servers won't affect the status of your licensing in any
> material way. That's my understanding. The best place to look for answers
> on licensing issues is:
> http://www.microsoft.com/sql/howtobuy/default.mspx
> --
> David Portas
> SQL Server MVP
> --
>

CAL Licensing for SQL Servers

Hi,
I am not responsible for licensing issue. There are 5 SQL 2000 Standard
Servers in our sites. 3 of them are running applications like - Finance /
Payroll / CRM. When I set up each of them, I was told the license to be
entered is 20 CALs.
We also have another 2 SQL Server Standard for small application. I was
told to use 5 CALs when I set up the Server.
I would like to know for our cases, there are 5 SQL Servers, if we bought 20
CALs, is it possible for us to access all of the SQL Servers simultaneously
? OR 20 CALs for each server ?
If we have bought 20 CALs at our site, does it mean that I should enter 20
CALs for every SQL Server (Instead of 5 in 2 of them) ?
Thanks
JasonUnder Server / CAL licensing you need to purchase a CAL for each end user or
client device who will be connecting to SQL Server. A CAL is valid for any
number of servers so a user with a single CAL can access multiple servers.
As far as I'm aware, entering different CAL quantities for different servers
won't affect the status of your licensing in any material way. That's my
understanding. The best place to look for answers on licensing issues is:
http://www.microsoft.com/sql/howtobuy/default.mspx
--
David Portas
SQL Server MVP
--|||you are right.
1 CAL give access to all your SQL Server instance.
so 1 CAL give access to your 5 servers.
tools like the SQL agent consumme 1 CAL.
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:3JadnaHYaJDNv2LfRVn-2w@.giganews.com...
> Under Server / CAL licensing you need to purchase a CAL for each end user
> or client device who will be connecting to SQL Server. A CAL is valid for
> any number of servers so a user with a single CAL can access multiple
> servers. As far as I'm aware, entering different CAL quantities for
> different servers won't affect the status of your licensing in any
> material way. That's my understanding. The best place to look for answers
> on licensing issues is:
> http://www.microsoft.com/sql/howtobuy/default.mspx
> --
> David Portas
> SQL Server MVP
> --
>|||Dear David,
Does it mean that for all SQL Servers, I can enter 20 as the CALs ?
Jason
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:3JadnaHYaJDNv2LfRVn-2w@.giganews.com...
> Under Server / CAL licensing you need to purchase a CAL for each end user
> or client device who will be connecting to SQL Server. A CAL is valid for
> any number of servers so a user with a single CAL can access multiple
> servers. As far as I'm aware, entering different CAL quantities for
> different servers won't affect the status of your licensing in any
> material way. That's my understanding. The best place to look for answers
> on licensing issues is:
> http://www.microsoft.com/sql/howtobuy/default.mspx
> --
> David Portas
> SQL Server MVP
> --
>

CAL Licensing for SQL Servers

Hi,
I am not responsible for licensing issue. There are 5 SQL 2000 Standard
Servers in our sites. 3 of them are running applications like - Finance /
Payroll / CRM. When I set up each of them, I was told the license to be
entered is 20 CALs.
We also have another 2 SQL Server Standard for small application. I was
told to use 5 CALs when I set up the Server.
I would like to know for our cases, there are 5 SQL Servers, if we bought 20
CALs, is it possible for us to access all of the SQL Servers simultaneously
? OR 20 CALs for each server ?
If we have bought 20 CALs at our site, does it mean that I should enter 20
CALs for every SQL Server (Instead of 5 in 2 of them) ?
Thanks
JasonUnder Server / CAL licensing you need to purchase a CAL for each end user or
client device who will be connecting to SQL Server. A CAL is valid for any
number of servers so a user with a single CAL can access multiple servers.
As far as I'm aware, entering different CAL quantities for different servers
won't affect the status of your licensing in any material way. That's my
understanding. The best place to look for answers on licensing issues is:
http://www.microsoft.com/sql/howtobuy/default.mspx
David Portas
SQL Server MVP
--|||you are right.
1 CAL give access to all your SQL Server instance.
so 1 CAL give access to your 5 servers.
tools like the SQL agent consumme 1 CAL.
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:3JadnaHYaJDNv2LfRVn-2w@.giganews.com...
> Under Server / CAL licensing you need to purchase a CAL for each end user
> or client device who will be connecting to SQL Server. A CAL is valid for
> any number of servers so a user with a single CAL can access multiple
> servers. As far as I'm aware, entering different CAL quantities for
> different servers won't affect the status of your licensing in any
> material way. That's my understanding. The best place to look for answers
> on licensing issues is:
> http://www.microsoft.com/sql/howtobuy/default.mspx
> --
> David Portas
> SQL Server MVP
> --
>|||Dear David,
Does it mean that for all SQL Servers, I can enter 20 as the CALs ?
Jason
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:3JadnaHYaJDNv2LfRVn-2w@.giganews.com...
> Under Server / CAL licensing you need to purchase a CAL for each end user
> or client device who will be connecting to SQL Server. A CAL is valid for
> any number of servers so a user with a single CAL can access multiple
> servers. As far as I'm aware, entering different CAL quantities for
> different servers won't affect the status of your licensing in any
> material way. That's my understanding. The best place to look for answers
> on licensing issues is:
> http://www.microsoft.com/sql/howtobuy/default.mspx
> --
> David Portas
> SQL Server MVP
> --
>

CAL Licensing and user limitations?

Hi to everyone, probably it's a faq but I did not find a sure answer.

A customer has a Sql Server 2000 standard installed in 1server/5CAL
licensing mode, in a windows 2000 server.
Does this type of installation limit the further connections (occourred in
same or distinct sql accounts) that exceed the 5 client/user?
And if this connections aren't limited, are these further connections
penalized by the query governor like MSDE does?

In short, is the CAL licensing mode only a legal issue without affecting or
limiting the performance of the exceeding connections?

Thanks in advance,
Pas!Pashkuale (sorry@.nomail.com) writes:
> Hi to everyone, probably it's a faq but I did not find a sure answer.
> A customer has a Sql Server 2000 standard installed in 1server/5CAL
> licensing mode, in a windows 2000 server.
> Does this type of installation limit the further connections (occourred in
> same or distinct sql accounts) that exceed the 5 client/user?
> And if this connections aren't limited, are these further connections
> penalized by the query governor like MSDE does?
> In short, is the CAL licensing mode only a legal issue without affecting
> or limiting the performance of the exceeding connections?

It's only a legal issue.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

CAL licenses - don't understand!

Hi
I'm in the process of migrating from hosting web sites on a shared server
and just buying SQL Server DBs when I need them, to a dedicated server which
I have to administer. So now I need to buy a 'proper' copy of SQL Server as
well as the Developer Edition version I develop on.
I read everything I could find about this on the MS site and ended up none
the wiser. If I have a one-processor server serving web sites from its own
copy of IIS, am I ok with the Standard Edition plus 5 CALs? If I host 10
sites on the server, each with its own db, does this use 1 CAL or 10?
I'm so confused!
Thanks for any clarification.Read about "multiplexing". You need to go Per Processor if you don't want to
ensure that everyone
who accesses your web site has a SQL Server CAL.
http://www.microsoft.com/sql/howtobuy/faq.mspx
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tim P" <TimP@.discussions.microsoft.com> wrote in message
news:409D6E35-21E7-4E12-BE01-32BAD2382BA1@.microsoft.com...
> Hi
> I'm in the process of migrating from hosting web sites on a shared server
> and just buying SQL Server DBs when I need them, to a dedicated server whi
ch
> I have to administer. So now I need to buy a 'proper' copy of SQL Server a
s
> well as the Developer Edition version I develop on.
> I read everything I could find about this on the MS site and ended up none
> the wiser. If I have a one-processor server serving web sites from its own
> copy of IIS, am I ok with the Standard Edition plus 5 CALs? If I host 10
> sites on the server, each with its own db, does this use 1 CAL or 10?
> I'm so confused!
> Thanks for any clarification.|||"Tim P" wrote:

> Hi
> I'm in the process of migrating from hosting web sites on a shared server
> and just buying SQL Server DBs when I need them, to a dedicated server whi
ch
> I have to administer. So now I need to buy a 'proper' copy of SQL Server a
s
> well as the Developer Edition version I develop on.
> I read everything I could find about this on the MS site and ended up none
> the wiser. If I have a one-processor server serving web sites from its own
> copy of IIS, am I ok with the Standard Edition plus 5 CALs? If I host 10
> sites on the server, each with its own db, does this use 1 CAL or 10?
> I'm so confused!
> Thanks for any clarification.
If you are hosting a publicly accessible website then you need to purchase a
Processor licence.
If you are hosting an intranet site where you can determine and control the
number of users then you have the option of Processor or CAL licensing. You
need one CAL per end-user or end-user device.
Licensing issues are often difficult and consfusing so if you have any
doubts consult a Microsoft rep or authorised dealer.
David Portas
SQL Server MVP
--|||Ah, that makes sense.
Thanks guys!
"David Portas" wrote:

> "Tim P" wrote:
>
> If you are hosting a publicly accessible website then you need to purchase
a
> Processor licence.
> If you are hosting an intranet site where you can determine and control th
e
> number of users then you have the option of Processor or CAL licensing. Yo
u
> need one CAL per end-user or end-user device.
> Licensing issues are often difficult and consfusing so if you have any
> doubts consult a Microsoft rep or authorised dealer.
> --
> David Portas
> SQL Server MVP
> --
>

CAL licenses - don't understand!

Hi
I'm in the process of migrating from hosting web sites on a shared server
and just buying SQL Server DBs when I need them, to a dedicated server which
I have to administer. So now I need to buy a 'proper' copy of SQL Server as
well as the Developer Edition version I develop on.
I read everything I could find about this on the MS site and ended up none
the wiser. If I have a one-processor server serving web sites from its own
copy of IIS, am I ok with the Standard Edition plus 5 CALs? If I host 10
sites on the server, each with its own db, does this use 1 CAL or 10?
I'm so confused!
Thanks for any clarification.Read about "multiplexing". You need to go Per Processor if you don't want to ensure that everyone
who accesses your web site has a SQL Server CAL.
http://www.microsoft.com/sql/howtobuy/faq.mspx
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tim P" <TimP@.discussions.microsoft.com> wrote in message
news:409D6E35-21E7-4E12-BE01-32BAD2382BA1@.microsoft.com...
> Hi
> I'm in the process of migrating from hosting web sites on a shared server
> and just buying SQL Server DBs when I need them, to a dedicated server which
> I have to administer. So now I need to buy a 'proper' copy of SQL Server as
> well as the Developer Edition version I develop on.
> I read everything I could find about this on the MS site and ended up none
> the wiser. If I have a one-processor server serving web sites from its own
> copy of IIS, am I ok with the Standard Edition plus 5 CALs? If I host 10
> sites on the server, each with its own db, does this use 1 CAL or 10?
> I'm so confused!
> Thanks for any clarification.|||"Tim P" wrote:
> Hi
> I'm in the process of migrating from hosting web sites on a shared server
> and just buying SQL Server DBs when I need them, to a dedicated server which
> I have to administer. So now I need to buy a 'proper' copy of SQL Server as
> well as the Developer Edition version I develop on.
> I read everything I could find about this on the MS site and ended up none
> the wiser. If I have a one-processor server serving web sites from its own
> copy of IIS, am I ok with the Standard Edition plus 5 CALs? If I host 10
> sites on the server, each with its own db, does this use 1 CAL or 10?
> I'm so confused!
> Thanks for any clarification.
If you are hosting a publicly accessible website then you need to purchase a
Processor licence.
If you are hosting an intranet site where you can determine and control the
number of users then you have the option of Processor or CAL licensing. You
need one CAL per end-user or end-user device.
Licensing issues are often difficult and consfusing so if you have any
doubts consult a Microsoft rep or authorised dealer.
--
David Portas
SQL Server MVP
--|||Ah, that makes sense.
Thanks guys!
"David Portas" wrote:
> "Tim P" wrote:
> > Hi
> >
> > I'm in the process of migrating from hosting web sites on a shared server
> > and just buying SQL Server DBs when I need them, to a dedicated server which
> > I have to administer. So now I need to buy a 'proper' copy of SQL Server as
> > well as the Developer Edition version I develop on.
> >
> > I read everything I could find about this on the MS site and ended up none
> > the wiser. If I have a one-processor server serving web sites from its own
> > copy of IIS, am I ok with the Standard Edition plus 5 CALs? If I host 10
> > sites on the server, each with its own db, does this use 1 CAL or 10?
> >
> > I'm so confused!
> >
> > Thanks for any clarification.
> If you are hosting a publicly accessible website then you need to purchase a
> Processor licence.
> If you are hosting an intranet site where you can determine and control the
> number of users then you have the option of Processor or CAL licensing. You
> need one CAL per end-user or end-user device.
> Licensing issues are often difficult and consfusing so if you have any
> doubts consult a Microsoft rep or authorised dealer.
> --
> David Portas
> SQL Server MVP
> --
>

CAL licenses - don't understand!

Hi
I'm in the process of migrating from hosting web sites on a shared server
and just buying SQL Server DBs when I need them, to a dedicated server which
I have to administer. So now I need to buy a 'proper' copy of SQL Server as
well as the Developer Edition version I develop on.
I read everything I could find about this on the MS site and ended up none
the wiser. If I have a one-processor server serving web sites from its own
copy of IIS, am I ok with the Standard Edition plus 5 CALs? If I host 10
sites on the server, each with its own db, does this use 1 CAL or 10?
I'm so confused!
Thanks for any clarification.
Read about "multiplexing". You need to go Per Processor if you don't want to ensure that everyone
who accesses your web site has a SQL Server CAL.
http://www.microsoft.com/sql/howtobuy/faq.mspx
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tim P" <TimP@.discussions.microsoft.com> wrote in message
news:409D6E35-21E7-4E12-BE01-32BAD2382BA1@.microsoft.com...
> Hi
> I'm in the process of migrating from hosting web sites on a shared server
> and just buying SQL Server DBs when I need them, to a dedicated server which
> I have to administer. So now I need to buy a 'proper' copy of SQL Server as
> well as the Developer Edition version I develop on.
> I read everything I could find about this on the MS site and ended up none
> the wiser. If I have a one-processor server serving web sites from its own
> copy of IIS, am I ok with the Standard Edition plus 5 CALs? If I host 10
> sites on the server, each with its own db, does this use 1 CAL or 10?
> I'm so confused!
> Thanks for any clarification.
|||"Tim P" wrote:

> Hi
> I'm in the process of migrating from hosting web sites on a shared server
> and just buying SQL Server DBs when I need them, to a dedicated server which
> I have to administer. So now I need to buy a 'proper' copy of SQL Server as
> well as the Developer Edition version I develop on.
> I read everything I could find about this on the MS site and ended up none
> the wiser. If I have a one-processor server serving web sites from its own
> copy of IIS, am I ok with the Standard Edition plus 5 CALs? If I host 10
> sites on the server, each with its own db, does this use 1 CAL or 10?
> I'm so confused!
> Thanks for any clarification.
If you are hosting a publicly accessible website then you need to purchase a
Processor licence.
If you are hosting an intranet site where you can determine and control the
number of users then you have the option of Processor or CAL licensing. You
need one CAL per end-user or end-user device.
Licensing issues are often difficult and consfusing so if you have any
doubts consult a Microsoft rep or authorised dealer.
David Portas
SQL Server MVP
|||Ah, that makes sense.
Thanks guys!
"David Portas" wrote:

> "Tim P" wrote:
>
> If you are hosting a publicly accessible website then you need to purchase a
> Processor licence.
> If you are hosting an intranet site where you can determine and control the
> number of users then you have the option of Processor or CAL licensing. You
> need one CAL per end-user or end-user device.
> Licensing issues are often difficult and consfusing so if you have any
> doubts consult a Microsoft rep or authorised dealer.
> --
> David Portas
> SQL Server MVP
> --
>

CAL license required?

Microsoft SQL Server 2000 client access license (CAL) licensing terms
states:
A SQL Server CAL is required for a device (for example, a personal
computer, workstation, terminal, personal digital assistant, or
mobile phone) to access or use the services or functionality of
either edition of SQL Server.
I have an application (exe) that accepts TCP/IP connections and stores
the IP addresses of the connecting computers or other devices to a table
stored at SQL Server 2000 Standard Edition database.
Do I have to have a CAL license for every connecting device?
I have an application (exe) that monitors caller numbers from a standard
phone line and stores the caller numbers to a table stored at SQL Server
2000 Standard Edition database.
Do I have to have a CAL license for every calling phone?
SQL Server 2000 CAL licence information can be found at
http://www.microsoft.com/sql/howtobuy/servercal.asp .
Microsoft license information makes it sound like any data that ever passed
through a SQL Server database at some stage in its life has to have a CAL.
We have all been assimilated now...
"JF" <noone@.nowhere.com> wrote in message
news:%23PARv8VVEHA.3264@.TK2MSFTNGP10.phx.gbl...
> Microsoft SQL Server 2000 client access license (CAL) licensing terms
> states:
> A SQL Server CAL is required for a device (for example, a personal
> computer, workstation, terminal, personal digital assistant, or
> mobile phone) to access or use the services or functionality of
> either edition of SQL Server.
> I have an application (exe) that accepts TCP/IP connections and stores
> the IP addresses of the connecting computers or other devices to a table
> stored at SQL Server 2000 Standard Edition database.
> Do I have to have a CAL license for every connecting device?
> I have an application (exe) that monitors caller numbers from a standard
> phone line and stores the caller numbers to a table stored at SQL Server
> 2000 Standard Edition database.
> Do I have to have a CAL license for every calling phone?
> SQL Server 2000 CAL licence information can be found at
> http://www.microsoft.com/sql/howtobuy/servercal.asp .
>
|||Licensing is a very complex beast, but I would guess that for the TCP/IP =
application you would need a CAL for each device that connects. This =
scenario sounds a bit like an internet app (or a multiplexed app), =
therefore you might have to the the per processor licensing route. =20
In the phone case I would guess that you only need one CAL (for the =
exe/phone combination) because you are only logging data as collected by =
your phone line and the exe. This scenario sounds like a service that =
monitors and log events to your database. =20
The difference is slight, but the first scenario has clients connecting =
to it (and to SQL Server). The second example is more like a monitor =
that you have in place.
Don't take my assumptions as right or wrong, they are only a guess.
--=20
Keith
"JF" <noone@.nowhere.com> wrote in message =
news:%23PARv8VVEHA.3264@.TK2MSFTNGP10.phx.gbl...
> Microsoft SQL Server 2000 client access license (CAL) licensing terms=20
> states:
>=20
> A SQL Server CAL is required for a device (for example, a personal
> computer, workstation, terminal, personal digital assistant, or
> mobile phone) to access or use the services or functionality of
> either edition of SQL Server.
>=20
> I have an application (exe) that accepts TCP/IP connections and stores =

> the IP addresses of the connecting computers or other devices to a =
table=20
> stored at SQL Server 2000 Standard Edition database.
> Do I have to have a CAL license for every connecting device?
>=20
> I have an application (exe) that monitors caller numbers from a =
standard=20
> phone line and stores the caller numbers to a table stored at SQL =
Server=20
> 2000 Standard Edition database.
> Do I have to have a CAL license for every calling phone?
>=20
> SQL Server 2000 CAL licence information can be found at=20
> http://www.microsoft.com/sql/howtobuy/servercal.asp .
>
|||If I am reading this correctly you have an application that when other
applications attach to it the first logs the IP address of the second. Does
the second application (or device) then extract data from the database or is
some other process done? If the purpose of the database is to store the IP
addresses captured by the first application you need a CAL for each machine
running that application. in the case of the second scenario you would need
one CAL for the machine running the phone number capturing application and
any other machine involved in extracting that information from the database.
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"JF" <noone@.nowhere.com> wrote in message
news:%23PARv8VVEHA.3264@.TK2MSFTNGP10.phx.gbl...
> Microsoft SQL Server 2000 client access license (CAL) licensing terms
> states:
> A SQL Server CAL is required for a device (for example, a personal
> computer, workstation, terminal, personal digital assistant, or
> mobile phone) to access or use the services or functionality of
> either edition of SQL Server.
> I have an application (exe) that accepts TCP/IP connections and stores
> the IP addresses of the connecting computers or other devices to a table
> stored at SQL Server 2000 Standard Edition database.
> Do I have to have a CAL license for every connecting device?
> I have an application (exe) that monitors caller numbers from a standard
> phone line and stores the caller numbers to a table stored at SQL Server
> 2000 Standard Edition database.
> Do I have to have a CAL license for every calling phone?
> SQL Server 2000 CAL licence information can be found at
> http://www.microsoft.com/sql/howtobuy/servercal.asp .
>

CAL license required?

Microsoft SQL Server 2000 client access license (CAL) licensing terms
states:
A SQL Server CAL is required for a device (for example, a personal
computer, workstation, terminal, personal digital assistant, or
mobile phone) to access or use the services or functionality of
either edition of SQL Server.
I have an application (exe) that accepts TCP/IP connections and stores
the IP addresses of the connecting computers or other devices to a table
stored at SQL Server 2000 Standard Edition database.
Do I have to have a CAL license for every connecting device?
I have an application (exe) that monitors caller numbers from a standard
phone line and stores the caller numbers to a table stored at SQL Server
2000 Standard Edition database.
Do I have to have a CAL license for every calling phone?
SQL Server 2000 CAL licence information can be found at
http://www.microsoft.com/sql/howtobuy/servercal.asp .Microsoft license information makes it sound like any data that ever passed
through a SQL Server database at some stage in its life has to have a CAL.
We have all been assimilated now...
"JF" <noone@.nowhere.com> wrote in message
news:%23PARv8VVEHA.3264@.TK2MSFTNGP10.phx.gbl...
> Microsoft SQL Server 2000 client access license (CAL) licensing terms
> states:
> A SQL Server CAL is required for a device (for example, a personal
> computer, workstation, terminal, personal digital assistant, or
> mobile phone) to access or use the services or functionality of
> either edition of SQL Server.
> I have an application (exe) that accepts TCP/IP connections and stores
> the IP addresses of the connecting computers or other devices to a table
> stored at SQL Server 2000 Standard Edition database.
> Do I have to have a CAL license for every connecting device?
> I have an application (exe) that monitors caller numbers from a standard
> phone line and stores the caller numbers to a table stored at SQL Server
> 2000 Standard Edition database.
> Do I have to have a CAL license for every calling phone?
> SQL Server 2000 CAL licence information can be found at
> http://www.microsoft.com/sql/howtobuy/servercal.asp .
>|||Licensing is a very complex beast, but I would guess that for the TCP/IP =application you would need a CAL for each device that connects. This =scenario sounds a bit like an internet app (or a multiplexed app), =therefore you might have to the the per processor licensing route.
In the phone case I would guess that you only need one CAL (for the =exe/phone combination) because you are only logging data as collected by =your phone line and the exe. This scenario sounds like a service that =monitors and log events to your database.
The difference is slight, but the first scenario has clients connecting =to it (and to SQL Server). The second example is more like a monitor =that you have in place.
Don't take my assumptions as right or wrong, they are only a guess.
-- Keith
"JF" <noone@.nowhere.com> wrote in message =news:%23PARv8VVEHA.3264@.TK2MSFTNGP10.phx.gbl...
> Microsoft SQL Server 2000 client access license (CAL) licensing terms > states:
> > A SQL Server CAL is required for a device (for example, a personal
> computer, workstation, terminal, personal digital assistant, or
> mobile phone) to access or use the services or functionality of
> either edition of SQL Server.
> > I have an application (exe) that accepts TCP/IP connections and stores =
> the IP addresses of the connecting computers or other devices to a =table > stored at SQL Server 2000 Standard Edition database.
> Do I have to have a CAL license for every connecting device?
> > I have an application (exe) that monitors caller numbers from a =standard > phone line and stores the caller numbers to a table stored at SQL =Server > 2000 Standard Edition database.
> Do I have to have a CAL license for every calling phone?
> > SQL Server 2000 CAL licence information can be found at > http://www.microsoft.com/sql/howtobuy/servercal.asp .
>|||If I am reading this correctly you have an application that when other
applications attach to it the first logs the IP address of the second. Does
the second application (or device) then extract data from the database or is
some other process done? If the purpose of the database is to store the IP
addresses captured by the first application you need a CAL for each machine
running that application. in the case of the second scenario you would need
one CAL for the machine running the phone number capturing application and
any other machine involved in extracting that information from the database.
--
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"JF" <noone@.nowhere.com> wrote in message
news:%23PARv8VVEHA.3264@.TK2MSFTNGP10.phx.gbl...
> Microsoft SQL Server 2000 client access license (CAL) licensing terms
> states:
> A SQL Server CAL is required for a device (for example, a personal
> computer, workstation, terminal, personal digital assistant, or
> mobile phone) to access or use the services or functionality of
> either edition of SQL Server.
> I have an application (exe) that accepts TCP/IP connections and stores
> the IP addresses of the connecting computers or other devices to a table
> stored at SQL Server 2000 Standard Edition database.
> Do I have to have a CAL license for every connecting device?
> I have an application (exe) that monitors caller numbers from a standard
> phone line and stores the caller numbers to a table stored at SQL Server
> 2000 Standard Edition database.
> Do I have to have a CAL license for every calling phone?
> SQL Server 2000 CAL licence information can be found at
> http://www.microsoft.com/sql/howtobuy/servercal.asp .
>

CAL license required?

Microsoft SQL Server 2000 client access license (CAL) licensing terms
states:
A SQL Server CAL is required for a device (for example, a personal
computer, workstation, terminal, personal digital assistant, or
mobile phone) to access or use the services or functionality of
either edition of SQL Server.
I have an application (exe) that accepts TCP/IP connections and stores
the IP addresses of the connecting computers or other devices to a table
stored at SQL Server 2000 Standard Edition database.
Do I have to have a CAL license for every connecting device?
I have an application (exe) that monitors caller numbers from a standard
phone line and stores the caller numbers to a table stored at SQL Server
2000 Standard Edition database.
Do I have to have a CAL license for every calling phone?
SQL Server 2000 CAL licence information can be found at
http://www.microsoft.com/sql/howtobuy/servercal.asp .Microsoft license information makes it sound like any data that ever passed
through a SQL Server database at some stage in its life has to have a CAL.
We have all been assimilated now...
"JF" <noone@.nowhere.com> wrote in message
news:%23PARv8VVEHA.3264@.TK2MSFTNGP10.phx.gbl...
> Microsoft SQL Server 2000 client access license (CAL) licensing terms
> states:
> A SQL Server CAL is required for a device (for example, a personal
> computer, workstation, terminal, personal digital assistant, or
> mobile phone) to access or use the services or functionality of
> either edition of SQL Server.
> I have an application (exe) that accepts TCP/IP connections and stores
> the IP addresses of the connecting computers or other devices to a table
> stored at SQL Server 2000 Standard Edition database.
> Do I have to have a CAL license for every connecting device?
> I have an application (exe) that monitors caller numbers from a standard
> phone line and stores the caller numbers to a table stored at SQL Server
> 2000 Standard Edition database.
> Do I have to have a CAL license for every calling phone?
> SQL Server 2000 CAL licence information can be found at
> http://www.microsoft.com/sql/howtobuy/servercal.asp .
>|||Licensing is a very complex beast, but I would guess that for the TCP/IP =
application you would need a CAL for each device that connects. This =
scenario sounds a bit like an internet app (or a multiplexed app), =
therefore you might have to the the per processor licensing route. =20
In the phone case I would guess that you only need one CAL (for the =
exe/phone combination) because you are only logging data as collected by =
your phone line and the exe. This scenario sounds like a service that =
monitors and log events to your database. =20
The difference is slight, but the first scenario has clients connecting =
to it (and to SQL Server). The second example is more like a monitor =
that you have in place.
Don't take my assumptions as right or wrong, they are only a guess.
--=20
Keith
"JF" <noone@.nowhere.com> wrote in message =
news:%23PARv8VVEHA.3264@.TK2MSFTNGP10.phx.gbl...
> Microsoft SQL Server 2000 client access license (CAL) licensing terms=20
> states:
>=20
> A SQL Server CAL is required for a device (for example, a personal
> computer, workstation, terminal, personal digital assistant, or
> mobile phone) to access or use the services or functionality of
> either edition of SQL Server.
>=20
> I have an application (exe) that accepts TCP/IP connections and stores =

> the IP addresses of the connecting computers or other devices to a =
table=20
> stored at SQL Server 2000 Standard Edition database.
> Do I have to have a CAL license for every connecting device?
>=20
> I have an application (exe) that monitors caller numbers from a =
standard=20
> phone line and stores the caller numbers to a table stored at SQL =
Server=20
> 2000 Standard Edition database.
> Do I have to have a CAL license for every calling phone?
>=20
> SQL Server 2000 CAL licence information can be found at=20
> http://www.microsoft.com/sql/howtobuy/servercal.asp .
>|||If I am reading this correctly you have an application that when other
applications attach to it the first logs the IP address of the second. Does
the second application (or device) then extract data from the database or is
some other process done? If the purpose of the database is to store the IP
addresses captured by the first application you need a CAL for each machine
running that application. in the case of the second scenario you would need
one CAL for the machine running the phone number capturing application and
any other machine involved in extracting that information from the database.
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"JF" <noone@.nowhere.com> wrote in message
news:%23PARv8VVEHA.3264@.TK2MSFTNGP10.phx.gbl...
> Microsoft SQL Server 2000 client access license (CAL) licensing terms
> states:
> A SQL Server CAL is required for a device (for example, a personal
> computer, workstation, terminal, personal digital assistant, or
> mobile phone) to access or use the services or functionality of
> either edition of SQL Server.
> I have an application (exe) that accepts TCP/IP connections and stores
> the IP addresses of the connecting computers or other devices to a table
> stored at SQL Server 2000 Standard Edition database.
> Do I have to have a CAL license for every connecting device?
> I have an application (exe) that monitors caller numbers from a standard
> phone line and stores the caller numbers to a table stored at SQL Server
> 2000 Standard Edition database.
> Do I have to have a CAL license for every calling phone?
> SQL Server 2000 CAL licence information can be found at
> http://www.microsoft.com/sql/howtobuy/servercal.asp .
>

CAL license Question

If I have a client that is connecting to a report generated by an SQL server
on a web site, does the workstation that is connecting to the web page need
a CAL?.
I would not think so, as the server is doing all of the connecting to the da
tabase, and the client workstation is only viewing the data that was parsed
on the server into the report.
Thanks,You need a processor license.
"Brian Cook" <anonymous@.discussions.microsoft.com> wrote in message
news:C4EDCFAD-BA16-4149-BC37-6BFA688D385F@.microsoft.com...
> If I have a client that is connecting to a report generated by an SQL
server on a web site, does the workstation that is connecting to the web
page need a CAL?.
> I would not think so, as the server is doing all of the connecting to the
database, and the client workstation is only viewing the data that was
parsed on the server into the report.
> Thanks,
>|||Just to clarify. The SQL Server needs the Per Processor License not the
client. The client does not need a license, since the server needs the Per
Processor license.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||So Rand, are you saying that I cannot use the Server Plus Cal version in tha
t instance?
Also if I have a four node cluster, do I need to have a copy of SQL for each
server in the cluster?
Thanks,
-- Rand Boyd [MSFT] wrote: --
Just to clarify. The SQL Server needs the Per Processor License not the
client. The client does not need a license, since the server needs the Per
Processor license.
Rand
This posting is provided "as is" with no warranties and confers no rights.