Enterprise Manager Tools

Can someone point me to the licensing requirements of the
admin tools. I have a number of db's that I admin. I am
wondering about the use of the admin tools on these
databases.
TIA
meh
"MEH" <mehogberg@.cox.net> wrote in message
news:20af01c53eaf$03fb58d0$a601280a@.phx.gbl...
> Can someone point me to the licensing requirements of the
> admin tools. I have a number of db's that I admin. I am
> wondering about the use of the admin tools on these
> databases.
As long as you have a licensed copy of SQL Server, you are authorized to use
the SQL Server tools, like Enterprise Manager, on multiple databases. If I
didn't answer your question, provide more detail?
Steve
|||Steve;
Thanks for the reply. I work for a company that not only
has its own database's (and copies of SQL Enterprise) but
we have customers that we sell, create and maintain SQL
enterprise (and some MSDE) databases. I loaded the tools
on my laptop so that I can go to different sites and work
on said databases. We were talking the other day about
weather or not it was within the licensing agreement if
I ...i.e load the tools from one of my companys
enterprise CD's and then go to a site and connect to
other databases. Or should I be using the tools from
their CD's?
TIA
Thanks for any info in this matter
meh
[vbcol=seagreen]
>--Original Message--
>"MEH" <mehogberg@.cox.net> wrote in message
>news:20af01c53eaf$03fb58d0$a601280a@.phx.gbl...
the[vbcol=seagreen]
am
>As long as you have a licensed copy of SQL Server, you
are authorized to use
>the SQL Server tools, like Enterprise Manager, on
multiple databases. If I
>didn't answer your question, provide more detail?
>Steve
>
>.
>
|||hi,
MEH wrote:
> Can someone point me to the licensing requirements of the
> admin tools. I have a number of db's that I admin. I am
> wondering about the use of the admin tools on these
> databases.
please have a look at
http://www.google.it/groups?q=group:...phx.gbl&rnum=1
... according to this pst, due to a Microosft representative, you are not
entitled at all to use the SQL Server Client Tools on production MSDE
instance...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Try SQL Admin Studio from www.simego.com it's only $40 yet far faster than
Enterprise Manager.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3c26v1F6jpo62U1@.individual.net...
> hi,
> MEH wrote:
> please have a look at
> http://www.google.it/groups?q=group:...phx.gbl&rnum=1
> ... according to this pst, due to a Microosft representative, you are not
> entitled at all to use the SQL Server Client Tools on production MSDE
> instance...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>

Enterprise Manager Licensing with MSDE

Hello.
I have an application I am developing with MSDE. I know that I am properly
licensed to use MSDE and distribute that with my application. However, I
cannot seem to find any information about Enterprise Manager licensing. We
have a valid license of Sql Server 2000 and I have been using Enterprise
Manager to configure my MSDE database. I need to install the application at
a client's site and I was wondering if the licensing would allow me to
install Enterprise Manager so that I can configure the database on site
without having to use OSQL. (e.g. attaching the database)
Thanks.
Ryan
hi Ryan,
Ryan Taylor wrote:
> Hello.
> I have an application I am developing with MSDE. I know that I am
> properly licensed to use MSDE and distribute that with my
> application. However, I cannot seem to find any information about
> Enterprise Manager licensing. We have a valid license of Sql Server
> 2000 and I have been using Enterprise Manager to configure my MSDE
> database. I need to install the application at a client's site and I
> was wondering if the licensing would allow me to install Enterprise
> Manager so that I can configure the database on site without having
> to use OSQL. (e.g. attaching the database)
from Microsoft representative, http://tinyurl.com/eyukf, you are not
entitled to manage MSDE in production scenario with standard SQL Server
Client Tools... you have to rely on home made tools and/or 3rd party
tools...
you can find a partial list of them, both commercial and free, at
http://www.microsoft.com/sql/msde/partners/default.asp and
http://www.aspfaq.com/show.asp?id=2442
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||There is a free tool called DbaMgr that might fill your need. This tool can
be obtained at the following URL:
http://www.microsoft.com/sql/msde/partners/default.asp
The description of the tool reads as follows:
DbaMgr for MSDE 1.0 and DbaMgr2k for MSDE 2000 provide a free graphical
management interface for MSDE installations. They allow to manage and
administer servers, databases and database objects from a Windows interface
similar to Microsoft Enterprise Manager. To traditionals SQL Server tasks as
objects management and permissions, data manipulation, SQL Agent management,
custom T-SQL statements execution window, extended properties management,
DbaMgr and DbaMgr2k provide a visual interface for BCP operations, export to
'INSERT INTO' DDL sql files, HTML database documentation as well, and are
fully localizable.
Appriopriate SQL Server Client Components and MDAC versions are required.
Microsoft Visual Basic 6.0 source code is available.
There are other, similar, tools listed on the same page.
Carl
"Ryan Taylor" <rtaylor@.stgeorgeconsulting.com> wrote in message
news:Obe5VyZUFHA.2892@.TK2MSFTNGP14.phx.gbl...
> Hello.
> I have an application I am developing with MSDE. I know that I am properly
> licensed to use MSDE and distribute that with my application. However, I
> cannot seem to find any information about Enterprise Manager licensing. We
> have a valid license of Sql Server 2000 and I have been using Enterprise
> Manager to configure my MSDE database. I need to install the application
> at a client's site and I was wondering if the licensing would allow me to
> install Enterprise Manager so that I can configure the database on site
> without having to use OSQL. (e.g. attaching the database)
> Thanks.
> Ryan
>

Enterprise Manager licensing question.

Hi,
Complete SQL Server newbie here.
I have one instance of SQL server and Enterprise Manager installed on my
server. Can I install Enterprise manager on two client computers so they
can administer the server from their desktop rather than sitting at the
server?
Thanks for your help,
Andy.Yes, if they have valid client licenses (or the SQL Server is licensed as per processor). As far as
I understand, I should add...
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Andy" <PLEASEREPLY@.THEGROUP.COM> wrote in message news:ejDjaVImDHA.2068@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Complete SQL Server newbie here.
> I have one instance of SQL server and Enterprise Manager installed on my
> server. Can I install Enterprise manager on two client computers so they
> can administer the server from their desktop rather than sitting at the
> server?
> Thanks for your help,
> Andy.
>

Enterprise Manager and Licensing

Dear all
I've had difficulty finding any reference to this on Microsoft's site.
I have a copy of SQL Server installed on a server. I use he Enterprise
Manager, Query Analyser etc on my desktop PC.
Am I in breach of any licensing agreement if I were to install the
Enterprise Manager on more than one PC?
I look forward to hearing from you
Regards
Russell
It is my understanding that you can install the client tools on as many PCs
as you are licensed to connect from.
With that said, you probably don't want to install Enterprise Manager or
Query Analyzer on an end user's machine as these tools are geard for
developers and DBA types.
Keith
"Russell Farr" <RussellFarr@.discussions.microsoft.com> wrote in message
news:D578E8C5-F33C-4E93-941C-068621691098@.microsoft.com...
> Dear all
> I've had difficulty finding any reference to this on Microsoft's site.
> I have a copy of SQL Server installed on a server. I use he Enterprise
> Manager, Query Analyser etc on my desktop PC.
> Am I in breach of any licensing agreement if I were to install the
> Enterprise Manager on more than one PC?
> I look forward to hearing from you
> Regards
> Russell

Enterprise edition licensing question

Hi,
I currently have RS Standard Edition running on a box with SQL Server 2000
Standard Edition installed, licensed and running in per-processor mode.
At an ASP, I have a box (actually, the ASP's property) with SQL Server 2000
Enterprise Edition installed, licensed and running in CAL mode. Note that we
actually own the SQL Server licenses, it's just running on their hardware.
I will be connecting to both boxes for report data.
My question: Can I install RS Enterprise Edition on my box running Standard
Edition? I feel like I should be able to because I own the Enterprise
Licenses. Unfortunately, the ASP doesn't support the installation of RS on
the box they host.
ThanksYou're likely going to have to talk to your local Microsoft Sales office as
we're supposed to avoid licensing questions in the newsgroups unless we can
point you at something on our web site that explains it. We're not lawyers
and aren't supposed to pretend that we are. :-) Look around on
http://www.microsoft.com/sql/reporting/howtobuy/faq.asp and then head over
to http://www.microsoft.com/worldwide/ to find the nearest sales office.
Sorry that I can't be more helpful...
Of course, immediately after sending this, somebody is likely to jump in
knowing the answer... :-)
--
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"PBR" <paul@.thesak.com*nospam*> wrote in message
news:OhSq1kTaEHA.3692@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I currently have RS Standard Edition running on a box with SQL Server 2000
> Standard Edition installed, licensed and running in per-processor mode.
> At an ASP, I have a box (actually, the ASP's property) with SQL Server
> 2000
> Enterprise Edition installed, licensed and running in CAL mode. Note that
> we
> actually own the SQL Server licenses, it's just running on their hardware.
> I will be connecting to both boxes for report data.
> My question: Can I install RS Enterprise Edition on my box running
> Standard
> Edition? I feel like I should be able to because I own the Enterprise
> Licenses. Unfortunately, the ASP doesn't support the installation of RS on
> the box they host.
> Thanks
>|||I'll jump in with my interpretation because your (Paul, not Stephen)
assumption is a wrong one. You are assuming that the license is not tied to
a machine. It definitely is. For each machine that has RS server installed
you need a license. Note that whether or not SQL Server DB is on that
machine makes no difference. A completely supported configuration is to have
RS on a web server and the db on a differnt box (which I will be doing
eventually). That requires two licenses. One for the DB Server and one for
the server where RS is installed. It makes no difference where the data is
coming from. The server license is for the machine you have RS installed on.
This is why for web farms you need to buy a license for each web server with
RS installed on it.
Bruce L-C
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:OoT4z$caEHA.1248@.TK2MSFTNGP11.phx.gbl...
> You're likely going to have to talk to your local Microsoft Sales office
as
> we're supposed to avoid licensing questions in the newsgroups unless we
can
> point you at something on our web site that explains it. We're not lawyers
> and aren't supposed to pretend that we are. :-) Look around on
> http://www.microsoft.com/sql/reporting/howtobuy/faq.asp and then head over
> to http://www.microsoft.com/worldwide/ to find the nearest sales office.
> Sorry that I can't be more helpful...
> Of course, immediately after sending this, somebody is likely to jump in
> knowing the answer... :-)
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "PBR" <paul@.thesak.com*nospam*> wrote in message
> news:OhSq1kTaEHA.3692@.TK2MSFTNGP09.phx.gbl...
> > Hi,
> >
> > I currently have RS Standard Edition running on a box with SQL Server
2000
> > Standard Edition installed, licensed and running in per-processor mode.
> >
> > At an ASP, I have a box (actually, the ASP's property) with SQL Server
> > 2000
> > Enterprise Edition installed, licensed and running in CAL mode. Note
that
> > we
> > actually own the SQL Server licenses, it's just running on their
hardware.
> >
> > I will be connecting to both boxes for report data.
> >
> > My question: Can I install RS Enterprise Edition on my box running
> > Standard
> > Edition? I feel like I should be able to because I own the Enterprise
> > Licenses. Unfortunately, the ASP doesn't support the installation of RS
on
> > the box they host.
> >
> > Thanks
> >
> >
>|||No, not legally. The license means you can install the software on a single
machine, if you want to install any piece such as Reporting Services or
Analysis Services on another box you need another license.
Mike Kruchten
"PBR" <paul@.thesak.com*nospam*> wrote in message
news:OhSq1kTaEHA.3692@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I currently have RS Standard Edition running on a box with SQL Server 2000
> Standard Edition installed, licensed and running in per-processor mode.
> At an ASP, I have a box (actually, the ASP's property) with SQL Server
2000
> Enterprise Edition installed, licensed and running in CAL mode. Note that
we
> actually own the SQL Server licenses, it's just running on their hardware.
> I will be connecting to both boxes for report data.
> My question: Can I install RS Enterprise Edition on my box running
Standard
> Edition? I feel like I should be able to because I own the Enterprise
> Licenses. Unfortunately, the ASP doesn't support the installation of RS on
> the box they host.
> Thanks
>