Installation

Hi,
I am very new to MSDE version. I just installed MSDE ver
A and cannot see Enterprise Manager pointer or Query
Analyzer pointer in All Programs menu. I guess, MSDE does
not have these editors.
I would really appreciate if you can answer my following
Q:
1) Does MSDE has all these editors mentioned above.
2) Where can i read more stuffs related to MSDE ver A
3) I am unable to connect to MSDE ver A from another
machine through Client tools.
4) How do i install my SQL scripts to create database,
tables, procedures etc
Thanks again,
David
David wrote:
> Hi,
> I am very new to MSDE version. I just installed MSDE ver
> A and cannot see Enterprise Manager pointer or Query
> Analyzer pointer in All Programs menu. I guess, MSDE does
> not have these editors.
> I would really appreciate if you can answer my following
> Q:
> 1) Does MSDE has all these editors mentioned above.
> 2) Where can i read more stuffs related to MSDE ver A
> 3) I am unable to connect to MSDE ver A from another
> machine through Client tools.
> 4) How do i install my SQL scripts to create database,
> tables, procedures etc
>
Hi David,
AFAIK MSDE comes without any tools - by design the client
application is responsible for creating the table etc.
(e.g. M$ Access in an ADP-project).
but there exists some freeware tools which can act as a
replacement for the enterprise manager, e.g. DbaMgr2k
which you can find at http://www.asql.biz/DbaMgr.shtm
HTH,
Gerald
|||hi David,
"David" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:14ce01c4df1b$08502e40$a601280a@.phx.gbl
> Hi,
> I am very new to MSDE version. I just installed MSDE ver
> A and cannot see Enterprise Manager pointer or Query
> Analyzer pointer in All Programs menu. I guess, MSDE does
> not have these editors.
> I would really appreciate if you can answer my following
> Q:
> 1) Does MSDE has all these editors mentioned above.
nope, as Gerald already pointed out, MSDE comes with no tool but oSql.exe, a
command line tool; please have a look at
http://support.microsoft.com/default...;EN-US;q325003 for further
info about it and some common uses with MSDE...
further tools are listed at
http://www.microsoft.com/sql/msde/partners/default.asp and/or
http://www.aspfaq.com/show.asp?id=2442 ... google for others...

> 2) Where can i read more stuffs related to MSDE ver A
actually, AFAIK, there are no related stuffs to read about MSDE, as it is an
edition of SQL Server 2000, so you can have a look at SQL Server related
stuffs... you have to be aware of MSDE limitations you can inspect at
http://www.microsoft.com/sql/msde/pr...o/overview.asp , but, if the
eventual feature you are reading about is available for MSDE too, you can
take advantage of existing SQL Server doumentation...
for your convenience, if you didn't already, you can download SQL Server
Books On Line, the official Microsoft documentation about SQL Server, at
http://www.microsoft.com/sql/techinf...000/books.asp, updated at
the latest service pack..

> 3) I am unable to connect to MSDE ver A from another
> machine through Client tools.
MSDE installs by default disabling network protocols to protect the server
from remote malicious attacks, so only local connections are enabled... to
change this behaviour at install time, you have to provide the
DISABLENETWORKPROTOCOLS=0
parameter to the setup.exe boostrapper installer, or, if already installed,
you have to run the Server Network Utility (svrnetcn.exe) to enable the
desired network protocol..

> 4) How do i install my SQL scripts to create database,
> tables, procedures etc
if you do have the DDL Transact-SQL scripts, you can execute them via
oSql.exe (have a look at the provided link for further info about oSql.exe),
my project too provides executing Transact-SQL scripts features too as quite
all the Query Analizer replacement tool...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks Andrea. Your reply really gives me lot of info.
David

>--Original Message--
>hi David,
>"David" <anonymous@.discussions.microsoft.com> ha scritto
nel messaggio[vbcol=seagreen]
>news:14ce01c4df1b$08502e40$a601280a@.phx.gbl
ver[vbcol=seagreen]
does[vbcol=seagreen]
following
>nope, as Gerald already pointed out, MSDE comes with no
tool but oSql.exe, a
>command line tool; please have a look at
>http://support.microsoft.com/default.aspx?scid=kb;EN-
US;q325003 for further
>info about it and some common uses with MSDE...
>further tools are listed at
>http://www.microsoft.com/sql/msde/partners/default.asp
and/or
>http://www.aspfaq.com/show.asp?id=2442 ... google for
others...
>
>actually, AFAIK, there are no related stuffs to read
about MSDE, as it is an
>edition of SQL Server 2000, so you can have a look at
SQL Server related
>stuffs... you have to be aware of MSDE limitations you
can inspect at
>http://www.microsoft.com/sql/msde/pr...fo/overview.as
p , but, if the
>eventual feature you are reading about is available for
MSDE too, you can
>take advantage of existing SQL Server doumentation...
>for your convenience, if you didn't already, you can
download SQL Server
>Books On Line, the official Microsoft documentation
about SQL Server, at
>http://www.microsoft.com/sql/techinf...ctdoc/2000/boo
ks.asp, updated at
>the latest service pack..
>
>MSDE installs by default disabling network protocols to
protect the server
>from remote malicious attacks, so only local connections
are enabled... to
>change this behaviour at install time, you have to
provide the
>DISABLENETWORKPROTOCOLS=0
>parameter to the setup.exe boostrapper installer, or, if
already installed,
>you have to run the Server Network Utility
(svrnetcn.exe) to enable the
>desired network protocol..
>
>if you do have the DDL Transact-SQL scripts, you can
execute them via
>oSql.exe (have a look at the provided link for further
info about oSql.exe),
>my project too provides executing Transact-SQL scripts
features too as quite
>all the Query Analizer replacement tool...
>--
>Andrea Montanari (Microsoft MVP - SQL Server)
>http://www.asql.biz/DbaMgr.shtm
http://italy.mvps.org
>DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
>(my vb6+sql-dmo little try to provide MS MSDE 1.0 and
MSDE 2000 a visual
>interface)
>-- remove DMO to reply
>.
>