MSDE & EM Tools

Hi,
I intend using MSDE 2000 in conjunction with a fully licensed version of SQL
Server 2000. MSDE will be installed on several clients.
My understanding is as follows :
I can use Enterprise Manager on any or all of those client instances of MSDE
because I have a fully licensed copy of SQL Server 2000 with which they will
be replicating.
MSDN:
You can only use SQL Server tools and services in conjunction with MSDE if
you acquired MSDE through SQL Server 2000 (Developer Edition, Standard
Edition, or Enterprise Edition), and if you are using MSDE in conjunction
with a properly licensed copy of SQL Server 2000.
Am I in the clear?
Can I use any of the GUI tools?
Thanks in advance,
DOM.hi Dom,
Dom wrote:
> Hi,
> I intend using MSDE 2000 in conjunction with a fully licensed version
> of SQL Server 2000. MSDE will be installed on several clients.
> My understanding is as follows :
> I can use Enterprise Manager on any or all of those client instances
> of MSDE because I have a fully licensed copy of SQL Server 2000 with
> which they will be replicating.
> MSDN:
> You can only use SQL Server tools and services in conjunction with
> MSDE if you acquired MSDE through SQL Server 2000 (Developer Edition,
> Standard Edition, or Enterprise Edition), and if you are using MSDE
> in conjunction with a properly licensed copy of SQL Server 2000.
> Am I in the clear?
> Can I use any of the GUI tools?
> Thanks in advance,
> DOM
please have a look at Steve Dybing answer in http://tinyurl.com/d2qpa .. it
does not seem this is a legal solution...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply|||Thanks Andrea,
I followed the link you mentioned and on that page was directed to the
following site:
http://www.aspfaq.com/show.asp?id=2442
which states :
If you have an existing machine with SQL Server client tools installed, you
can manage the MSDE instance through these... as long as you have a valid and
legal Client Access License (CAL).
You can take the SQL Server install CD, run it on the client(s), and choose
"Install client tools only" during setup. This will install Query Analyzer,
Enterprise Manager, and other useful toolsâ'but will not install the database
engine.
This was my understanding.
With a fully licensed MSSQL 2000 you can legally use the client tools on
MSDE 2000 clients'
DOM|||hi Dom,
Dom wrote:
> Thanks Andrea,
> I followed the link you mentioned and on that page was directed to the
> following site:
> http://www.aspfaq.com/show.asp?id=2442
> which states :
> If you have an existing machine with SQL Server client tools
> installed, you can manage the MSDE instance through these... as long
> as you have a valid and legal Client Access License (CAL).
> You can take the SQL Server install CD, run it on the client(s), and
> choose "Install client tools only" during setup. This will install
> Query Analyzer, Enterprise Manager, and other useful tools-but will
> not install the database engine.
> This was my understanding.
> With a fully licensed MSSQL 2000 you can legally use the client tools
> on MSDE 2000 clients'
I had a private conversation with Steve some time ago about this matter...
he is not a "legal" guy too... but he has been told by legal representatives
that EM (QA and so on) is not legitimated to be used against production MSDE
instances... this is the reason he posted that way...
so, in my understanding, you never (or quite never, but I do really have no
idea when it could be legal) are legitimated to use SQL Server Client Tools
to manage MSDE...
my $0.02
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply