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
>