Hi everybody,

Background
I am a senior citizen (not that that makes any damned difference) who has taken on the daunting challenge of putting an end to freeway traffic congestion, hence, this also involves, a software challenge. My OS is Windows 2000 Professional. I purchased Microsoft FrontPage 2003, the book FrontPage 2003 Inside Out, by Jim Buyens, and began building a Web site to engage commuters in the battle to put an end to being stuck in traffic. I put the Web site on a hosted Microsoft Windows 2003 server so that meant I could not use the self-registration system provided in FrontPage. I attempted to put the ASP.NET self-registration system that Buyens provided in Inside Extras but I ran into trouble hooking it up to Microsoft Access so I went to the Microsoft Help Web site.

Looking for VB code
I was looking for code when I discovered that I should have .NET Framework 1.1, so I downloaded it. Then I discovered a wonderful thing called ASP.NET Web Matrix, so I downloaded it. Then I discovered an answer to my dreams: the ASP.NET Commerce Starter Kit. Not only does it provide the e-commerce solution but it also has a self-registration system. Wow! Somewhere back there I discovered I needed Microsoft SQL MSDE and there it was?free. Wow, again. I downloaded it, that is, sql2ksp3, and now I thought I was ready to see what I have downloaded and put it all together.

I was amazed
The ASP.NET Web Matrix seems like an answer to prayer. Having fooled around quite a bit with VBA for Excel 5 several years ago, this tool looks marvelous to me. I know I am really going to enjoy working with it, but you guessed it, I have a problem.

The Problem
I have been unable to install ASP.NET Commerce Starter Kit because it will not connect to the SQL MSDE database. Every attempt to install ends up a failure because when I Click on Test Connection in the ASP.NET Commerce Database dialog box I get the Failed Connection textbox that reads, ?Unsuccessful Database Connection.? What I am seeing again, though, is localhost in the dropdown textbox on the ASP.NET Commerce Database dialog box. When I changed that to local in ASP.NET Web Matrix Connect to Database dialog box I was able to get a connection to the SQL MSDE Database. Do you suppose that is the problem in this case? Also, a couple of unknowns in my mind: I don?t have IIS on Windows 2000 Professional so I unchecked the checkbox that asks, Support IIS?, but I get the same result either way. In addition, I Clicked the local radio button when the screen asked the remote or local question. Well, I just now tried to install using the remote option, and I got an install. Am I expecting too much to install it locally and work with it on my computer until I get right before I publish it to the host server? I think I have Cassini because I have ASP.NET Web Matrix, and I also have the SQL MSDE Engine now so what am I missing?

I believe
I believe I will love everything I have gotten from the ASP.NET Team once I get it all working. Thanks for some great programming and tools.

Ken

I have been stuck on this for about a week and today fixed it, so here is what helped me. Simple change your computer name to "localhost" and reboot and try install again. Crazy that you need to change the computers name but it worked for me so i'm happy. Also not sure if you need IIS but if you do it is on your Windows CD ans an extra, go to the control panel/windows components and tick IIS and put the windows disk in. You may also have to register it with the .net framework as you installed it before ISS to do this go to the run dialog and put this in C:\WINNT\Microsoft.NET\Framework\v1.1.4322\aspnet_regiis -i then reboot. Hope that helps

Mike

Mike,

You are awesome, Mike! I followed your instructions exactly and it worked exactly as you said. Wow! What a relief! I got the IIS off my CD, registered it with .net framework, changed my computer name to localhost, removed Commerce from the remote location I had previously installed it to and reinstalled it after the reboot. Just as you said.

Thanks so much for coming to the rescue.

Ken

Why does it have to be like this. I tried changing my computer name to "localhost", and restarted... then it was able to connect to the database easily. I think maybe we should have used remote and then given our IP address and port that IIS is listening to, then we probably would have no trouble.... but that's just a guess, since I used the local settings with "localhost".

I found an answer that solves the problem creating an instance in the MSDE database server with the name one wants, and that solves the problem. I am posting it in all the questions posted on this issues, hoping it will be useful to more people.

By: Jobowoo

Re: Pbm Installing Commerce Starter Kit
Posted: 08-14-2003 05:36 PM
Alot of people are having this problem, you have to create an instance.


1) Find your MSDE folder there should be a setup.exe

2) Go to notepad and type in: setup.exe SAPWD=(any password) INSTANCENAME=(any name)

3) Save the notepad as a .bat file in the MSDE folder.

4) Run the .bat file and the instance is created.

5) Go back to the installation for the starterkit and when it comes back to the picking of the "localhost" you should see your instance that you created, pick that.

Good Luck.

Thanks, Gigent! I followed your instruction and solved the problem.

i do .bat file. but when setup it's still unsuccessful database connection. How should i do?

Gigant,

this is amazing! =) i just did everything about the instance and batch file stuff and it worked! and its really cool to have the database server name i want without changing my pc name.. =) thanks for sharing!

I ran the .bat file also and I see the instance name in the list. I am still getting Unsuccessful database connection. But, I can connect to the db in VS or in Web Matrix. Any ideas?

I just got it fixed. I had to start the service of the db instance and then the install went through!! Woo Hoo!!!

Help! I'm doing just that but I get an error message after I run the .bat file that the instance name is invalid. I'd appreciate any help. I can connect just fine to the local MDSN/SQL Server and run it via WebMatrix. It's "name" is (LOCAL)(Windows NT). Thanks!

the .bat file I created is called update.bat:

setup.exe SAPWD=(password) INSTANCENAME=(LOCAL)

Just found the solution. Forget the batch file. Get a C prompt, cd to your sql2ksp3 directory and then your MSDE folder and then type:

setup INSTANCENAME="InstanceName" SAPWD="AStrongSAPwd"

Where you set the instancename and the password to whatever you want.

That will create an instance of MSDE/SQL Server.

Then go to Services and start that instance.

That'll do it.

What do you mean by "Go to Services"?
(stet-by-step)

Go to Start --> Control Panel --> Administrative Tools --> Services

Please Help me!!!!
When I set up ASP.NET Commerce, test connection to MS SQL 2000 successful, and then i get an error "Unknow error 0x80005000". Please tell me about it