n00b Question Re: MSDE SQL Server Install

Sorry if I sound to simple for you, I'm not sure what your
experience is, and this is how I understand it best.)
SQL Server runs as a Service. That's an app that runs in
the background.
You can have more that one 'Instance' of SQL Server
running at a time. (The number allowed depends on the
version you install.) This allows, let's say, your Website
database running in one instance to crash without having
your accounting db (on another instance) going down also.
On each instance of SQL Server, you can have a number of
Databases.
Hopes that clears some things up. Did you install MSDE (MS
SQL Server Desktop Edition) or SQL Server
Standard/Enterprise/Personal edition?
MSDE does not install some management tools that make
things real easy.
It was Desktop Edition.
"M K" <mark@.nospamcenturycolor.com> wrote in message
news:252001c427c3$54b21740$a001280a@.phx.gbl...
> Sorry if I sound to simple for you, I'm not sure what your
> experience is, and this is how I understand it best.)
> SQL Server runs as a Service. That's an app that runs in
> the background.
> You can have more that one 'Instance' of SQL Server
> running at a time. (The number allowed depends on the
> version you install.) This allows, let's say, your Website
> database running in one instance to crash without having
> your accounting db (on another instance) going down also.
> On each instance of SQL Server, you can have a number of
> Databases.
> Hopes that clears some things up. Did you install MSDE (MS
> SQL Server Desktop Edition) or SQL Server
> Standard/Enterprise/Personal edition?
> MSDE does not install some management tools that make
> things real easy.
|||Yea, Desktop Edition, MSDE, is the redistribution version.
Stripped down. I would think your app would create the
database for itself.
If you don't have a version of SQL running you can install
MSDE with mostly defaults. You don't need to set an
Instance. Then install the app and it should set up the
database.
I hate it when I don't have enough documentation, don't
you.