Commerce Starter Kit

Re: MDSE Problem with Commerce Starter Kit Install

geoffHome — Fri, 17 Oct 2003 23:24:12 GMT

I'm having all same problems as you all and also don't seem to have a SQLAgent$InstanceName service.

Got nowhere with Local install so nominated Remote and at least I got the thing (Commerce module) installed. But now get 'SQL Server does not exist or access denied' when I try to run the thing.

Has anyone solved this issue? How?
Help....

Re: MDSE Problem with Commerce Starter Kit Install

mwalsh — Thu, 09 Oct 2003 20:12:35 GMT

If you then install IIS after having installed .NET you will need to do the following otherwise you will see the sourcecode in your browser rather than the application running:

At the command prompt type:

cd c:\windows\microsoft.net\framework\v1.1.4322
aspnet_regiis -i

Hope that helps

Re: MDSE Problem with Commerce Starter Kit Install

mwalsh — Thu, 09 Oct 2003 19:21:54 GMT

Are you sure you have IIS installed?
Go to Control Panel > Add or remove programs
Click on Add/Remove Windows Components and place a tick next to IIS if there isn't already one there.

Now, on to my problem, hopefully this is an easy one?
I've installed CommerceVBSDK no problem and a virtual directory has been set-up but when I point my browser to it I see the source code rather than the app running?
Any help would be much appreciated.

Re: MDSE Problem with Commerce Starter Kit Install

eliahoo2 — Wed, 08 Oct 2003 15:44:52 GMT

I dont have a SQLAgent$InstanceName service.

I was able to install the community starter kit, but it is configured to allow me to chose the name of my data base server which for some reason is the name of my computer which iis must have addopted by defaut. this name shows up in the sql service manager.

localhost is the address of the iss help files

When the commerce package tries to install the drop down menu shows localhost only not the server name that the sql service manager shows. The IBuySpy commerce package returned the following:
7:33:03 AM Wednesday, October 08, 2003: [Checking system requirements]
7:33:03 AM Wednesday, October 08, 2003: [Pass] Detected a local instance of SQL Server.
7:33:03 AM Wednesday, October 08, 2003: [Pass] Determined SQL Server version (8.00.194).
7:33:03 AM Wednesday, October 08, 2003: [Pass] Detected .NET Framework.
7:33:03 AM Wednesday, October 08, 2003: [Pass] Detected Internet Information Server (IIS).
7:33:19 AM Wednesday, October 08, 2003: [Begin Sample Configuration]
7:33:20 AM Wednesday, October 08, 2003: [Pass] Created IIS virtual directory.: StoreVB
7:33:20 AM Wednesday, October 08, 2003: [Pass] Determined SQL Server version (8.00.194).
7:33:36 AM Wednesday, October 08, 2003: [Fail] Could not add ASPNET user to SQL Server.
SQL Server does not exist or access denied.
7:33:36 AM Wednesday, October 08, 2003: [Done]

so it seems to be an access problem:

I have tried several configurations of MSDE at this time there is no instance name or securitymode just a password.

the community kit is working and the ASP.Net web matrix shows the server to be working.

any ideas?

I either have to find a way to change the name of the

Re: MDSE Problem with Commerce Starter Kit Install

dutchess — Thu, 11 Sep 2003 19:39:39 GMT

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.

Re: MDSE Problem with Commerce Starter Kit Install

stone_za — Mon, 25 Aug 2003 21:14:43 GMT

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

Re: MDSE Problem with Commerce Starter Kit Install

WalkToFreedom — Mon, 28 Jul 2003 06:32:25 GMT

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?

Re: MDSE Problem with Commerce Starter Kit Install

msbcgsch — Sat, 26 Jul 2003 03:27:30 GMT

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

Re: MDSE Problem with Commerce Starter Kit Install

WalkToFreedom — Sat, 26 Jul 2003 01:15:10 GMT

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

Re: MDSE Problem with Commerce Starter Kit Install

msbcgsch — Thu, 10 Jul 2003 18:18:39 GMT

Calumn

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

Thank you very much.

Mark

Re: MDSE Problem with Commerce Starter Kit Install

Calumn — Wed, 09 Jul 2003 08:34:12 GMT

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

Re: MDSE Problem with Commerce Starter Kit Install

Calumn — Tue, 08 Jul 2003 22:20:08 GMT

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

Re: MDSE Problem with Commerce Starter Kit Install

Calumn — Tue, 08 Jul 2003 17:10:30 GMT

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

Calumn

Re: MDSE Problem with Commerce Starter Kit Install

manolo13 — Tue, 08 Jul 2003 10:29:06 GMT

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

Re: MDSE Problem with Commerce Starter Kit Install

msbcgsch — Tue, 01 Jul 2003 07:50:11 GMT

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?