Client tools licensing question

Hello,
If we have a full version of SQL2K and want to install MSDE on about 30
mobile laptops can we install the client utilities from the SQL2K cd onto
each laptop? If not is there any other options? What would be the cost per
laptop to install the client software? Thanks.
Jake
Hi Jake,
No, you can't. We have a utility that's free for personal use and licensing
for things like you describe. Details are at our site. For other options,
look at: www.microsoft.com/sql/msde/partners/default.asp
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Jake" <rondican@.hotmail.com> wrote in message
news:O5In$G%23rEHA.3848@.TK2MSFTNGP14.phx.gbl...
> Hello,
> If we have a full version of SQL2K and want to install MSDE on about 30
> mobile laptops can we install the client utilities from the SQL2K cd onto
> each laptop? If not is there any other options? What would be the cost per
> laptop to install the client software? Thanks.
> Jake
>
|||Greg,
Is there one that would be good for setting up and managing replication.
We are planning on using merge replication.
Jake
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:eKmUUt%23rEHA.2948@.TK2MSFTNGP11.phx.gbl...
> Hi Jake,
> No, you can't. We have a utility that's free for personal use and
> licensing for things like you describe. Details are at our site. For other
> options, look at: www.microsoft.com/sql/msde/partners/default.asp
> HTH,
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "Jake" <rondican@.hotmail.com> wrote in message
> news:O5In$G%23rEHA.3848@.TK2MSFTNGP14.phx.gbl...
>
|||Hi Jake,
That's on the way in our next version but it's not here yet. I've tried many
of the others but haven't come across one yet that does.
Regards,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Jake" <rondican@.hotmail.com> wrote in message
news:OepQcx%23rEHA.868@.TK2MSFTNGP10.phx.gbl...
> Greg,
> Is there one that would be good for setting up and managing
> replication. We are planning on using merge replication.
> Jake
>
> "Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
> news:eKmUUt%23rEHA.2948@.TK2MSFTNGP11.phx.gbl...
>
|||Greg,
Any idea on a release date? Will it work with SQLExpress?
Jake
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:u%234Y7IEsEHA.376@.TK2MSFTNGP14.phx.gbl...
> Hi Jake,
> That's on the way in our next version but it's not here yet. I've tried
> many of the others but haven't come across one yet that does.
> Regards,
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "Jake" <rondican@.hotmail.com> wrote in message
> news:OepQcx%23rEHA.868@.TK2MSFTNGP10.phx.gbl...
>
|||Hi Jake,
Still about 6 weeks. Separate product coming for SQL Express. It's a little
more challenging because SQL Agent isn't included.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Jake" <rondican@.hotmail.com> wrote in message
news:ORLaiyFsEHA.2136@.TK2MSFTNGP14.phx.gbl...
> Greg,
> Any idea on a release date? Will it work with SQLExpress?
> Jake
> "Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
> news:u%234Y7IEsEHA.376@.TK2MSFTNGP14.phx.gbl...
>
|||Pop me an email offline with what you need it to do so I can make sure it's
getting covered.
Regards,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Jake" <rondican@.hotmail.com> wrote in message
news:ORLaiyFsEHA.2136@.TK2MSFTNGP14.phx.gbl...
> Greg,
> Any idea on a release date? Will it work with SQLExpress?
> Jake
> "Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
> news:u%234Y7IEsEHA.376@.TK2MSFTNGP14.phx.gbl...
>
|||"Jake" <rondican@.hotmail.com> wrote in message news:O5In$G%
| If we have a full version of SQL2K and want to install MSDE on about 30
| mobile laptops can we install the client utilities from the SQL2K cd onto
| each laptop? If not is there any other options? What would be the cost per
| laptop to install the client software? Thanks.
|
For 30 servers, wouldn't you want to script it anyway? Seems odd to want to
install a GUI for such a task. I don't like using EM to make changes on even 1
production box.
Also, if you are going to use EM, I would want either the same person or 'team'
of dba's doing the configs. What you can do is put the msde box on the LAN and
connect to it from the dba's copy of EM that is probably installed on their
desktop.
Carl Karsten
|||if you go to the MS site and search for SQL 2000 eval version, it states
that the enterprise t tools can be used indefinitely. confirmed with MS.
Use the EVAL version to intstall just the Enterprise Mgr. everything works
properly with MSDE2000 except the scheduled backups.
steve
"Jake" <rondican@.hotmail.com> wrote in message
news:O5In$G%23rEHA.3848@.TK2MSFTNGP14.phx.gbl...
> Hello,
> If we have a full version of SQL2K and want to install MSDE on about
30
> mobile laptops can we install the client utilities from the SQL2K cd onto
> each laptop? If not is there any other options? What would be the cost per
> laptop to install the client software? Thanks.
> Jake
>
|||hi Steve,
"bozo" <bozo@.bozosplace.com> ha scritto nel messaggio
news:10nc2v5ff2iambe@.corp.supernews.com
> if you go to the MS site and search for SQL 2000 eval version, it
> states that the enterprise t tools can be used indefinitely.
> confirmed with MS. Use the EVAL version to intstall just the
> Enterprise Mgr. everything works properly with MSDE2000 except the
> scheduled backups.
I'm really not certain you are allowed to use the Eval tools on production
servers, or, anyway, after the evaluation time is finished...
they do work after the evaluation expires, but I'm confident you are not
allowed at all to use them...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Client licensing

My apologies if this is the wrong newsgroup... I couldn't find the most
appropriate one.
Does a client access license allow a user to access any # of SQL Servers
deployed in my enterprise or do I need a CAL / user / server?
Thx.
Hi,
try following:
http://www.microsoft.com/sql/howtobuy/default.mspx#EEAA
Danijel Novak
"Drew" <nodirectemails@.nospam.com> wrote in message
news:%23UodxSRBGHA.2912@.tk2msftngp13.phx.gbl...
> My apologies if this is the wrong newsgroup... I couldn't find the most
> appropriate one.
> Does a client access license allow a user to access any # of SQL Servers
> deployed in my enterprise or do I need a CAL / user / server?
> Thx.
>
|||Thanks!
"Danijel Novak" <danijel.novak@.triera.net> wrote in message
news:ejmYUqTBGHA.3352@.TK2MSFTNGP09.phx.gbl...
> Hi,
> try following:
> http://www.microsoft.com/sql/howtobuy/default.mspx#EEAA
> --
> Danijel Novak
>
> "Drew" <nodirectemails@.nospam.com> wrote in message
> news:%23UodxSRBGHA.2912@.tk2msftngp13.phx.gbl...
>

Client Licensing

We are just about to upgrade our trial version of SQL 2005 to SQL 2005 std.
I underatand I need a license for the server and each client.
My query is I have 3 users which can also work from home as and when
required, will they be covered under the licences we use in the office or do
i need to purchase 3 more, these users will be using different machines at
home
thanksHello Leonard!
SQL Server is available under three licensing options:
â?¢ Per Processor Licensing Model. A Processor license is required for each
physical or virtual processor that is accessed by an operating system
environment running SQL Server. This license does not require any device or
user client access licenses (CALs).
â?¢ Server plus Device CALs Licensing Model. A Server license is required for
each operating system environment running an instance of SQL Server, as well
as a CAL for each client device that accesses a system running SQL Server.
â?¢ Server plus User CALs Licensing Model. A Server license is required for
each operating system environment running an instance of SQL Server, as well
as a CAL for each user who accesses a system running SQL Server.
So, If you buy User CALs for those 3 users then you do not need to buy extra
licenses for them.
However, I encourage you to contact to a local authorized license vendor to
get the most correct answer about this stuff.
You may have more info about licensing from the following link:
http://www.microsoft.com/sql/howtobuy/default.mspx
Ekrem Ã?nsoy
"Leonard" <Leonard@.discussions.microsoft.com> wrote in message
news:01B44CCE-9F73-4880-B9CC-697C463DBBB0@.microsoft.com...
> We are just about to upgrade our trial version of SQL 2005 to SQL 2005
> std.
> I underatand I need a license for the server and each client.
> My query is I have 3 users which can also work from home as and when
> required, will they be covered under the licences we use in the office or
> do
> i need to purchase 3 more, these users will be using different machines at
> home
> thanks

Client license question

Hi all,
This is a question related to licensing...
Environment :
Server 1 - Windows 2000/2003 with SQL Server 2000
Server 2 - webserver (IIS/Apache/etc)
Server 2 is connecting to the SQL Server database (Server
1) using SQL Server authentication (i.e.
SQLServerAccount/Password)
There are multiple users connecting to the webserver
using anonymous authentication to pull out some data from
the SQL Server.
There is going to be only one user connected to the SQL
Server (which is 'SQLServerAccount') ... and is going to
have several instances for each user...
Basically the external users will not have access to the
SQL Server database ... without using the webbased front-
end application...
How many licenses (SQL Server) do I need for the
server/clients?
Best regards,
Alin V.
As I posted within .server:
Is the web server only serving up pages (and data) to a distinct, known set
of individuals (such as employees or partners that have access to the web
site)? If so, it is my understanding that you can probably go the user CAL
route.
Otherwise you will have to go the PER PROCESSOR route
http://www.microsoft.com/sql/howtobuy/default.asp
http://www.microsoft.com/sql/howtobu...rlicensing.asp
Keith
"Alin" <anonymous@.discussions.microsoft.com> wrote in message
news:2575401c4606b$b6f56840$a501280a@.phx.gbl...
> Hi all,
> This is a question related to licensing...
> Environment :
> Server 1 - Windows 2000/2003 with SQL Server 2000
> Server 2 - webserver (IIS/Apache/etc)
> Server 2 is connecting to the SQL Server database (Server
> 1) using SQL Server authentication (i.e.
> SQLServerAccount/Password)
> There are multiple users connecting to the webserver
> using anonymous authentication to pull out some data from
> the SQL Server.
> There is going to be only one user connected to the SQL
> Server (which is 'SQLServerAccount') ... and is going to
> have several instances for each user...
> Basically the external users will not have access to the
> SQL Server database ... without using the webbased front-
> end application...
> How many licenses (SQL Server) do I need for the
> server/clients?
> Best regards,
> Alin V.
>
|||Alin,
I think that anyone interacting with the database from a client
computer, whether that interaction passes through an intermediary such
as a web server or not, is considered a client. If your anonymous user
requests are handled through transactions specifically for them against
the database, they need to be covered by either individual client
licenses or by a processor license on the web server. You should
probably contact Microsoft for an official answer, but I think the only
possible situation in which you can consider the web server to be the
sole client would be if the web server's interactions with the database
were independent of the anonymous users' interactions with the
webserver. This might be the case if the web server only served up a
collection of canned reports off the data. The SQL Server could supply
the information for these reports, but the users would only be able to
select which report they wanted to see, or request a report with some
sort of customization that could be handled by the web server alone. As
soon as the database is asked specific questions on behalf of someone,
that someone has become a client.
When it's released, SQL Server 2005 Express Edition may be a zero-cost
solution as a back-end database for many kinds of Web applications.
See http://lab.msdn.microsoft.com/express/sql/default.aspx.
Steve Kass
Drew University
Alin wrote:

>Hi all,
> This is a question related to licensing...
> Environment :
> Server 1 - Windows 2000/2003 with SQL Server 2000
> Server 2 - webserver (IIS/Apache/etc)
> Server 2 is connecting to the SQL Server database (Server
>1) using SQL Server authentication (i.e.
>SQLServerAccount/Password)
> There are multiple users connecting to the webserver
>using anonymous authentication to pull out some data from
>the SQL Server.
> There is going to be only one user connected to the SQL
>Server (which is 'SQLServerAccount') ... and is going to
>have several instances for each user...
> Basically the external users will not have access to the
>SQL Server database ... without using the webbased front-
>end application...
> How many licenses (SQL Server) do I need for the
>server/clients?
>Best regards,
> Alin V.
>
>
|||A small correction - I should have said "processor license on Server 1,"
not "processor license on the web server
SK
Steve Kass wrote:

> Alin,
> I think that anyone interacting with the database from a client
> computer, whether that interaction passes through an intermediary such
> as a web server or not, is considered a client. If your anonymous
> user requests are handled through transactions specifically for them
> against the database, they need to be covered by either individual
> client licenses or by a processor license on the web server. You
> should probably contact Microsoft for an official answer, but I think
> the only possible situation in which you can consider the web server
> to be the sole client would be if the web server's interactions with
> the database were independent of the anonymous users' interactions
> with the webserver. This might be the case if the web server only
> served up a collection of canned reports off the data. The SQL Server
> could supply the information for these reports, but the users would
> only be able to select which report they wanted to see, or request a
> report with some sort of customization that could be handled by the
> web server alone. As soon as the database is asked specific questions
> on behalf of someone, that someone has become a client.
> When it's released, SQL Server 2005 Express Edition may be a
> zero-cost solution as a back-end database for many kinds of Web
> applications. See
> http://lab.msdn.microsoft.com/express/sql/default.aspx.
> Steve Kass
> Drew University
> Alin wrote:
>
|||Thanks guys for your quick responses... from the License
Agreement I got the same feeling...
Best regards,
Alin V.

>--Original Message--
>Alin,
> I think that anyone interacting with the database from
a client
>computer, whether that interaction passes through an
intermediary such
>as a web server or not, is considered a client. If your
anonymous user
>requests are handled through transactions specifically
for them against
>the database, they need to be covered by either
individual client
>licenses or by a processor license on the web server.
You should
>probably contact Microsoft for an official answer, but I
think the only
>possible situation in which you can consider the web
server to be the
>sole client would be if the web server's interactions
with the database
>were independent of the anonymous users' interactions
with the
>webserver. This might be the case if the web server only
served up a
>collection of canned reports off the data. The SQL
Server could supply
>the information for these reports, but the users would
only be able to
>select which report they wanted to see, or request a
report with some
>sort of customization that could be handled by the web
server alone. As
>soon as the database is asked specific questions on
behalf of someone,
>that someone has become a client.
> When it's released, SQL Server 2005 Express Edition may
be a zero-cost
>solution as a back-end database for many kinds of Web
applications.
>See
http://lab.msdn.microsoft.com/express/sql/default.aspx.[vbcol=seagreen]
>Steve Kass
>Drew University
>Alin wrote:
(Server[vbcol=seagreen]
from[vbcol=seagreen]
the
>.
>