Can't install MSDE - Microsoft SQL Server

Bruno Panetta

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

Jul 23 '05 #1

Subscribe Post Reply

3785

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

Jul 23 '05 #2

David Portas

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
--

Jul 23 '05 #3

Bruno Panetta

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 product.
http://lab.msdn.microsoft.com/express/sql/

--
David Portas
SQL Server MVP
--

Jul 23 '05 #4

David Portas

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

--
David Portas
SQL Server MVP
--

Jul 23 '05 #5

Similar topics

Install SQL 2000 on Win XP Home

by: Demetris | last post by:

Hello there! I am trying to install MS SQL 2000 Server on Windows XP Home edition. I found in Microsoft that the above installation is possible. But when i run the installation, i am getting a...

Microsoft SQL Server

MSDE Install Problem

by: Daro Bruno | last post by:

Hello, I have just purchased a new CPU and when I attempt to install MSDE the process nears the end and stops, and removes the installed files. If anyonr has an idea on a correction let me...

Microsoft SQL Server

Install of SQL Server 2000 dev edition over MSDE. Any advice appreciated.

by: Andy B | last post by:

It's arriving from ebuyer tomorrow for 32 quid. I already have an instance of MSDE running on the laptop and ideally i would like SQL server to be installed and use the current instance and not...

Microsoft SQL Server

Can SQL Server 7.0 handle a SQL Server 2000 mdf?

by: Mike Watson | last post by:

I've got MSDE, SQL Server 7.0, installed. I want to handle an .mdf developed by someone else so I loaded the .mdf into my /DATA folder. But, MSDE/ODBC can't see the database. I subsequently...

Microsoft SQL Server

Unable to install MSDE

by: farqua | last post by:

I've been trying to install MS SQL Server 2000 sp3 on a stand alone WinXP box. I've tried using the version that came on the Office Pro 2003 cd as well as the latest download from MS (apparently...

Microsoft Access / VBA

Why can't Access create an ADP project in MDSE?

by: Lou Arnold | last post by:

I can't create a database in MSDE with MS Access. Why? Some details: 1) Single computer - so there is no domain controller. 2) No firewalls. A fresh install of Win2K SP4, MSDE 2000A and MS...

Microsoft Access / VBA

Can't use 'local' to find sql server instances on local machine

by: karim | last post by:

My computer (connected to a domain) is having trouble connecting to the local MSDE when using 'local' or '(local)' as server name. The only way I can connect to server through Visual Studio or DTS...

ASP.NET

Best install software

by: Wardeaux | last post by:

All, I'm distributing an ASP.NET app that uses MSDE. I need a setup routine that will first of all check if IIS is installed and running... then if it is will install MSDE, copy/run DB setup...

ASP.NET

Can I manage MSDE with SSMS??

by: tlyczko | last post by:

Hello, We have an XP workstation containing a very important MSDE-based application. Its MSDE database isn't likely to change for quite a while. The app contains an internal backup method...

Microsoft SQL Server

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp