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 .
>
Showing posts with label license. Show all posts
Showing posts with label license. Show all posts
Sunday, March 11, 2012
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 .
>
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 .
>
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.
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.
CAL License Question
Under the CAL user licensing model, does each user that has a login to a SQL
Server 2005 database need a CAL, or is one needed for each simultaneous
login? For instance if I have 100 users with access to a SQL database, but
at any given time there are only 25 users accessing a database, do I need 10
0
user CAL's or 25 user CAL's?Wade Bart wrote:
> Under the CAL user licensing model, does each user that has a login to a S
QL
> Server 2005 database need a CAL, or is one needed for each simultaneous
> login? For instance if I have 100 users with access to a SQL database, bu
t
> at any given time there are only 25 users accessing a database, do I need
100
> user CAL's or 25 user CAL's?
It is per user or device, not per concurrent connection.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--
Server 2005 database need a CAL, or is one needed for each simultaneous
login? For instance if I have 100 users with access to a SQL database, but
at any given time there are only 25 users accessing a database, do I need 10
0
user CAL's or 25 user CAL's?Wade Bart wrote:
> Under the CAL user licensing model, does each user that has a login to a S
QL
> Server 2005 database need a CAL, or is one needed for each simultaneous
> login? For instance if I have 100 users with access to a SQL database, bu
t
> at any given time there are only 25 users accessing a database, do I need
100
> user CAL's or 25 user CAL's?
It is per user or device, not per concurrent connection.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--
CAL license question
I want to know how many CAL license do I need. I got an application with 100
users to that application adn there are 10 SQL logins. So do I need to
purchase 100 users or 10 users license on SQL 2000. Or only the concurrent
connection users or if the users got two PC to connect to SQL server, do I
buy 200 ...? Please help. Thanks.100
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
"00KobeBrian" <a@.b.com> wrote in message
news:OJNyRH9dGHA.5016@.TK2MSFTNGP04.phx.gbl...
>I want to know how many CAL license do I need. I got an application with
>100 users to that application adn there are 10 SQL logins. So do I need to
>purchase 100 users or 10 users license on SQL 2000. Or only the concurrent
>connection users or if the users got two PC to connect to SQL server, do I
>buy 200 ...? Please help. Thanks.
>|||Hi,
Additional information:
For licensing questions, you can call 1-800-426-9400 (select option 4),
Monday through Friday, 6:00 A.M. to 5:30 P.M. (PST) to speak directly to a
Microsoft licensing specialist.
Worldwide customers can use the Guide to Worldwide Microsoft Licensing
Sites http://www.microsoft.com/licensing/index/worldwide.asp
to find contact information in their locations.
Best regards,
Vincent Xu
Microsoft Online Partner Support
========================================
==============
Get Secure! - www.microsoft.com/security
========================================
==============
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties,and confers no rights.
========================================
==============
--[vbcol=seagreen]
68.167.251.21[vbcol=seagreen]
rights.[vbcol=seagreen]
to[vbcol=seagreen]
concurrent[vbcol=seagreen]
I[vbcol=seagreen]
users to that application adn there are 10 SQL logins. So do I need to
purchase 100 users or 10 users license on SQL 2000. Or only the concurrent
connection users or if the users got two PC to connect to SQL server, do I
buy 200 ...? Please help. Thanks.100
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
"00KobeBrian" <a@.b.com> wrote in message
news:OJNyRH9dGHA.5016@.TK2MSFTNGP04.phx.gbl...
>I want to know how many CAL license do I need. I got an application with
>100 users to that application adn there are 10 SQL logins. So do I need to
>purchase 100 users or 10 users license on SQL 2000. Or only the concurrent
>connection users or if the users got two PC to connect to SQL server, do I
>buy 200 ...? Please help. Thanks.
>|||Hi,
Additional information:
For licensing questions, you can call 1-800-426-9400 (select option 4),
Monday through Friday, 6:00 A.M. to 5:30 P.M. (PST) to speak directly to a
Microsoft licensing specialist.
Worldwide customers can use the Guide to Worldwide Microsoft Licensing
Sites http://www.microsoft.com/licensing/index/worldwide.asp
to find contact information in their locations.
Best regards,
Vincent Xu
Microsoft Online Partner Support
========================================
==============
Get Secure! - www.microsoft.com/security
========================================
==============
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties,and confers no rights.
========================================
==============
--[vbcol=seagreen]
68.167.251.21[vbcol=seagreen]
rights.[vbcol=seagreen]
to[vbcol=seagreen]
concurrent[vbcol=seagreen]
I[vbcol=seagreen]
CAL License Question
I know that the number of CALs licensed to a given server is stored in some
system table because at one point I had and ran a script to provide that
information. But I either didn't keep the script or didn't name it well as
I
cannot find it. Does anyone know how to query to find this information?Hi,
From Query Analyzer you can Execute
select SERVERPROPERTY('LicenseType')
select SERVERPROPERTY('NumLicenses')
FYI, CALS are not stored in any system table.
Thanks
Hari
SQL Server MVP
"RKinder" <RKinder@.discussions.microsoft.com> wrote in message
news:D22C57DA-4CA4-41CF-B9B7-EE1F8ADDED03@.microsoft.com...
> I know that the number of CALs licensed to a given server is stored in
some
> system table because at one point I had and ran a script to provide that
> information. But I either didn't keep the script or didn't name it well
as I
> cannot find it. Does anyone know how to query to find this information?|||Thank You.
For whatever reason I'm getting Disabled and Null, but I can look into that.
Thanks again.
"Hari Prasad" wrote:
> Hi,
> From Query Analyzer you can Execute
>
> select SERVERPROPERTY('LicenseType')
> select SERVERPROPERTY('NumLicenses')
> FYI, CALS are not stored in any system table.
> Thanks
> Hari
> SQL Server MVP
> "RKinder" <RKinder@.discussions.microsoft.com> wrote in message
> news:D22C57DA-4CA4-41CF-B9B7-EE1F8ADDED03@.microsoft.com...
> some
> as I
>
>|||RKinder wrote:
> Thank You.
> For whatever reason I'm getting Disabled and Null, but I can look
> into that. Thanks again.
>
I believe that's a known issue prior to SP2. What service pack are you
running?
http://support.microsoft.com/defaul...KB;en-us;291332
David Gugick
Imceda Software
www.imceda.com
system table because at one point I had and ran a script to provide that
information. But I either didn't keep the script or didn't name it well as
I
cannot find it. Does anyone know how to query to find this information?Hi,
From Query Analyzer you can Execute
select SERVERPROPERTY('LicenseType')
select SERVERPROPERTY('NumLicenses')
FYI, CALS are not stored in any system table.
Thanks
Hari
SQL Server MVP
"RKinder" <RKinder@.discussions.microsoft.com> wrote in message
news:D22C57DA-4CA4-41CF-B9B7-EE1F8ADDED03@.microsoft.com...
> I know that the number of CALs licensed to a given server is stored in
some
> system table because at one point I had and ran a script to provide that
> information. But I either didn't keep the script or didn't name it well
as I
> cannot find it. Does anyone know how to query to find this information?|||Thank You.
For whatever reason I'm getting Disabled and Null, but I can look into that.
Thanks again.
"Hari Prasad" wrote:
> Hi,
> From Query Analyzer you can Execute
>
> select SERVERPROPERTY('LicenseType')
> select SERVERPROPERTY('NumLicenses')
> FYI, CALS are not stored in any system table.
> Thanks
> Hari
> SQL Server MVP
> "RKinder" <RKinder@.discussions.microsoft.com> wrote in message
> news:D22C57DA-4CA4-41CF-B9B7-EE1F8ADDED03@.microsoft.com...
> some
> as I
>
>|||RKinder wrote:
> Thank You.
> For whatever reason I'm getting Disabled and Null, but I can look
> into that. Thanks again.
>
I believe that's a known issue prior to SP2. What service pack are you
running?
http://support.microsoft.com/defaul...KB;en-us;291332
David Gugick
Imceda Software
www.imceda.com
CAL License Question
Under the CAL user licensing model, does each user that has a login to a SQL
Server 2005 database need a CAL, or is one needed for each simultaneous
login? For instance if I have 100 users with access to a SQL database, but
at any given time there are only 25 users accessing a database, do I need 100
user CAL's or 25 user CAL's?Wade Bart wrote:
> Under the CAL user licensing model, does each user that has a login to a SQL
> Server 2005 database need a CAL, or is one needed for each simultaneous
> login? For instance if I have 100 users with access to a SQL database, but
> at any given time there are only 25 users accessing a database, do I need 100
> user CAL's or 25 user CAL's?
It is per user or device, not per concurrent connection.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--
Server 2005 database need a CAL, or is one needed for each simultaneous
login? For instance if I have 100 users with access to a SQL database, but
at any given time there are only 25 users accessing a database, do I need 100
user CAL's or 25 user CAL's?Wade Bart wrote:
> Under the CAL user licensing model, does each user that has a login to a SQL
> Server 2005 database need a CAL, or is one needed for each simultaneous
> login? For instance if I have 100 users with access to a SQL database, but
> at any given time there are only 25 users accessing a database, do I need 100
> user CAL's or 25 user CAL's?
It is per user or device, not per concurrent connection.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--
CAL License Question
I know that the number of CALs licensed to a given server is stored in some
system table because at one point I had and ran a script to provide that
information. But I either didn't keep the script or didn't name it well as I
cannot find it. Does anyone know how to query to find this information?Hi,
From Query Analyzer you can Execute
select SERVERPROPERTY('LicenseType')
select SERVERPROPERTY('NumLicenses')
FYI, CALS are not stored in any system table.
Thanks
Hari
SQL Server MVP
"RKinder" <RKinder@.discussions.microsoft.com> wrote in message
news:D22C57DA-4CA4-41CF-B9B7-EE1F8ADDED03@.microsoft.com...
> I know that the number of CALs licensed to a given server is stored in
some
> system table because at one point I had and ran a script to provide that
> information. But I either didn't keep the script or didn't name it well
as I
> cannot find it. Does anyone know how to query to find this information?|||Thank You.
For whatever reason I'm getting Disabled and Null, but I can look into that.
Thanks again.
"Hari Prasad" wrote:
> Hi,
> From Query Analyzer you can Execute
>
> select SERVERPROPERTY('LicenseType')
> select SERVERPROPERTY('NumLicenses')
> FYI, CALS are not stored in any system table.
> Thanks
> Hari
> SQL Server MVP
> "RKinder" <RKinder@.discussions.microsoft.com> wrote in message
> news:D22C57DA-4CA4-41CF-B9B7-EE1F8ADDED03@.microsoft.com...
> > I know that the number of CALs licensed to a given server is stored in
> some
> > system table because at one point I had and ran a script to provide that
> > information. But I either didn't keep the script or didn't name it well
> as I
> > cannot find it. Does anyone know how to query to find this information?
>
>|||RKinder wrote:
> Thank You.
> For whatever reason I'm getting Disabled and Null, but I can look
> into that. Thanks again.
>
I believe that's a known issue prior to SP2. What service pack are you
running?
http://support.microsoft.com/default.aspx?scid=KB;en-us;291332
--
David Gugick
Imceda Software
www.imceda.com
system table because at one point I had and ran a script to provide that
information. But I either didn't keep the script or didn't name it well as I
cannot find it. Does anyone know how to query to find this information?Hi,
From Query Analyzer you can Execute
select SERVERPROPERTY('LicenseType')
select SERVERPROPERTY('NumLicenses')
FYI, CALS are not stored in any system table.
Thanks
Hari
SQL Server MVP
"RKinder" <RKinder@.discussions.microsoft.com> wrote in message
news:D22C57DA-4CA4-41CF-B9B7-EE1F8ADDED03@.microsoft.com...
> I know that the number of CALs licensed to a given server is stored in
some
> system table because at one point I had and ran a script to provide that
> information. But I either didn't keep the script or didn't name it well
as I
> cannot find it. Does anyone know how to query to find this information?|||Thank You.
For whatever reason I'm getting Disabled and Null, but I can look into that.
Thanks again.
"Hari Prasad" wrote:
> Hi,
> From Query Analyzer you can Execute
>
> select SERVERPROPERTY('LicenseType')
> select SERVERPROPERTY('NumLicenses')
> FYI, CALS are not stored in any system table.
> Thanks
> Hari
> SQL Server MVP
> "RKinder" <RKinder@.discussions.microsoft.com> wrote in message
> news:D22C57DA-4CA4-41CF-B9B7-EE1F8ADDED03@.microsoft.com...
> > I know that the number of CALs licensed to a given server is stored in
> some
> > system table because at one point I had and ran a script to provide that
> > information. But I either didn't keep the script or didn't name it well
> as I
> > cannot find it. Does anyone know how to query to find this information?
>
>|||RKinder wrote:
> Thank You.
> For whatever reason I'm getting Disabled and Null, but I can look
> into that. Thanks again.
>
I believe that's a known issue prior to SP2. What service pack are you
running?
http://support.microsoft.com/default.aspx?scid=KB;en-us;291332
--
David Gugick
Imceda Software
www.imceda.com
CAL license question
I want to know how many CAL license do I need. I got an application with 100
users to that application adn there are 10 SQL logins. So do I need to
purchase 100 users or 10 users license on SQL 2000. Or only the concurrent
connection users or if the users got two PC to connect to SQL server, do I
buy 200 ...? Please help. Thanks.100
--
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
"00KobeBrian" <a@.b.com> wrote in message
news:OJNyRH9dGHA.5016@.TK2MSFTNGP04.phx.gbl...
>I want to know how many CAL license do I need. I got an application with
>100 users to that application adn there are 10 SQL logins. So do I need to
>purchase 100 users or 10 users license on SQL 2000. Or only the concurrent
>connection users or if the users got two PC to connect to SQL server, do I
>buy 200 ...? Please help. Thanks.
>|||Hi,
Additional information:
For licensing questions, you can call 1-800-426-9400 (select option 4),
Monday through Friday, 6:00 A.M. to 5:30 P.M. (PST) to speak directly to a
Microsoft licensing specialist.
Worldwide customers can use the Guide to Worldwide Microsoft Licensing
Sites http://www.microsoft.com/licensing/index/worldwide.asp
to find contact information in their locations.
Best regards,
Vincent Xu
Microsoft Online Partner Support
======================================================
Get Secure! - www.microsoft.com/security
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties,and confers no rights.
======================================================>>From: "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com>
>>References: <OJNyRH9dGHA.5016@.TK2MSFTNGP04.phx.gbl>
>>Subject: Re: CAL license question
>>Date: Sun, 14 May 2006 21:15:22 -0700
>>Lines: 17
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
>>X-RFC2646: Format=Flowed; Response
>>Message-ID: <OvIrtY9dGHA.3484@.TK2MSFTNGP04.phx.gbl>
>>Newsgroups: microsoft.public.sqlserver.server
>>NNTP-Posting-Host: h-68-167-251-21.sttnwaho.dynamic.covad.net
68.167.251.21
>>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP04.phx.gbl
>>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:431469
>>X-Tomcat-NG: microsoft.public.sqlserver.server
>>100
>>--
>>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
>>"00KobeBrian" <a@.b.com> wrote in message
>>news:OJNyRH9dGHA.5016@.TK2MSFTNGP04.phx.gbl...
>>I want to know how many CAL license do I need. I got an application with
>>100 users to that application adn there are 10 SQL logins. So do I need
to
>>purchase 100 users or 10 users license on SQL 2000. Or only the
concurrent
>>connection users or if the users got two PC to connect to SQL server, do
I
>>buy 200 ...? Please help. Thanks.
>>
>>
users to that application adn there are 10 SQL logins. So do I need to
purchase 100 users or 10 users license on SQL 2000. Or only the concurrent
connection users or if the users got two PC to connect to SQL server, do I
buy 200 ...? Please help. Thanks.100
--
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
"00KobeBrian" <a@.b.com> wrote in message
news:OJNyRH9dGHA.5016@.TK2MSFTNGP04.phx.gbl...
>I want to know how many CAL license do I need. I got an application with
>100 users to that application adn there are 10 SQL logins. So do I need to
>purchase 100 users or 10 users license on SQL 2000. Or only the concurrent
>connection users or if the users got two PC to connect to SQL server, do I
>buy 200 ...? Please help. Thanks.
>|||Hi,
Additional information:
For licensing questions, you can call 1-800-426-9400 (select option 4),
Monday through Friday, 6:00 A.M. to 5:30 P.M. (PST) to speak directly to a
Microsoft licensing specialist.
Worldwide customers can use the Guide to Worldwide Microsoft Licensing
Sites http://www.microsoft.com/licensing/index/worldwide.asp
to find contact information in their locations.
Best regards,
Vincent Xu
Microsoft Online Partner Support
======================================================
Get Secure! - www.microsoft.com/security
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties,and confers no rights.
======================================================>>From: "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com>
>>References: <OJNyRH9dGHA.5016@.TK2MSFTNGP04.phx.gbl>
>>Subject: Re: CAL license question
>>Date: Sun, 14 May 2006 21:15:22 -0700
>>Lines: 17
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
>>X-RFC2646: Format=Flowed; Response
>>Message-ID: <OvIrtY9dGHA.3484@.TK2MSFTNGP04.phx.gbl>
>>Newsgroups: microsoft.public.sqlserver.server
>>NNTP-Posting-Host: h-68-167-251-21.sttnwaho.dynamic.covad.net
68.167.251.21
>>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP04.phx.gbl
>>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:431469
>>X-Tomcat-NG: microsoft.public.sqlserver.server
>>100
>>--
>>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
>>"00KobeBrian" <a@.b.com> wrote in message
>>news:OJNyRH9dGHA.5016@.TK2MSFTNGP04.phx.gbl...
>>I want to know how many CAL license do I need. I got an application with
>>100 users to that application adn there are 10 SQL logins. So do I need
to
>>purchase 100 users or 10 users license on SQL 2000. Or only the
concurrent
>>connection users or if the users got two PC to connect to SQL server, do
I
>>buy 200 ...? Please help. Thanks.
>>
>>
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 database, 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 that 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.
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,
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 that 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.
CAL License Question
I know that the number of CALs licensed to a given server is stored in some
system table because at one point I had and ran a script to provide that
information. But I either didn't keep the script or didn't name it well as I
cannot find it. Does anyone know how to query to find this information?
Hi,
From Query Analyzer you can Execute
select SERVERPROPERTY('LicenseType')
select SERVERPROPERTY('NumLicenses')
FYI, CALS are not stored in any system table.
Thanks
Hari
SQL Server MVP
"RKinder" <RKinder@.discussions.microsoft.com> wrote in message
news:D22C57DA-4CA4-41CF-B9B7-EE1F8ADDED03@.microsoft.com...
> I know that the number of CALs licensed to a given server is stored in
some
> system table because at one point I had and ran a script to provide that
> information. But I either didn't keep the script or didn't name it well
as I
> cannot find it. Does anyone know how to query to find this information?
|||Thank You.
For whatever reason I'm getting Disabled and Null, but I can look into that.
Thanks again.
"Hari Prasad" wrote:
> Hi,
> From Query Analyzer you can Execute
>
> select SERVERPROPERTY('LicenseType')
> select SERVERPROPERTY('NumLicenses')
> FYI, CALS are not stored in any system table.
> Thanks
> Hari
> SQL Server MVP
> "RKinder" <RKinder@.discussions.microsoft.com> wrote in message
> news:D22C57DA-4CA4-41CF-B9B7-EE1F8ADDED03@.microsoft.com...
> some
> as I
>
>
|||RKinder wrote:
> Thank You.
> For whatever reason I'm getting Disabled and Null, but I can look
> into that. Thanks again.
>
I believe that's a known issue prior to SP2. What service pack are you
running?
http://support.microsoft.com/default...B;en-us;291332
David Gugick
Imceda Software
www.imceda.com
system table because at one point I had and ran a script to provide that
information. But I either didn't keep the script or didn't name it well as I
cannot find it. Does anyone know how to query to find this information?
Hi,
From Query Analyzer you can Execute
select SERVERPROPERTY('LicenseType')
select SERVERPROPERTY('NumLicenses')
FYI, CALS are not stored in any system table.
Thanks
Hari
SQL Server MVP
"RKinder" <RKinder@.discussions.microsoft.com> wrote in message
news:D22C57DA-4CA4-41CF-B9B7-EE1F8ADDED03@.microsoft.com...
> I know that the number of CALs licensed to a given server is stored in
some
> system table because at one point I had and ran a script to provide that
> information. But I either didn't keep the script or didn't name it well
as I
> cannot find it. Does anyone know how to query to find this information?
|||Thank You.
For whatever reason I'm getting Disabled and Null, but I can look into that.
Thanks again.
"Hari Prasad" wrote:
> Hi,
> From Query Analyzer you can Execute
>
> select SERVERPROPERTY('LicenseType')
> select SERVERPROPERTY('NumLicenses')
> FYI, CALS are not stored in any system table.
> Thanks
> Hari
> SQL Server MVP
> "RKinder" <RKinder@.discussions.microsoft.com> wrote in message
> news:D22C57DA-4CA4-41CF-B9B7-EE1F8ADDED03@.microsoft.com...
> some
> as I
>
>
|||RKinder wrote:
> Thank You.
> For whatever reason I'm getting Disabled and Null, but I can look
> into that. Thanks again.
>
I believe that's a known issue prior to SP2. What service pack are you
running?
http://support.microsoft.com/default...B;en-us;291332
David Gugick
Imceda Software
www.imceda.com
CAL
I know CAL stands for Client access license, does this mean if I have an
application that logs onto SQL as a generic user, is that one CAL? Do I need
a CAL for each of my application generic users? Des this go for each user I
have in SQL?
TIA,
JoeA CAL covers a connection to the DB, so whether your using a generic login
or user specific logins each is a seperate CAL.|||A CAL covers either a user or a device that connects to SQL. The gotcha is
that only end users or devices count. If you have a web server or other
device that collects end users and feeds them through a single device
connections, then you have to license each end user, not just the single
middle-ware device. Licensed users can have multiple connections so there
is not any relationship between licensed users and connections. If you have
a situation where you cannot enumerate each licensed user, such as a
public-facing web site, then you must license SQLnon a per-processor basis.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:DBCCB86D-7367-4AC5-9B9E-440CA72C31C1@.microsoft.com...
>I know CAL stands for Client access license, does this mean if I have an
> application that logs onto SQL as a generic user, is that one CAL? Do I
> need
> a CAL for each of my application generic users? Des this go for each user
> I
> have in SQL?
> TIA,
> Joe
>|||Thank you.
This was very helpful.
Joe
"Geoff N. Hiten" wrote:
> A CAL covers either a user or a device that connects to SQL. The gotcha is
> that only end users or devices count. If you have a web server or other
> device that collects end users and feeds them through a single device
> connections, then you have to license each end user, not just the single
> middle-ware device. Licensed users can have multiple connections so there
> is not any relationship between licensed users and connections. If you have
> a situation where you cannot enumerate each licensed user, such as a
> public-facing web site, then you must license SQLnon a per-processor basis.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "jaylou" <jaylou@.discussions.microsoft.com> wrote in message
> news:DBCCB86D-7367-4AC5-9B9E-440CA72C31C1@.microsoft.com...
> >I know CAL stands for Client access license, does this mean if I have an
> > application that logs onto SQL as a generic user, is that one CAL? Do I
> > need
> > a CAL for each of my application generic users? Des this go for each user
> > I
> > have in SQL?
> >
> > TIA,
> > Joe
> >
>
>|||Thank you,
This was very helpful
Joe
"BenUK" wrote:
> A CAL covers a connection to the DB, so whether your using a generic login
> or user specific logins each is a seperate CAL.
application that logs onto SQL as a generic user, is that one CAL? Do I need
a CAL for each of my application generic users? Des this go for each user I
have in SQL?
TIA,
JoeA CAL covers a connection to the DB, so whether your using a generic login
or user specific logins each is a seperate CAL.|||A CAL covers either a user or a device that connects to SQL. The gotcha is
that only end users or devices count. If you have a web server or other
device that collects end users and feeds them through a single device
connections, then you have to license each end user, not just the single
middle-ware device. Licensed users can have multiple connections so there
is not any relationship between licensed users and connections. If you have
a situation where you cannot enumerate each licensed user, such as a
public-facing web site, then you must license SQLnon a per-processor basis.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:DBCCB86D-7367-4AC5-9B9E-440CA72C31C1@.microsoft.com...
>I know CAL stands for Client access license, does this mean if I have an
> application that logs onto SQL as a generic user, is that one CAL? Do I
> need
> a CAL for each of my application generic users? Des this go for each user
> I
> have in SQL?
> TIA,
> Joe
>|||Thank you.
This was very helpful.
Joe
"Geoff N. Hiten" wrote:
> A CAL covers either a user or a device that connects to SQL. The gotcha is
> that only end users or devices count. If you have a web server or other
> device that collects end users and feeds them through a single device
> connections, then you have to license each end user, not just the single
> middle-ware device. Licensed users can have multiple connections so there
> is not any relationship between licensed users and connections. If you have
> a situation where you cannot enumerate each licensed user, such as a
> public-facing web site, then you must license SQLnon a per-processor basis.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "jaylou" <jaylou@.discussions.microsoft.com> wrote in message
> news:DBCCB86D-7367-4AC5-9B9E-440CA72C31C1@.microsoft.com...
> >I know CAL stands for Client access license, does this mean if I have an
> > application that logs onto SQL as a generic user, is that one CAL? Do I
> > need
> > a CAL for each of my application generic users? Des this go for each user
> > I
> > have in SQL?
> >
> > TIA,
> > Joe
> >
>
>|||Thank you,
This was very helpful
Joe
"BenUK" wrote:
> A CAL covers a connection to the DB, so whether your using a generic login
> or user specific logins each is a seperate CAL.
CAL
I know CAL stands for Client access license, does this mean if I have an
application that logs onto SQL as a generic user, is that one CAL? Do I nee
d
a CAL for each of my application generic users? Des this go for each user I
have in SQL?
TIA,
JoeA CAL covers a connection to the DB, so whether your using a generic login
or user specific logins each is a seperate CAL.|||A CAL covers either a user or a device that connects to SQL. The gotcha is
that only end users or devices count. If you have a web server or other
device that collects end users and feeds them through a single device
connections, then you have to license each end user, not just the single
middle-ware device. Licensed users can have multiple connections so there
is not any relationship between licensed users and connections. If you have
a situation where you cannot enumerate each licensed user, such as a
public-facing web site, then you must license SQLnon a per-processor basis.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:DBCCB86D-7367-4AC5-9B9E-440CA72C31C1@.microsoft.com...
>I know CAL stands for Client access license, does this mean if I have an
> application that logs onto SQL as a generic user, is that one CAL? Do I
> need
> a CAL for each of my application generic users? Des this go for each user
> I
> have in SQL?
> TIA,
> Joe
>|||Thank you.
This was very helpful.
Joe
"Geoff N. Hiten" wrote:
> A CAL covers either a user or a device that connects to SQL. The gotcha i
s
> that only end users or devices count. If you have a web server or other
> device that collects end users and feeds them through a single device
> connections, then you have to license each end user, not just the single
> middle-ware device. Licensed users can have multiple connections so there
> is not any relationship between licensed users and connections. If you ha
ve
> a situation where you cannot enumerate each licensed user, such as a
> public-facing web site, then you must license SQLnon a per-processor basis
.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "jaylou" <jaylou@.discussions.microsoft.com> wrote in message
> news:DBCCB86D-7367-4AC5-9B9E-440CA72C31C1@.microsoft.com...
>
>|||Thank you,
This was very helpful
Joe
"BenUK" wrote:
> A CAL covers a connection to the DB, so whether your using a generic login
> or user specific logins each is a seperate CAL.
application that logs onto SQL as a generic user, is that one CAL? Do I nee
d
a CAL for each of my application generic users? Des this go for each user I
have in SQL?
TIA,
JoeA CAL covers a connection to the DB, so whether your using a generic login
or user specific logins each is a seperate CAL.|||A CAL covers either a user or a device that connects to SQL. The gotcha is
that only end users or devices count. If you have a web server or other
device that collects end users and feeds them through a single device
connections, then you have to license each end user, not just the single
middle-ware device. Licensed users can have multiple connections so there
is not any relationship between licensed users and connections. If you have
a situation where you cannot enumerate each licensed user, such as a
public-facing web site, then you must license SQLnon a per-processor basis.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:DBCCB86D-7367-4AC5-9B9E-440CA72C31C1@.microsoft.com...
>I know CAL stands for Client access license, does this mean if I have an
> application that logs onto SQL as a generic user, is that one CAL? Do I
> need
> a CAL for each of my application generic users? Des this go for each user
> I
> have in SQL?
> TIA,
> Joe
>|||Thank you.
This was very helpful.
Joe
"Geoff N. Hiten" wrote:
> A CAL covers either a user or a device that connects to SQL. The gotcha i
s
> that only end users or devices count. If you have a web server or other
> device that collects end users and feeds them through a single device
> connections, then you have to license each end user, not just the single
> middle-ware device. Licensed users can have multiple connections so there
> is not any relationship between licensed users and connections. If you ha
ve
> a situation where you cannot enumerate each licensed user, such as a
> public-facing web site, then you must license SQLnon a per-processor basis
.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "jaylou" <jaylou@.discussions.microsoft.com> wrote in message
> news:DBCCB86D-7367-4AC5-9B9E-440CA72C31C1@.microsoft.com...
>
>|||Thank you,
This was very helpful
Joe
"BenUK" wrote:
> A CAL covers a connection to the DB, so whether your using a generic login
> or user specific logins each is a seperate CAL.
CAL
I know CAL stands for Client access license, does this mean if I have an
application that logs onto SQL as a generic user, is that one CAL? Do I need
a CAL for each of my application generic users? Des this go for each user I
have in SQL?
TIA,
Joe
A CAL covers a connection to the DB, so whether your using a generic login
or user specific logins each is a seperate CAL.
|||A CAL covers either a user or a device that connects to SQL. The gotcha is
that only end users or devices count. If you have a web server or other
device that collects end users and feeds them through a single device
connections, then you have to license each end user, not just the single
middle-ware device. Licensed users can have multiple connections so there
is not any relationship between licensed users and connections. If you have
a situation where you cannot enumerate each licensed user, such as a
public-facing web site, then you must license SQLnon a per-processor basis.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:DBCCB86D-7367-4AC5-9B9E-440CA72C31C1@.microsoft.com...
>I know CAL stands for Client access license, does this mean if I have an
> application that logs onto SQL as a generic user, is that one CAL? Do I
> need
> a CAL for each of my application generic users? Des this go for each user
> I
> have in SQL?
> TIA,
> Joe
>
|||Thank you.
This was very helpful.
Joe
"Geoff N. Hiten" wrote:
> A CAL covers either a user or a device that connects to SQL. The gotcha is
> that only end users or devices count. If you have a web server or other
> device that collects end users and feeds them through a single device
> connections, then you have to license each end user, not just the single
> middle-ware device. Licensed users can have multiple connections so there
> is not any relationship between licensed users and connections. If you have
> a situation where you cannot enumerate each licensed user, such as a
> public-facing web site, then you must license SQLnon a per-processor basis.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "jaylou" <jaylou@.discussions.microsoft.com> wrote in message
> news:DBCCB86D-7367-4AC5-9B9E-440CA72C31C1@.microsoft.com...
>
>
|||Thank you,
This was very helpful
Joe
"BenUK" wrote:
> A CAL covers a connection to the DB, so whether your using a generic login
> or user specific logins each is a seperate CAL.
application that logs onto SQL as a generic user, is that one CAL? Do I need
a CAL for each of my application generic users? Des this go for each user I
have in SQL?
TIA,
Joe
A CAL covers a connection to the DB, so whether your using a generic login
or user specific logins each is a seperate CAL.
|||A CAL covers either a user or a device that connects to SQL. The gotcha is
that only end users or devices count. If you have a web server or other
device that collects end users and feeds them through a single device
connections, then you have to license each end user, not just the single
middle-ware device. Licensed users can have multiple connections so there
is not any relationship between licensed users and connections. If you have
a situation where you cannot enumerate each licensed user, such as a
public-facing web site, then you must license SQLnon a per-processor basis.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:DBCCB86D-7367-4AC5-9B9E-440CA72C31C1@.microsoft.com...
>I know CAL stands for Client access license, does this mean if I have an
> application that logs onto SQL as a generic user, is that one CAL? Do I
> need
> a CAL for each of my application generic users? Des this go for each user
> I
> have in SQL?
> TIA,
> Joe
>
|||Thank you.
This was very helpful.
Joe
"Geoff N. Hiten" wrote:
> A CAL covers either a user or a device that connects to SQL. The gotcha is
> that only end users or devices count. If you have a web server or other
> device that collects end users and feeds them through a single device
> connections, then you have to license each end user, not just the single
> middle-ware device. Licensed users can have multiple connections so there
> is not any relationship between licensed users and connections. If you have
> a situation where you cannot enumerate each licensed user, such as a
> public-facing web site, then you must license SQLnon a per-processor basis.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "jaylou" <jaylou@.discussions.microsoft.com> wrote in message
> news:DBCCB86D-7367-4AC5-9B9E-440CA72C31C1@.microsoft.com...
>
>
|||Thank you,
This was very helpful
Joe
"BenUK" wrote:
> A CAL covers a connection to the DB, so whether your using a generic login
> or user specific logins each is a seperate CAL.
Subscribe to:
Posts (Atom)