I'm trying to run MDSE 2000 (the free download version) locally with Commerce Startup Kit, but it won't install. I choose local for the installation. The installation script asks me to select a local database instance. localhost is the only instance but when I press the "Test connection" button, it fails ("unsuccessful database connection") and won't complete the install.

I installed MDSE 2000 with this
setup SAPWD="passwordstring"

The command prompt returns without any feedback.

The original message wasn't clear that it's the Commerce Starter Kit install that is failing, not MDSE 2000.

What I'm "trying" to do is just install and run the starter kit on my local machine. This should be easy, but I can't figure out what I'm doing wrong.

Can anyone help please?

Mark

I'm experienceing the same problem. :(

If I find anything out I'll let you know.

Mark

I had setup MDSE with a blank password. This was being caught as a blank SQL password by my firewall (Norton Internet Security). I added localhost (127.0.0.1) to my trusted zones in my firewall config and it installed fine after that.

Hope this helps.

Mark

I'm trying to run everything locally, so I'm not going through a firewall. Glad you're problem is solved though.

Did you do anything else for the MDSE setup other than the install?

I got the same problem so if anybody could help me...
And i wonder what's the difference between SDK and VS Versions ?

Same problem with all starter kits ..... think the problem from MSDE.....
any suggestions???

Calumn

Found it !!!!!

Just give a name to the sql instance and DO NOT use "SecurityMode=SQL" when setup :

Microsoft advise Windows authentication and not SQL.

like follow :

C:>sql\MSDE\Setup SAPWD="sa_password" INSTANCENAME="sqlstarterkitinstance"

let's coding good web apps ....

Calumn

Precision : It works with Commerce, Time Tracker, Portal but not with community and reports...

for community, setup like this :

Setup SAPWD="sa_password" ==> without instance name and SecurityMode

for reports, still in error during install....

Calumn

Calumn

It worked for me also. Finally!!!!!!!!!!!!!!!!!!!!!!!!!!!

Thank you very much.

Mark

Hey Folks, I'm having the same prob.

I tried it with the INSTANCENAME="sqlstarterkitinstance" paramater and it came up in the dropdown list but when I click the 'Test Connection' button the same thing happens 'Unsuccesful database connection' and I can't proceed any further. Just to make sure, can the instance name be anything or does it have to be something specific?

System settings:
WIN2k
sql2ksp3
Visual Studio Pro 2003
.net 1.1

I'm pretty sure it can be anything. I used INSTANCENAME="sqlstarterkitinstance" just becasue I pasted someone else's command line. I wish I could help, but I don't know why mine worked and yours didn't.

Mark

Well after doing the same thing about 10 times it managed to install ok. But now I'm getting the error:

SQL Server does not exist or access denied.

Are there some other MDSE settings I have to configure?

I had the same problem. I got it working by going into ControlPanel/AdministrativeTools/Services and manually starting the "SQLSERVERAGENT" and "SQLAgent$InstanceName" services (which were set to MANUAL by default). I then set them to run automatically.

Hope that helps

GS

Thanks guys! I had all those problems and you solved them for me. Now.. I get the message "unknown error 0x80005000. Does anyone have some advice?. I am Running XP Prof with IIS, MDSE, & .Net v1.1 as prescribed.