Can't install MSDE

I have tried to install MSDE 2000, first the normal version, then the
one for developers using Visual Studio .NET. Each time the installation
appears to complete, but there is no shortcut to start the program and
it's not in the Start/Programs menu. However, if I look for it in "Add
and Remove Programs" it's there.
The directory

C:\Program Files\Microsoft SQL Server\MSSQL\Binn

includes some exe files and I have tried to start them, but nothing
appears to happen. If I start sqlsrvr.exe I get a command prompt window
in which I see things like "Server Process ID is 182", "Logging SQL
server messages in file..." etc, but I have no idea how to go on from
there.
I tried installing the new 2005 Beta version but exactly the same
problem.
Why is this happening? How can I make it work?
Thanks in advance.

Bruno Panetta

PS the installation probably doesn't even complete. The installation
window just disappears at some point, without saying that it completed
successfully.


Bruno Panetta  wrote:
> I have tried to install MSDE 2000, first the normal version, then the
> one for developers using Visual Studio .NET. Each time the installation
> appears to complete, but there is no shortcut to start the program and
> it's not in the Start/Programs menu. However, if I look for it in "Add
> and Remove Programs" it's there.
> The directory
>
> C:\Program Files\Microsoft SQL Server\MSSQL\Binn
>
> includes some exe files and I have tried to start them, but nothing
> appears to happen. If I start sqlsrvr.exe I get a command prompt window
> in which I see things like "Server Process ID is 182", "Logging SQL
> server messages in file..." etc, but I have no idea how to go on from
> there.
> I tried installing the new 2005 Beta version but exactly the same
> problem.
> Why is this happening? How can I make it work?
> Thanks in advance.
>
> Bruno Panetta

There is no UI tool for MSDE.  MSDE is a database engine that can be
manipulated programmatically via the various APIs, using the OSQL command
line utility or using any of various third party utilities.

SQL 2005 Express (the product that replaces MSDE) does have a UI called
Express Manager but it's a separate download to the database engine product.
http://lab.msdn.microsoft.com/express/sql/

--
David Portas
SQL Server MVP
--

Thanks but I'm afraid I don't understand since I'm a beginner to SQL
and am trying to install this program in order to learn it.
What should I do once I have installed MSDE 2000 in order to start
creating databases and running SQL queries?
Thank you very much.

Bruno

David Portas  wrote:
> There is no UI tool for MSDE.  MSDE is a database engine that can be
> manipulated programmatically via the various APIs, using the OSQL command
> line utility or using any of various third party utilities.
>
> SQL 2005 Express (the product that replaces MSDE) does have a UI called
> Express Manager but it's a separate download to the database engine produc
t.
> http://lab.msdn.microsoft.com/express/sql/
>
> --
> David Portas
> SQL Server MVP
> --

http://www.aspfaq.com/show.asp?id=2442

--
David Portas
SQL Server MVP
--