Re: Basic "getting started" Info on MSDE 2000?

(bidalah@xxxxxxxxx) writes:
> I am looking for basic info on installing and using MSDE.
>
> I am trying to install and play with MSDE on my PC (Win2000). I
> finally managed to work my way through installation, and named
> instances but I am finding no information on how to simply START the
> database engine and get to a sql prompt! I have manually started the
> MSSQL and SQLAGENT services, and tried running sqlservr.exe and
> osql.exe (just guessing) without success. Can anyone refer me to a
> document that gives this BASIC information!?

SQL Server runs as a service, and you should start it from the
Services Applet in the Control Panel (under Administrative tools). I
don't if you get SQL Server Manager with MSDE; if you do, you can use
this tool a well. The same applies to SQL Server Agent.

You can start sqlservr.exe from the command line, but this is advanced
usage.

OSQL is a client, and this you run from the command line. To connect
with integrated security say:

osql -E -S .\INSTANCENAME

replace INSTANCENAME with the actual name of your instance.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
.

Relevant Pages

  • Re: Program FilesMicrosoft SQL Server80?
    ... > When installing MSDE onto the d: ... Are theses things needed for MSDE to ... among all instances with different service pack level, ... Andrea Montanari (Microsoft MVP - SQL Server) ...
    (microsoft.public.sqlserver.msde)
  • Re: Installation OK, but cant connect
    ... tell the person installing to create a user ... >but your MSDE will act as a single desktop database ... edits MSDE, or already have MSDE or SQL Server installed?) ... In what way do I use SQL Server to minimize ...
    (microsoft.public.sqlserver.msde)
  • Re: SQLServerAgent???
    ... >> events in the Event Log, it seems to do something with the network. ... > If both services are 'started', you are running an instance of SQL Server ... > (or MSDE) on your computer. ... > and installing MSDE, then it was installed as part of another application ...
    (microsoft.public.win2000.general)
  • Re: SQL Server Service Manager not started unless network protocol support enabled.
    ... > I am using MSDE as the backend to a VB application I am building and have ... > 1) When initially installing the instance I opted to specify an Instance ... >discovered that I need to enable network support for this to work. ... Andrea Montanari (Microsoft MVP - SQL Server) ...
    (microsoft.public.sqlserver.msde)
  • Basic "getting started" Info on MSDE 2000?
    ... I am looking for basic info on installing and using MSDE. ... I am trying to install and play with MSDE on my PC. ... document that gives this BASIC information!? ...
    (comp.databases.ms-sqlserver)