Connect to MSDE/SBS2003 remotely

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.
What I have found out so far is that I need to check if Server Network
Utility (svrnetcn.exe) is present and has enabled TCP/IP protocol. But I am
sure that is not the end of the story...
"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.
>
|||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.
>
begin 666 ts.gif
J1TE&.#EA`0`!`( ``````/___R'Y! $`````+ `````!``$```(!1 `[
`
end
|||Hi bobby,
In addition, we've got a program called MSDE Manager that's free for
personal use. Details at our site.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"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.[vbcol=seagreen]
> "bobby" <bobby@.bobbys.com> wrote in message
> news:%23arsRdOjEHA.3612@.TK2MSFTNGP12.phx.gbl...
the[vbcol=seagreen]
get[vbcol=seagreen]
utilities[vbcol=seagreen]
to[vbcol=seagreen]
to
>
>
sqlsql