Failed Install of MSDE

Hi, folks.

I have been trying to install sql2kdesksp3 and am running into some problems. The initial install seems to go okay, even up to the point of issuing the Setup sapwd=password command-line command. However, when I try to install sql2kasp3 or sql2ksp3, a message appears saying that SQL 2000 is not installed.

I am on a XPPro SP1 desktop, with IIS 5.1 and .NET 1.1 Framework installed. Can anybody point me in the right direction to get MSDE installed?

TIA,

BobAny help on installing SQL Server Desktop Engine?|||You are using the SQL Server service pack update to install MSDE? Try downloading MSDE alone and try again. Here is the link to the MSDE download:

http://www.microsoft.com/sql/msde/downloads/dowload.asp|||Hi, Phish.

I need help getting to the SQL prompt.

I downloaded and installed the latest MSDE. The Service Manager is now running...and after a few hours of poking around I figured out my server name by looking in the log files. LOL So, it's running and the three services are available, with SQL Server as the default.

Now, I am having problems launching OSQL and I think it has something to do with the username. I do remember part of the install process where I was asked to supply a password. I am using that password in this situation. I tried the following, where "administrator" is the local workstation's administrator account. For kicks, I tried "sa" as a username. No luck. Here's the output:

D:\Temp>osql -U administrator
Password:
[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect()).

D:\Temp>osql -U sa
Password:
[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect()).

D:\Temp
Where do I go from here so I can start playing with MSDE?

TIA,

Bob|||You might have authentication twisted up. I also ran into that problem when attempting to connect thru OSQL. Take a look at this article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;322336#4

This will help you determine and show you how to change your authentication mode. When i reset the registry value to 2 for LoginMode I don't experience any problems. Hope this helps.

- Jesse Williams