"bobby" <bobby@bobbys.com> wrote in message
news:%23arsRdOjEHA.3612@TK2MSFTNGP12.phx.gbl...
> I am writing a small app for a company using Access (adp) and MSDE. The
MSDE
> is installed on a Small Business Server and I have been told it is a
> complete standard setup.
>
> First question: I know MSDE is running because I recognise the icon in the
> system tray. Also, locally I can connect to the MSDE so I know it is
there.
> However, from previous installations of MSDE I seem to recall that
although
> you don't get Enterprise Manager, Query Analyzer etc with MSDE, you do get
> Client Network Utility etc. I have not been able to locate *any* utilities
> for MSDE on the server. Is this normal?
>
> This brings me onto my main question. I expect to do some alterations to
the
> database after the initial installation, and it is not feasible for me to
> make a trip to the client for every alteration. I would therefore like to
be
> able to use Enterprise Manager that I have locally to connect to the
remote
> SBS/MSDE. How do I do that under the circumstances? I know they have a
Cisco
> firewall in place.
>
> Any pointers in the right direction would be much appreciated.
>
>

"bobby" <bobby@bobbys.com> wrote in message
news:%23arsRdOjEHA.3612@TK2MSFTNGP12.phx.gbl...
>I am writing a small app for a company using Access (adp) and MSDE. The
>MSDE
> is installed on a Small Business Server and I have been told it is a
> complete standard setup.
>
> First question: I know MSDE is running because I recognise the icon in the
> system tray. Also, locally I can connect to the MSDE so I know it is
> there.
> However, from previous installations of MSDE I seem to recall that
> although
> you don't get Enterprise Manager, Query Analyzer etc with MSDE, you do get
> Client Network Utility etc. I have not been able to locate *any* utilities
> for MSDE on the server. Is this normal?
>
> This brings me onto my main question. I expect to do some alterations to
> the
> database after the initial installation, and it is not feasible for me to
> make a trip to the client for every alteration. I would therefore like to
> be
> able to use Enterprise Manager that I have locally to connect to the
> remote
> SBS/MSDE. How do I do that under the circumstances? I know they have a
> Cisco
> firewall in place.
>
> Any pointers in the right direction would be much appreciated.
>
>

"Stephen Dybing [MSFT]" <stephd@online.microsoft.com> wrote in message
news:O7dgcQrjEHA.1348@TK2MSFTNGP15.phx.gbl...
> MSDE does not ship with any of the graphical utilities that you're used to
> seeing. It does ship with a command line utility, osql.exe, that you can
use
> to manage it, assuming that you're familiar with T-SQL.
>
> As to whether or not you're allowed to use the copy of SQL Server
Enterprise
> Manager you have to manage it remotely, I doubt it. Please see the FAQ
page
> at http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp. The sixth Q & A
> is the following:
>
> Q. Can I use SQL Server tools and services in conjunction with
MSDE?
>
> A. 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. Visit the
How
> to Buy page for information on obtaining a valid SQL Server license.
>
> Note: The tools and services included with SQL Server Developer
> Edition may not be used to manage production server environments.
>
> The following utilities are installed by the MSDE setup application
> and are provided without restrictions for use with the copy of MSDE that
is
> installed by your application: bcp.exe, cnfgsvr.exe, dcomscm.exe,
osql.exe,
> sqlmaint.exe, sqlmangr.exe, scm.exe, sqladhlp.exe, and svrnetcn.exe. The
> dtsrun.exe utility is also provided, but can only be used to run existing
> Data Transformation Services (DTS) packages against the copy of MSDE
> installed by your application; it cannot be used to develop new DTS
> packages.
>
>
>
> It sounds to me like the small app that you're writing isn't being used in
> conjuction with your copy of SQL Server 2000 and thus you won't be allowed
> to use SQL Server Enterprise Manager against it.
>
> As always, of course, I'm not a lawyer so you should consult yours. :-)
>
> --
> Sincerely,
> Stephen Dybing
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "bobby" <bobby@bobbys.com> wrote in message
> news:%23arsRdOjEHA.3612@TK2MSFTNGP12.phx.gbl...
> >I am writing a small app for a company using Access (adp) and MSDE. The
> >MSDE
> > is installed on a Small Business Server and I have been told it is a
> > complete standard setup.
> >
> > First question: I know MSDE is running because I recognise the icon in
the
> > system tray. Also, locally I can connect to the MSDE so I know it is
> > there.
> > However, from previous installations of MSDE I seem to recall that
> > although
> > you don't get Enterprise Manager, Query Analyzer etc with MSDE, you do
get
> > Client Network Utility etc. I have not been able to locate *any*
utilities
> > for MSDE on the server. Is this normal?
> >
> > This brings me onto my main question. I expect to do some alterations to
> > the
> > database after the initial installation, and it is not feasible for me
to
> > make a trip to the client for every alteration. I would therefore like
to
> > be
> > able to use Enterprise Manager that I have locally to connect to the
> > remote
> > SBS/MSDE. How do I do that under the circumstances? I know they have a
> > Cisco
> > firewall in place.
> >
> > Any pointers in the right direction would be much appreciated.
> >
> >
>
>
>