MSDE 1.0 and SQL Server

Apparently since I downloaded SQL Server SP3 and tried to install it on a computer without SQL Server in the first place, it's a bad thing.

I'm trying to get SQL Server Desktop Engine to install and I do the cmd.exe thing and it works, then 1 second before it finishes it rolls back.

All the files are still there, just missing the ones you need to run the SQL Server.

I used to have it on my 98, before I upgraded. Now I have the ASP.NET WebMatrix on my XP Home.

Is there a way to get SQL to install correctly?

JohnAre you sure you want to install MSDE 1.0?? That is a SQL Server 7-compatible data engine.

There seems to be a good walkthrough on installing MSDE 2000 in the ASP.NET Web Matrix Guided Tour:Install MSDE 2000.

Terri|||I tried that, perfectly and by all the things it said, and it still backed out at the last few seconds.

I have no idea. I've only herd that XP Home dosn't support IIS but this thing had XP (General) as in Home and Pro for the supported OS's. I really don't now whats wrong.

John

MSDE - MSSQL$MICROSOFTSMLBIZ ?

I need to work with MSDE on a new laptop ive been given. Apparently msde is already installed. I have a service runningnamed "MSSQL$MICROSOFTSMLBIZ" - how do i configure it, or shouldI just download a later copy of msde and setup a new copy ? Iknow I know...use sql express. However, I need to work with msdein this case to make it easier (on me) for moving the data into a sql2000 database.

thanks

So you have SQL2000 instance? Then you can register the MSDE instance in Enterprise Manager, thus it should be much easier to manage the MSDE databases: Open Enterprise Manager->right click a SQL Server Group->choose New SQL Server Registration.

Otherwise you have to use osql utility to manage MSDE, which would be painful if you're not familiar with T-SQL.