473,881 Members | 1,651 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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\Bi nn

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
4 3805
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\Bi nn

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
There is no UI tool for MSDE. MSDE is a database engine that can be
manipulated programmaticall y 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
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 programmaticall y 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
http://www.aspfaq.com/show.asp?id=2442

--
David Portas
SQL Server MVP
--
Jul 23 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
10583
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 black screen that is closes after a second. Nothing else happens. Any ideas how to troubleshoot this? Thank you
2
1216
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 know. Thanks
2
1261
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 install any other additional services. Basically all i would like is to use the Enterprise Manager with my existing MSDE database. I was wondering if there is anything i should be doing before I install. Should i shut down the service or leave it...
7
2596
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 discovered that it was created using SQL Server 2000. Is this the reason that my MSDE 7.0 doesn't see the .mdf? If so, how can I use this database with my 7.0? Backup from 2000, restore to 7.0? Thanks for any help.
2
2091
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 they are the same). This is a new install and I am install from an account with administrative privileges (actually it's the only account on this box). I've tried installing from a DOS box and from an explorer window. I've tried inputing...
0
1105
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 Access SP3. 3) All is done thru the standard Windows Admin account. 4) MSDE is set for Windows Athentication. 5) I can create a database with Osql.exe and with a MSDE Plus, a 3rd party Admin tool.
1
7563
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 in Enterprise manager is when using domainname\localcomputername format. Also when I try to install the starter kits from asp.net, the installer in each kit fails to find sql server instances. I am pretty sure it's related to fact the installer is...
0
949
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 routines and then lastly install the app. Which products out there do this and how easy is it to learn and use? MTIA wardeaux
1
2543
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 (File, Backup, Backup) and an auxiliary app/script for shrinking the database and logs. I would like to automate the backup and shrinking so end users don't have to remember to do them.
0
11098
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10401
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9552
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7953
isladogs
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7109
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 then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5781
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5977
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
4196
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3223
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.