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