MSDE Problems

I am having sever troubles installing msde. I download the sql2kdesksp3 from microsoft and then I run it. Nothing is installed! I have to do statements in command prompt, statesment which I dont understand and im probably not doing them right either. After a lot of testing and trying I finally got it installed. But it didnt say MSSQL$NetSDK as it is showed in my book, it said MSSQL Server. And from on there Im stuck. I have tried to add a connection in vs.net as it says with (local)NetSDK but it just says it cant open a connection. My computer name is Kris, I think I should use that instead of (local) and I dont know at all what they mean by NetSDK.
Can anyone help me?

Regards Kristoffer

Windows XPI'm not an MSDE install expert by any means but I would go out to the command prompt (Start->Run->cmd->OK) and type in

osql -L

That will give you a list of all the Sql Server and MSDEs on your computer. Hopefully one will by Kris\SomeInstanceName. Try that name or whatever name turns up.

You might also check in the Setup.Ini file that is in the same directory as you installed MSDE from. If you open it in Notepad or equivalent tool look for the

INSTANCENAME=SomeInstanceName

That should correspond to one of the name returned by osql -L

(local) is an all purpose name that just means "use this server".sql

MSDE Install roll-back

Downloading and running "sql2kdesksp3.exe" worked with no problems.

But running the setup program that was created has proved less successful no matter what options I specify. The installation starts but moments from completion the progress bar begins moving backward. No error message is displayed and the installation dialog simply closes.

Looking in the 'Program Files' directly during the installation shows a SQL directly but this directory is deleted before the installation dialog closes.

I've installed 'ASP.NET Web Matrix'.

What is causing the installation to rollback? Is this a licensing issue?

Some of my attempts so far:

setup SAPWD=hello SecurityMode=SQL

setup SAPWD=hello

setup SAPWD=hello INSTANCENAME=sqlstarterkitThe documentaion SUCKS for beginners (like me). I got it to work after giving the ASP.NET Machine user admin privlages, but who knows if that was the issue. I also setup using similar lines that you did.

In my search for an answer, it seems MANY people have this problem, and no one seems willing to give an answer, or a newbie-friendly how-to.

Good luck,

mikeP|||I'm in the same boat

I get the same rollback response after following the installation instructions.

Although the very 1st time I installed it, I did get a little further with the installation. I was
able to restart and was able to see the the little computer icon (with a flashing green light) located on my desktop toolbar at the botton of the screen, that said (SQL Running) when you placed the the mouse pointer over it.

Next I open up the web Matrix and proceeded to create a Database which was almost successful untill I received the following Message:

Unable to connect to the database server.
Login failed for user 'SA' Reason:
Not assoicated with a trusted SQL Server connection.

So next I thought I would uninstall & Reinstall & try again to see if I would have better luck the 2nd time. But Now each time that I have tried to reinstall MSDE "sql2kdesksp3.exe" &
follow the same installation procedure, I'm only able to get as far as Command prompt
setup and installation, then I get the same installation rollback same as what you descibed.

I also wish someone if anybody has any advice it would be greatly appreciated.

MSDE install problem

Hi,

My computer OS is win2000 +sp3, I download the MSDE setup file(sql2kdesksp3.exe), I followed the instruction of the microsoft web site to install the msde, but during the windows configure the SQL server desktop engine, it hangs up there. I checked the setup log file, it has no error, it goes to sqlredis.exe, and stop there.

Can any one help me for this?

I really appreciated!

zgWhat is the command line you are using to install msde?

-Kashif