Showing posts with label liscensing. Show all posts
Showing posts with label liscensing. Show all posts

Monday, February 20, 2012

Liscensing question

If I purchase SQL 2005 with 25 user CALS, when a user hits a web page that
accesses a database on the SQL Server does that user take a liscense for the
whole web session or only for the time that it takes the web server to query
the database and retrieve information? Basically I am trying to decide how
many and what type of licenses to buy for SQL 2005."Elbryyan" <Elbryyan@.discussions.microsoft.com> wrote in message
news:16D4AAEA-BBB6-4FEE-9EBB-286AD8493837@.microsoft.com...
> If I purchase SQL 2005 with 25 user CALS, when a user hits a web page that
> accesses a database on the SQL Server does that user take a liscense for
> the
> whole web session or only for the time that it takes the web server to
> query
> the database and retrieve information? Basically I am trying to decide
> how
> many and what type of licenses to buy for SQL 2005.
If it is a publicly accessible website, you need a CPU license (for each
physical CPU in the machine.)
However, to really be accurate, you need to contact a Microsoft Licensing
person directly.
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com|||"Elbryyan" <Elbryyan@.discussions.microsoft.com> wrote in message
news:16D4AAEA-BBB6-4FEE-9EBB-286AD8493837@.microsoft.com...
> If I purchase SQL 2005 with 25 user CALS, when a user hits a web page that
> accesses a database on the SQL Server does that user take a liscense for
> the
> whole web session or only for the time that it takes the web server to
> query
> the database and retrieve information? Basically I am trying to decide
> how
> many and what type of licenses to buy for SQL 2005.
Neither. There is no license for "concurrent users". Each user must have a
dedicated CAL. Alternatively, you can assign the CAL to the user's device,
and multiple users can share the device.
How to Buy Microsoft SQL Server
http://www.microsoft.com/sql/howtobuy/default.mspx
David|||If your SQL-Server can be accessed from a web site, you need a CPU license
for it. The SQL-Server with a CPU license cost more than a license for
SQL-Server with 25 user CALs but with it, you don't need any CAL anymore to
access it (not only from the web site but also from any other user or
device).
In this case (at least one access from a web site), the use of a CPU license
is mandatory; so you don't have any choice here.
Finally, if you want an official answer from MS (because the cost of
SQL-Server with a CPU license is high), you can call 1-800-426-9400 in the
US or your regional Microsoft office in other countries.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
"Elbryyan" <Elbryyan@.discussions.microsoft.com> wrote in message
news:16D4AAEA-BBB6-4FEE-9EBB-286AD8493837@.microsoft.com...
> If I purchase SQL 2005 with 25 user CALS, when a user hits a web page that
> accesses a database on the SQL Server does that user take a liscense for
> the
> whole web session or only for the time that it takes the web server to
> query
> the database and retrieve information? Basically I am trying to decide
> how
> many and what type of licenses to buy for SQL 2005.|||This requirement for per CPU applies only if the web server is a publicly
available internet web server. If the web server is an intranet web server
and you can verify that no unlicensed PC's/Users connect to the web server
and can assign CAL's to those PC's and/or users you should be able to use
the per server/CAL model of licensing.
As has been pointed out elsewhere CAL's are assigned to particular users or
PC's/devices. They are usually only transferable once. After that, you have
to buy a new one.
As has been said in multiple places, this is something you don't want to
take the advice of the newsgroup on. It is legal and "the newsgroup said" is
not going to be a valid excuse should you get audited. Read the license
agreements, find a good reseller that can answer your licensing questions,
and call MS if in doubt.
Thanks,
Chuck
"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:OIZlu$dWHHA.528@.TK2MSFTNGP03.phx.gbl...
> If your SQL-Server can be accessed from a web site, you need a CPU license
> for it. The SQL-Server with a CPU license cost more than a license for
> SQL-Server with 25 user CALs but with it, you don't need any CAL anymore
> to access it (not only from the web site but also from any other user or
> device).
> In this case (at least one access from a web site), the use of a CPU
> license is mandatory; so you don't have any choice here.
> Finally, if you want an official answer from MS (because the cost of
> SQL-Server with a CPU license is high), you can call 1-800-426-9400 in the
> US or your regional Microsoft office in other countries.
> --
> Sylvain Lafontaine, ing.
> MVP - Technologies Virtual-PC
> E-mail: sylvain aei ca (fill the blanks, no spam please)
>
> "Elbryyan" <Elbryyan@.discussions.microsoft.com> wrote in message
> news:16D4AAEA-BBB6-4FEE-9EBB-286AD8493837@.microsoft.com...
>> If I purchase SQL 2005 with 25 user CALS, when a user hits a web page
>> that
>> accesses a database on the SQL Server does that user take a liscense for
>> the
>> whole web session or only for the time that it takes the web server to
>> query
>> the database and retrieve information? Basically I am trying to decide
>> how
>> many and what type of licenses to buy for SQL 2005.
>

Liscensing question

If I purchase SQL 2005 with 25 user CALS, when a user hits a web page that
accesses a database on the SQL Server does that user take a liscense for the
whole web session or only for the time that it takes the web server to query
the database and retrieve information? Basically I am trying to decide how
many and what type of licenses to buy for SQL 2005.
"Elbryyan" <Elbryyan@.discussions.microsoft.com> wrote in message
news:16D4AAEA-BBB6-4FEE-9EBB-286AD8493837@.microsoft.com...
> If I purchase SQL 2005 with 25 user CALS, when a user hits a web page that
> accesses a database on the SQL Server does that user take a liscense for
> the
> whole web session or only for the time that it takes the web server to
> query
> the database and retrieve information? Basically I am trying to decide
> how
> many and what type of licenses to buy for SQL 2005.
If it is a publicly accessible website, you need a CPU license (for each
physical CPU in the machine.)
However, to really be accurate, you need to contact a Microsoft Licensing
person directly.
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com
|||"Elbryyan" <Elbryyan@.discussions.microsoft.com> wrote in message
news:16D4AAEA-BBB6-4FEE-9EBB-286AD8493837@.microsoft.com...
> If I purchase SQL 2005 with 25 user CALS, when a user hits a web page that
> accesses a database on the SQL Server does that user take a liscense for
> the
> whole web session or only for the time that it takes the web server to
> query
> the database and retrieve information? Basically I am trying to decide
> how
> many and what type of licenses to buy for SQL 2005.
Neither. There is no license for "concurrent users". Each user must have a
dedicated CAL. Alternatively, you can assign the CAL to the user's device,
and multiple users can share the device.
How to Buy Microsoft SQL Server
http://www.microsoft.com/sql/howtobuy/default.mspx
David
|||If your SQL-Server can be accessed from a web site, you need a CPU license
for it. The SQL-Server with a CPU license cost more than a license for
SQL-Server with 25 user CALs but with it, you don't need any CAL anymore to
access it (not only from the web site but also from any other user or
device).
In this case (at least one access from a web site), the use of a CPU license
is mandatory; so you don't have any choice here.
Finally, if you want an official answer from MS (because the cost of
SQL-Server with a CPU license is high), you can call 1-800-426-9400 in the
US or your regional Microsoft office in other countries.
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
"Elbryyan" <Elbryyan@.discussions.microsoft.com> wrote in message
news:16D4AAEA-BBB6-4FEE-9EBB-286AD8493837@.microsoft.com...
> If I purchase SQL 2005 with 25 user CALS, when a user hits a web page that
> accesses a database on the SQL Server does that user take a liscense for
> the
> whole web session or only for the time that it takes the web server to
> query
> the database and retrieve information? Basically I am trying to decide
> how
> many and what type of licenses to buy for SQL 2005.
|||This requirement for per CPU applies only if the web server is a publicly
available internet web server. If the web server is an intranet web server
and you can verify that no unlicensed PC's/Users connect to the web server
and can assign CAL's to those PC's and/or users you should be able to use
the per server/CAL model of licensing.
As has been pointed out elsewhere CAL's are assigned to particular users or
PC's/devices. They are usually only transferable once. After that, you have
to buy a new one.
As has been said in multiple places, this is something you don't want to
take the advice of the newsgroup on. It is legal and "the newsgroup said" is
not going to be a valid excuse should you get audited. Read the license
agreements, find a good reseller that can answer your licensing questions,
and call MS if in doubt.
Thanks,
Chuck
"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:OIZlu$dWHHA.528@.TK2MSFTNGP03.phx.gbl...
> If your SQL-Server can be accessed from a web site, you need a CPU license
> for it. The SQL-Server with a CPU license cost more than a license for
> SQL-Server with 25 user CALs but with it, you don't need any CAL anymore
> to access it (not only from the web site but also from any other user or
> device).
> In this case (at least one access from a web site), the use of a CPU
> license is mandatory; so you don't have any choice here.
> Finally, if you want an official answer from MS (because the cost of
> SQL-Server with a CPU license is high), you can call 1-800-426-9400 in the
> US or your regional Microsoft office in other countries.
> --
> Sylvain Lafontaine, ing.
> MVP - Technologies Virtual-PC
> E-mail: sylvain aei ca (fill the blanks, no spam please)
>
> "Elbryyan" <Elbryyan@.discussions.microsoft.com> wrote in message
> news:16D4AAEA-BBB6-4FEE-9EBB-286AD8493837@.microsoft.com...
>

Liscensing question

If I purchase SQL 2005 with 25 user CALS, when a user hits a web page that
accesses a database on the SQL Server does that user take a liscense for the
whole web session or only for the time that it takes the web server to query
the database and retrieve information? Basically I am trying to decide how
many and what type of licenses to buy for SQL 2005."Elbryyan" <Elbryyan@.discussions.microsoft.com> wrote in message
news:16D4AAEA-BBB6-4FEE-9EBB-286AD8493837@.microsoft.com...
> If I purchase SQL 2005 with 25 user CALS, when a user hits a web page that
> accesses a database on the SQL Server does that user take a liscense for
> the
> whole web session or only for the time that it takes the web server to
> query
> the database and retrieve information? Basically I am trying to decide
> how
> many and what type of licenses to buy for SQL 2005.
If it is a publicly accessible website, you need a CPU license (for each
physical CPU in the machine.)
However, to really be accurate, you need to contact a Microsoft Licensing
person directly.
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com|||"Elbryyan" <Elbryyan@.discussions.microsoft.com> wrote in message
news:16D4AAEA-BBB6-4FEE-9EBB-286AD8493837@.microsoft.com...
> If I purchase SQL 2005 with 25 user CALS, when a user hits a web page that
> accesses a database on the SQL Server does that user take a liscense for
> the
> whole web session or only for the time that it takes the web server to
> query
> the database and retrieve information? Basically I am trying to decide
> how
> many and what type of licenses to buy for SQL 2005.
Neither. There is no license for "concurrent users". Each user must have a
dedicated CAL. Alternatively, you can assign the CAL to the user's device,
and multiple users can share the device.
How to Buy Microsoft SQL Server
http://www.microsoft.com/sql/howtobuy/default.mspx
David|||If your SQL-Server can be accessed from a web site, you need a CPU license
for it. The SQL-Server with a CPU license cost more than a license for
SQL-Server with 25 user CALs but with it, you don't need any CAL anymore to
access it (not only from the web site but also from any other user or
device).
In this case (at least one access from a web site), the use of a CPU license
is mandatory; so you don't have any choice here.
Finally, if you want an official answer from MS (because the cost of
SQL-Server with a CPU license is high), you can call 1-800-426-9400 in the
US or your regional Microsoft office in other countries.
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
"Elbryyan" <Elbryyan@.discussions.microsoft.com> wrote in message
news:16D4AAEA-BBB6-4FEE-9EBB-286AD8493837@.microsoft.com...
> If I purchase SQL 2005 with 25 user CALS, when a user hits a web page that
> accesses a database on the SQL Server does that user take a liscense for
> the
> whole web session or only for the time that it takes the web server to
> query
> the database and retrieve information? Basically I am trying to decide
> how
> many and what type of licenses to buy for SQL 2005.|||This requirement for per CPU applies only if the web server is a publicly
available internet web server. If the web server is an intranet web server
and you can verify that no unlicensed PC's/Users connect to the web server
and can assign CAL's to those PC's and/or users you should be able to use
the per server/CAL model of licensing.
As has been pointed out elsewhere CAL's are assigned to particular users or
PC's/devices. They are usually only transferable once. After that, you have
to buy a new one.
As has been said in multiple places, this is something you don't want to
take the advice of the newsgroup on. It is legal and "the newsgroup said" is
not going to be a valid excuse should you get audited. Read the license
agreements, find a good reseller that can answer your licensing questions,
and call MS if in doubt.
Thanks,
Chuck
"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:OIZlu$dWHHA.528@.TK2MSFTNGP03.phx.gbl...
> If your SQL-Server can be accessed from a web site, you need a CPU license
> for it. The SQL-Server with a CPU license cost more than a license for
> SQL-Server with 25 user CALs but with it, you don't need any CAL anymore
> to access it (not only from the web site but also from any other user or
> device).
> In this case (at least one access from a web site), the use of a CPU
> license is mandatory; so you don't have any choice here.
> Finally, if you want an official answer from MS (because the cost of
> SQL-Server with a CPU license is high), you can call 1-800-426-9400 in the
> US or your regional Microsoft office in other countries.
> --
> Sylvain Lafontaine, ing.
> MVP - Technologies Virtual-PC
> E-mail: sylvain aei ca (fill the blanks, no spam please)
>
> "Elbryyan" <Elbryyan@.discussions.microsoft.com> wrote in message
> news:16D4AAEA-BBB6-4FEE-9EBB-286AD8493837@.microsoft.com...
>

liscensing for client tools?

We bought SQL2K and have it installed on a server. Can I just go and load
the client tools on all the workstations that I want, or are there
liscensing concerns with doing that? If anyone knows of web page links that
outlines this it would be helpful for me to print that to show management to
make them more comfortable.
Scott
I am guessing that you have purchased the appropriate number of licenses, or
you went with per-processor licensing. In either case you should be ok to
install the client tools on the developer machines.
End users do not need the client tools as they will be accessing the
database via a GUI that you guys wrote or purchased.
Keith
"Schoo" <scott.schuman@.nospam.ma-hc.com> wrote in message
news:uOmkIw7fEHA.3556@.TK2MSFTNGP12.phx.gbl...
> We bought SQL2K and have it installed on a server. Can I just go and load
> the client tools on all the workstations that I want, or are there
> liscensing concerns with doing that? If anyone knows of web page links
that
> outlines this it would be helpful for me to print that to show management
to
> make them more comfortable.
> Scott
>
|||If you have a licensed copy of SQL Server you can install the client tools
on as many machines as you want to connect to this SQL Server. The only
limitation is the concurrent number of users that can connect. This is
governed by your license agreement.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Thanks, Rand!
I could not have said it better myself!
Keith
"Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
news:GWZYLg8fEHA.3212@.cpmsftngxa06.phx.gbl...
> If you have a licensed copy of SQL Server you can install the client tools
> on as many machines as you want to connect to this SQL Server. The only
> limitation is the concurrent number of users that can connect. This is
> governed by your license agreement.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>
|||Rand,
Correct me if I'm wrong, but didn't the "concurrent number of users"
licensing model go away in SQL Server 2000? The original poster didn't
specify what version of SQL Server s/he was using, but in 2000 the only
licensing models are processor licensing and CAL licensing. There is no
license option that simply enforces a limit on the number of concurrent
users. My understanding of the licensing requirements for the tools
(for SQL Server 2000) is this:
1) If the SQL Server license is a processor license, the license allows
unlimited installation of the tools within the organization holding the
processor license, to connect to that licensed server. I'm not sure
where there's an exact definition of "within the organization", but I
assume this means on computers owned by the licensee and used by
employees of the licensee.
2) If the SQL Server license is a server license, then a CAL (client
access license) is required to connect to that server. Whether or not
the tools can be installed and used without connecting to the server,
I'm not sure, but that's likely not the question here. I don't believe
the tools are redistributable, in any case.
http://support.microsoft.com/?id=257716
Steve Kass
Drew University
Rand Boyd [MSFT] wrote:

>If you have a licensed copy of SQL Server you can install the client tools
>on as many machines as you want to connect to this SQL Server. The only
>limitation is the concurrent number of users that can connect. This is
>governed by your license agreement.
>Rand
>This posting is provided "as is" with no warranties and confers no rights.
>
>
|||Steve,
You response is correct. My answer about installing it on an many machines
as you wanted to assumed that the machines would be with in the
organization that owned the license to SQL Server.
Rand
This posting is provided "as is" with no warranties and confers no rights.