I have a server with 4 processors. I was looking at buying SQL 2000 1
processor, but since I have 4 processors would I need to get 4 copies?
That would be a little pricey! The MS FAQ Site says:
Q. Do I have to license all of the processors in a server?
A. You only have to acquire licenses for processors that are accessible to
any copy of the operating system upon which SQL Server 2000 is installed.
What does this mean? I don't know a lot about multi-processor servers.
Would only one of the processors have access to the OS??
TIA!!!
You would have to remove 3 processors from the machine. Or use some setting in the BIOS so that the
operating system only sees one of the processors.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Qyl" <Qyl@.discussions.microsoft.com> wrote in message
news:C2071336-12AE-4CA4-9E2A-F6A6F2659496@.microsoft.com...
>I have a server with 4 processors. I was looking at buying SQL 2000 1
> processor, but since I have 4 processors would I need to get 4 copies?
> That would be a little pricey! The MS FAQ Site says:
> Q. Do I have to license all of the processors in a server?
> A. You only have to acquire licenses for processors that are accessible to
> any copy of the operating system upon which SQL Server 2000 is installed.
> What does this mean? I don't know a lot about multi-processor servers.
> Would only one of the processors have access to the OS??
> TIA!!!
>
>
|||Have you considered Server + CAL licensing instead? Processor licensing
is required if this is for a web server but otherwise CAL licensing may
save you money.
David Portas
SQL Server MVP
sql
Showing posts with label licensing. Show all posts
Showing posts with label licensing. Show all posts
Wednesday, March 28, 2012
multi processor licensing
I have a server with 4 processors. I was looking at buying SQL 2000 1
processor, but since I have 4 processors would I need to get 4 copies?
That would be a little pricey! The MS FAQ Site says:
Q. Do I have to license all of the processors in a server?
A. You only have to acquire licenses for processors that are accessible to
any copy of the operating system upon which SQL Server 2000 is installed.
What does this mean? I don't know a lot about multi-processor servers.
Would only one of the processors have access to the OS'?
TIA!!!You would have to remove 3 processors from the machine. Or use some setting
in the BIOS so that the
operating system only sees one of the processors.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Qyl" <Qyl@.discussions.microsoft.com> wrote in message
news:C2071336-12AE-4CA4-9E2A-F6A6F2659496@.microsoft.com...
>I have a server with 4 processors. I was looking at buying SQL 2000 1
> processor, but since I have 4 processors would I need to get 4 copies?
> That would be a little pricey! The MS FAQ Site says:
> Q. Do I have to license all of the processors in a server?
> A. You only have to acquire licenses for processors that are accessible t
o
> any copy of the operating system upon which SQL Server 2000 is installed.
> What does this mean? I don't know a lot about multi-processor servers.
> Would only one of the processors have access to the OS'?
> TIA!!!
>
>|||Have you considered Server + CAL licensing instead? Processor licensing
is required if this is for a web server but otherwise CAL licensing may
save you money.
David Portas
SQL Server MVP
--
processor, but since I have 4 processors would I need to get 4 copies?
That would be a little pricey! The MS FAQ Site says:
Q. Do I have to license all of the processors in a server?
A. You only have to acquire licenses for processors that are accessible to
any copy of the operating system upon which SQL Server 2000 is installed.
What does this mean? I don't know a lot about multi-processor servers.
Would only one of the processors have access to the OS'?
TIA!!!You would have to remove 3 processors from the machine. Or use some setting
in the BIOS so that the
operating system only sees one of the processors.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Qyl" <Qyl@.discussions.microsoft.com> wrote in message
news:C2071336-12AE-4CA4-9E2A-F6A6F2659496@.microsoft.com...
>I have a server with 4 processors. I was looking at buying SQL 2000 1
> processor, but since I have 4 processors would I need to get 4 copies?
> That would be a little pricey! The MS FAQ Site says:
> Q. Do I have to license all of the processors in a server?
> A. You only have to acquire licenses for processors that are accessible t
o
> any copy of the operating system upon which SQL Server 2000 is installed.
> What does this mean? I don't know a lot about multi-processor servers.
> Would only one of the processors have access to the OS'?
> TIA!!!
>
>|||Have you considered Server + CAL licensing instead? Processor licensing
is required if this is for a web server but otherwise CAL licensing may
save you money.
David Portas
SQL Server MVP
--
multi processor licensing
I have a server with 4 processors. I was looking at buying SQL 2000 1
processor, but since I have 4 processors would I need to get 4 copies?
That would be a little pricey! The MS FAQ Site says:
Q. Do I have to license all of the processors in a server?
A. You only have to acquire licenses for processors that are accessible to
any copy of the operating system upon which SQL Server 2000 is installed.
What does this mean? I don't know a lot about multi-processor servers.
Would only one of the processors have access to the OS'?
TIA!!!You would have to remove 3 processors from the machine. Or use some setting in the BIOS so that the
operating system only sees one of the processors.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Qyl" <Qyl@.discussions.microsoft.com> wrote in message
news:C2071336-12AE-4CA4-9E2A-F6A6F2659496@.microsoft.com...
>I have a server with 4 processors. I was looking at buying SQL 2000 1
> processor, but since I have 4 processors would I need to get 4 copies?
> That would be a little pricey! The MS FAQ Site says:
> Q. Do I have to license all of the processors in a server?
> A. You only have to acquire licenses for processors that are accessible to
> any copy of the operating system upon which SQL Server 2000 is installed.
> What does this mean? I don't know a lot about multi-processor servers.
> Would only one of the processors have access to the OS'?
> TIA!!!
>
>|||Have you considered Server + CAL licensing instead? Processor licensing
is required if this is for a web server but otherwise CAL licensing may
save you money.
--
David Portas
SQL Server MVP
--
processor, but since I have 4 processors would I need to get 4 copies?
That would be a little pricey! The MS FAQ Site says:
Q. Do I have to license all of the processors in a server?
A. You only have to acquire licenses for processors that are accessible to
any copy of the operating system upon which SQL Server 2000 is installed.
What does this mean? I don't know a lot about multi-processor servers.
Would only one of the processors have access to the OS'?
TIA!!!You would have to remove 3 processors from the machine. Or use some setting in the BIOS so that the
operating system only sees one of the processors.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Qyl" <Qyl@.discussions.microsoft.com> wrote in message
news:C2071336-12AE-4CA4-9E2A-F6A6F2659496@.microsoft.com...
>I have a server with 4 processors. I was looking at buying SQL 2000 1
> processor, but since I have 4 processors would I need to get 4 copies?
> That would be a little pricey! The MS FAQ Site says:
> Q. Do I have to license all of the processors in a server?
> A. You only have to acquire licenses for processors that are accessible to
> any copy of the operating system upon which SQL Server 2000 is installed.
> What does this mean? I don't know a lot about multi-processor servers.
> Would only one of the processors have access to the OS'?
> TIA!!!
>
>|||Have you considered Server + CAL licensing instead? Processor licensing
is required if this is for a web server but otherwise CAL licensing may
save you money.
--
David Portas
SQL Server MVP
--
Wednesday, March 7, 2012
MSSQL Workgroup 5 CAL Licence
I do not really understand how MSSQL licensing works so I would like
to be sure to choose the right one. I have one server that is going to
host MSSQL and 2 web servers that will be client of MSSQL. As an
apache web server run multiple instances I do not know if it changes
something in the licensing system. Could you tell me if this
configuration would be ok :
- db server : Mono Xeon Dual Core + SQL Server 2005 Workgroup Edition
Win32 with 5-Clients (http://www.provantage.com/microsoft-
a5k-01017~7MCSB0EW.htm)
- 2 * apache web servers accessing to db server
you will be limited to 5 users connected at the same time. and these will be
only 5 unique named users.
you are in a multiplexing scenario and apache don't change anything here.
if your website is a public site (open to the internet) and you anticipate
thousands of users, then you have to pay for a by CPU license model to
support these users.
1 User CAL CANNOT be shared with multiple users, each user must have a valid
license.
CPU license give you unlimited access. and its only 1 CPU license in your
case (you have only 1 physical CPU)
read this:
http://www.microsoft.com/sql/howtobuy/sqlserverlicensing.mspx
"xav" <xavierdaull@.gmail.com> wrote in message
news:1181645853.286005.163070@.a26g2000pre.googlegr oups.com...
>I do not really understand how MSSQL licensing works so I would like
> to be sure to choose the right one. I have one server that is going to
> host MSSQL and 2 web servers that will be client of MSSQL. As an
> apache web server run multiple instances I do not know if it changes
> something in the licensing system. Could you tell me if this
> configuration would be ok :
> - db server : Mono Xeon Dual Core + SQL Server 2005 Workgroup Edition
> Win32 with 5-Clients (http://www.provantage.com/microsoft-
> a5k-01017~7MCSB0EW.htm)
> - 2 * apache web servers accessing to db server
>
|||"xav" <xavierdaull@.gmail.com> wrote in message
news:1181645853.286005.163070@.a26g2000pre.googlegr oups.com...
>I do not really understand how MSSQL licensing works so I would like
> to be sure to choose the right one. I have one server that is going to
> host MSSQL and 2 web servers that will be client of MSSQL. As an
> apache web server run multiple instances I do not know if it changes
> something in the licensing system. Could you tell me if this
> configuration would be ok :
> - db server : Mono Xeon Dual Core + SQL Server 2005 Workgroup Edition
> Win32 with 5-Clients (http://www.provantage.com/microsoft-
> a5k-01017~7MCSB0EW.htm)
> - 2 * apache web servers accessing to db server
>
If users outside of your company will be accessing your database server
through the website, then you need a per CPU license.
Note though that per-CPU means per-socket, not per-core, so dual-core CPUs
only need a single license per CPU.
|||There are no thousands of clients accessing to MSSQL but two computers
(web servers) accessing to one db server to generate pages. As each
computer (2) will access to MSSQL with the same login for each : is it
considered as 2 clients ? or each apache processus should have is own
CAL ?
Thanks for your help
|||no a client is a physical person on the net NOT a intermediate server.
you are in multiplexing mode, the CAL is associated to the user which access
the database through the web site.
so if you have 100 users you need 100 CALs.
so if you are connected to the internet... use the CPU license model where
the number of user is unlimited.
a CAL is NOT a login but controlled through the number of session opened on
the server. so the entire world can use the same login password but this
require 1 CAL by user...
"xav" <xavierdaull@.gmail.com> wrote in message
news:1181716272.288139.109540@.i13g2000prf.googlegr oups.com...
> There are no thousands of clients accessing to MSSQL but two computers
> (web servers) accessing to one db server to generate pages. As each
> computer (2) will access to MSSQL with the same login for each : is it
> considered as 2 clients ? or each apache processus should have is own
> CAL ?
> Thanks for your help
>
|||On 14 Jun, 03:11, "Jeje" <willg...@.hotmail.com> wrote:
> a CAL is NOT a login but controlled through the number of session opened on
> the server.
No. A CAL is per user or device. The number of sessions opened on the
server is irrelevant.
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
to be sure to choose the right one. I have one server that is going to
host MSSQL and 2 web servers that will be client of MSSQL. As an
apache web server run multiple instances I do not know if it changes
something in the licensing system. Could you tell me if this
configuration would be ok :
- db server : Mono Xeon Dual Core + SQL Server 2005 Workgroup Edition
Win32 with 5-Clients (http://www.provantage.com/microsoft-
a5k-01017~7MCSB0EW.htm)
- 2 * apache web servers accessing to db server
you will be limited to 5 users connected at the same time. and these will be
only 5 unique named users.
you are in a multiplexing scenario and apache don't change anything here.
if your website is a public site (open to the internet) and you anticipate
thousands of users, then you have to pay for a by CPU license model to
support these users.
1 User CAL CANNOT be shared with multiple users, each user must have a valid
license.
CPU license give you unlimited access. and its only 1 CPU license in your
case (you have only 1 physical CPU)
read this:
http://www.microsoft.com/sql/howtobuy/sqlserverlicensing.mspx
"xav" <xavierdaull@.gmail.com> wrote in message
news:1181645853.286005.163070@.a26g2000pre.googlegr oups.com...
>I do not really understand how MSSQL licensing works so I would like
> to be sure to choose the right one. I have one server that is going to
> host MSSQL and 2 web servers that will be client of MSSQL. As an
> apache web server run multiple instances I do not know if it changes
> something in the licensing system. Could you tell me if this
> configuration would be ok :
> - db server : Mono Xeon Dual Core + SQL Server 2005 Workgroup Edition
> Win32 with 5-Clients (http://www.provantage.com/microsoft-
> a5k-01017~7MCSB0EW.htm)
> - 2 * apache web servers accessing to db server
>
|||"xav" <xavierdaull@.gmail.com> wrote in message
news:1181645853.286005.163070@.a26g2000pre.googlegr oups.com...
>I do not really understand how MSSQL licensing works so I would like
> to be sure to choose the right one. I have one server that is going to
> host MSSQL and 2 web servers that will be client of MSSQL. As an
> apache web server run multiple instances I do not know if it changes
> something in the licensing system. Could you tell me if this
> configuration would be ok :
> - db server : Mono Xeon Dual Core + SQL Server 2005 Workgroup Edition
> Win32 with 5-Clients (http://www.provantage.com/microsoft-
> a5k-01017~7MCSB0EW.htm)
> - 2 * apache web servers accessing to db server
>
If users outside of your company will be accessing your database server
through the website, then you need a per CPU license.
Note though that per-CPU means per-socket, not per-core, so dual-core CPUs
only need a single license per CPU.
|||There are no thousands of clients accessing to MSSQL but two computers
(web servers) accessing to one db server to generate pages. As each
computer (2) will access to MSSQL with the same login for each : is it
considered as 2 clients ? or each apache processus should have is own
CAL ?
Thanks for your help
|||no a client is a physical person on the net NOT a intermediate server.
you are in multiplexing mode, the CAL is associated to the user which access
the database through the web site.
so if you have 100 users you need 100 CALs.
so if you are connected to the internet... use the CPU license model where
the number of user is unlimited.
a CAL is NOT a login but controlled through the number of session opened on
the server. so the entire world can use the same login password but this
require 1 CAL by user...
"xav" <xavierdaull@.gmail.com> wrote in message
news:1181716272.288139.109540@.i13g2000prf.googlegr oups.com...
> There are no thousands of clients accessing to MSSQL but two computers
> (web servers) accessing to one db server to generate pages. As each
> computer (2) will access to MSSQL with the same login for each : is it
> considered as 2 clients ? or each apache processus should have is own
> CAL ?
> Thanks for your help
>
|||On 14 Jun, 03:11, "Jeje" <willg...@.hotmail.com> wrote:
> a CAL is NOT a login but controlled through the number of session opened on
> the server.
No. A CAL is per user or device. The number of sessions opened on the
server is irrelevant.
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
MSSQL Workgroup 5 CAL Licence
I do not really understand how MSSQL licensing works so I would like
to be sure to choose the right one. I have one server that is going to
host MSSQL and 2 web servers that will be client of MSSQL. As an
apache web server run multiple instances I do not know if it changes
something in the licensing system. Could you tell me if this
configuration would be ok :
- db server : Mono Xeon Dual Core + SQL Server 2005 Workgroup Edition
Win32 with 5-Clients (http://www.provantage.com/microsoft-
a5k-01017~7MCSB0EW.htm)
- 2 * apache web servers accessing to db serveryou will be limited to 5 users connected at the same time. and these will be
only 5 unique named users.
you are in a multiplexing scenario and apache don't change anything here.
if your website is a public site (open to the internet) and you anticipate
thousands of users, then you have to pay for a by CPU license model to
support these users.
1 User CAL CANNOT be shared with multiple users, each user must have a valid
license.
CPU license give you unlimited access. and its only 1 CPU license in your
case (you have only 1 physical CPU)
read this:
http://www.microsoft.com/sql/howtob...rlicensing.mspx
"xav" <xavierdaull@.gmail.com> wrote in message
news:1181645853.286005.163070@.a26g2000pre.googlegroups.com...
>I do not really understand how MSSQL licensing works so I would like
> to be sure to choose the right one. I have one server that is going to
> host MSSQL and 2 web servers that will be client of MSSQL. As an
> apache web server run multiple instances I do not know if it changes
> something in the licensing system. Could you tell me if this
> configuration would be ok :
> - db server : Mono Xeon Dual Core + SQL Server 2005 Workgroup Edition
> Win32 with 5-Clients (http://www.provantage.com/microsoft-
> a5k-01017~7MCSB0EW.htm)
> - 2 * apache web servers accessing to db server
>|||"xav" <xavierdaull@.gmail.com> wrote in message
news:1181645853.286005.163070@.a26g2000pre.googlegroups.com...
>I do not really understand how MSSQL licensing works so I would like
> to be sure to choose the right one. I have one server that is going to
> host MSSQL and 2 web servers that will be client of MSSQL. As an
> apache web server run multiple instances I do not know if it changes
> something in the licensing system. Could you tell me if this
> configuration would be ok :
> - db server : Mono Xeon Dual Core + SQL Server 2005 Workgroup Edition
> Win32 with 5-Clients (http://www.provantage.com/microsoft-
> a5k-01017~7MCSB0EW.htm)
> - 2 * apache web servers accessing to db server
>
If users outside of your company will be accessing your database server
through the website, then you need a per CPU license.
Note though that per-CPU means per-socket, not per-core, so dual-core CPUs
only need a single license per CPU.|||There are no thousands of clients accessing to MSSQL but two computers
(web servers) accessing to one db server to generate pages. As each
computer (2) will access to MSSQL with the same login for each : is it
considered as 2 clients ? or each apache processus should have is own
CAL ?
Thanks for your help|||no a client is a physical person on the net NOT a intermediate server.
you are in multiplexing mode, the CAL is associated to the user which access
the database through the web site.
so if you have 100 users you need 100 CALs.
so if you are connected to the internet... use the CPU license model where
the number of user is unlimited.
a CAL is NOT a login but controlled through the number of session opened on
the server. so the entire world can use the same login password but this
require 1 CAL by user...
"xav" <xavierdaull@.gmail.com> wrote in message
news:1181716272.288139.109540@.i13g2000prf.googlegroups.com...
> There are no thousands of clients accessing to MSSQL but two computers
> (web servers) accessing to one db server to generate pages. As each
> computer (2) will access to MSSQL with the same login for each : is it
> considered as 2 clients ? or each apache processus should have is own
> CAL ?
> Thanks for your help
>|||On 14 Jun, 03:11, "Jeje" <willg...@.hotmail.com> wrote:
> a CAL is NOT a login but controlled through the number of session opened o
n
> the server.
No. A CAL is per user or device. The number of sessions opened on the
server is irrelevant.
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
--
to be sure to choose the right one. I have one server that is going to
host MSSQL and 2 web servers that will be client of MSSQL. As an
apache web server run multiple instances I do not know if it changes
something in the licensing system. Could you tell me if this
configuration would be ok :
- db server : Mono Xeon Dual Core + SQL Server 2005 Workgroup Edition
Win32 with 5-Clients (http://www.provantage.com/microsoft-
a5k-01017~7MCSB0EW.htm)
- 2 * apache web servers accessing to db serveryou will be limited to 5 users connected at the same time. and these will be
only 5 unique named users.
you are in a multiplexing scenario and apache don't change anything here.
if your website is a public site (open to the internet) and you anticipate
thousands of users, then you have to pay for a by CPU license model to
support these users.
1 User CAL CANNOT be shared with multiple users, each user must have a valid
license.
CPU license give you unlimited access. and its only 1 CPU license in your
case (you have only 1 physical CPU)
read this:
http://www.microsoft.com/sql/howtob...rlicensing.mspx
"xav" <xavierdaull@.gmail.com> wrote in message
news:1181645853.286005.163070@.a26g2000pre.googlegroups.com...
>I do not really understand how MSSQL licensing works so I would like
> to be sure to choose the right one. I have one server that is going to
> host MSSQL and 2 web servers that will be client of MSSQL. As an
> apache web server run multiple instances I do not know if it changes
> something in the licensing system. Could you tell me if this
> configuration would be ok :
> - db server : Mono Xeon Dual Core + SQL Server 2005 Workgroup Edition
> Win32 with 5-Clients (http://www.provantage.com/microsoft-
> a5k-01017~7MCSB0EW.htm)
> - 2 * apache web servers accessing to db server
>|||"xav" <xavierdaull@.gmail.com> wrote in message
news:1181645853.286005.163070@.a26g2000pre.googlegroups.com...
>I do not really understand how MSSQL licensing works so I would like
> to be sure to choose the right one. I have one server that is going to
> host MSSQL and 2 web servers that will be client of MSSQL. As an
> apache web server run multiple instances I do not know if it changes
> something in the licensing system. Could you tell me if this
> configuration would be ok :
> - db server : Mono Xeon Dual Core + SQL Server 2005 Workgroup Edition
> Win32 with 5-Clients (http://www.provantage.com/microsoft-
> a5k-01017~7MCSB0EW.htm)
> - 2 * apache web servers accessing to db server
>
If users outside of your company will be accessing your database server
through the website, then you need a per CPU license.
Note though that per-CPU means per-socket, not per-core, so dual-core CPUs
only need a single license per CPU.|||There are no thousands of clients accessing to MSSQL but two computers
(web servers) accessing to one db server to generate pages. As each
computer (2) will access to MSSQL with the same login for each : is it
considered as 2 clients ? or each apache processus should have is own
CAL ?
Thanks for your help|||no a client is a physical person on the net NOT a intermediate server.
you are in multiplexing mode, the CAL is associated to the user which access
the database through the web site.
so if you have 100 users you need 100 CALs.
so if you are connected to the internet... use the CPU license model where
the number of user is unlimited.
a CAL is NOT a login but controlled through the number of session opened on
the server. so the entire world can use the same login password but this
require 1 CAL by user...
"xav" <xavierdaull@.gmail.com> wrote in message
news:1181716272.288139.109540@.i13g2000prf.googlegroups.com...
> There are no thousands of clients accessing to MSSQL but two computers
> (web servers) accessing to one db server to generate pages. As each
> computer (2) will access to MSSQL with the same login for each : is it
> considered as 2 clients ? or each apache processus should have is own
> CAL ?
> Thanks for your help
>|||On 14 Jun, 03:11, "Jeje" <willg...@.hotmail.com> wrote:
> a CAL is NOT a login but controlled through the number of session opened o
n
> the server.
No. A CAL is per user or device. The number of sessions opened on the
server is irrelevant.
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
--
MSSQL Workgroup 5 CAL Licence
I do not really understand how MSSQL licensing works so I would like
to be sure to choose the right one. I have one server that is going to
host MSSQL and 2 web servers that will be client of MSSQL. As an
apache web server run multiple instances I do not know if it changes
something in the licensing system. Could you tell me if this
configuration would be ok :
- db server : Mono Xeon Dual Core + SQL Server 2005 Workgroup Edition
Win32 with 5-Clients (http://www.provantage.com/microsoft-
a5k-01017~7MCSB0EW.htm)
- 2 * apache web servers accessing to db serveryou will be limited to 5 users connected at the same time. and these will be
only 5 unique named users.
you are in a multiplexing scenario and apache don't change anything here.
if your website is a public site (open to the internet) and you anticipate
thousands of users, then you have to pay for a by CPU license model to
support these users.
1 User CAL CANNOT be shared with multiple users, each user must have a valid
license.
CPU license give you unlimited access. and its only 1 CPU license in your
case (you have only 1 physical CPU)
read this:
http://www.microsoft.com/sql/howtobuy/sqlserverlicensing.mspx
"xav" <xavierdaull@.gmail.com> wrote in message
news:1181645853.286005.163070@.a26g2000pre.googlegroups.com...
>I do not really understand how MSSQL licensing works so I would like
> to be sure to choose the right one. I have one server that is going to
> host MSSQL and 2 web servers that will be client of MSSQL. As an
> apache web server run multiple instances I do not know if it changes
> something in the licensing system. Could you tell me if this
> configuration would be ok :
> - db server : Mono Xeon Dual Core + SQL Server 2005 Workgroup Edition
> Win32 with 5-Clients (http://www.provantage.com/microsoft-
> a5k-01017~7MCSB0EW.htm)
> - 2 * apache web servers accessing to db server
>|||"xav" <xavierdaull@.gmail.com> wrote in message
news:1181645853.286005.163070@.a26g2000pre.googlegroups.com...
>I do not really understand how MSSQL licensing works so I would like
> to be sure to choose the right one. I have one server that is going to
> host MSSQL and 2 web servers that will be client of MSSQL. As an
> apache web server run multiple instances I do not know if it changes
> something in the licensing system. Could you tell me if this
> configuration would be ok :
> - db server : Mono Xeon Dual Core + SQL Server 2005 Workgroup Edition
> Win32 with 5-Clients (http://www.provantage.com/microsoft-
> a5k-01017~7MCSB0EW.htm)
> - 2 * apache web servers accessing to db server
>
If users outside of your company will be accessing your database server
through the website, then you need a per CPU license.
Note though that per-CPU means per-socket, not per-core, so dual-core CPUs
only need a single license per CPU.|||There are no thousands of clients accessing to MSSQL but two computers
(web servers) accessing to one db server to generate pages. As each
computer (2) will access to MSSQL with the same login for each : is it
considered as 2 clients ? or each apache processus should have is own
CAL ?
Thanks for your help|||no a client is a physical person on the net NOT a intermediate server.
you are in multiplexing mode, the CAL is associated to the user which access
the database through the web site.
so if you have 100 users you need 100 CALs.
so if you are connected to the internet... use the CPU license model where
the number of user is unlimited.
a CAL is NOT a login but controlled through the number of session opened on
the server. so the entire world can use the same login password but this
require 1 CAL by user...
"xav" <xavierdaull@.gmail.com> wrote in message
news:1181716272.288139.109540@.i13g2000prf.googlegroups.com...
> There are no thousands of clients accessing to MSSQL but two computers
> (web servers) accessing to one db server to generate pages. As each
> computer (2) will access to MSSQL with the same login for each : is it
> considered as 2 clients ? or each apache processus should have is own
> CAL ?
> Thanks for your help
>|||On 14 Jun, 03:11, "Jeje" <willg...@.hotmail.com> wrote:
> a CAL is NOT a login but controlled through the number of session opened on
> the server.
No. A CAL is per user or device. The number of sessions opened on the
server is irrelevant.
--
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
--
to be sure to choose the right one. I have one server that is going to
host MSSQL and 2 web servers that will be client of MSSQL. As an
apache web server run multiple instances I do not know if it changes
something in the licensing system. Could you tell me if this
configuration would be ok :
- db server : Mono Xeon Dual Core + SQL Server 2005 Workgroup Edition
Win32 with 5-Clients (http://www.provantage.com/microsoft-
a5k-01017~7MCSB0EW.htm)
- 2 * apache web servers accessing to db serveryou will be limited to 5 users connected at the same time. and these will be
only 5 unique named users.
you are in a multiplexing scenario and apache don't change anything here.
if your website is a public site (open to the internet) and you anticipate
thousands of users, then you have to pay for a by CPU license model to
support these users.
1 User CAL CANNOT be shared with multiple users, each user must have a valid
license.
CPU license give you unlimited access. and its only 1 CPU license in your
case (you have only 1 physical CPU)
read this:
http://www.microsoft.com/sql/howtobuy/sqlserverlicensing.mspx
"xav" <xavierdaull@.gmail.com> wrote in message
news:1181645853.286005.163070@.a26g2000pre.googlegroups.com...
>I do not really understand how MSSQL licensing works so I would like
> to be sure to choose the right one. I have one server that is going to
> host MSSQL and 2 web servers that will be client of MSSQL. As an
> apache web server run multiple instances I do not know if it changes
> something in the licensing system. Could you tell me if this
> configuration would be ok :
> - db server : Mono Xeon Dual Core + SQL Server 2005 Workgroup Edition
> Win32 with 5-Clients (http://www.provantage.com/microsoft-
> a5k-01017~7MCSB0EW.htm)
> - 2 * apache web servers accessing to db server
>|||"xav" <xavierdaull@.gmail.com> wrote in message
news:1181645853.286005.163070@.a26g2000pre.googlegroups.com...
>I do not really understand how MSSQL licensing works so I would like
> to be sure to choose the right one. I have one server that is going to
> host MSSQL and 2 web servers that will be client of MSSQL. As an
> apache web server run multiple instances I do not know if it changes
> something in the licensing system. Could you tell me if this
> configuration would be ok :
> - db server : Mono Xeon Dual Core + SQL Server 2005 Workgroup Edition
> Win32 with 5-Clients (http://www.provantage.com/microsoft-
> a5k-01017~7MCSB0EW.htm)
> - 2 * apache web servers accessing to db server
>
If users outside of your company will be accessing your database server
through the website, then you need a per CPU license.
Note though that per-CPU means per-socket, not per-core, so dual-core CPUs
only need a single license per CPU.|||There are no thousands of clients accessing to MSSQL but two computers
(web servers) accessing to one db server to generate pages. As each
computer (2) will access to MSSQL with the same login for each : is it
considered as 2 clients ? or each apache processus should have is own
CAL ?
Thanks for your help|||no a client is a physical person on the net NOT a intermediate server.
you are in multiplexing mode, the CAL is associated to the user which access
the database through the web site.
so if you have 100 users you need 100 CALs.
so if you are connected to the internet... use the CPU license model where
the number of user is unlimited.
a CAL is NOT a login but controlled through the number of session opened on
the server. so the entire world can use the same login password but this
require 1 CAL by user...
"xav" <xavierdaull@.gmail.com> wrote in message
news:1181716272.288139.109540@.i13g2000prf.googlegroups.com...
> There are no thousands of clients accessing to MSSQL but two computers
> (web servers) accessing to one db server to generate pages. As each
> computer (2) will access to MSSQL with the same login for each : is it
> considered as 2 clients ? or each apache processus should have is own
> CAL ?
> Thanks for your help
>|||On 14 Jun, 03:11, "Jeje" <willg...@.hotmail.com> wrote:
> a CAL is NOT a login but controlled through the number of session opened on
> the server.
No. A CAL is per user or device. The number of sessions opened on the
server is irrelevant.
--
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
--
Subscribe to:
Posts (Atom)