Set up on Local Machine

[kwikstand]

Can anyone help me set up AC7 an my local machine for developement? I am using Vista Ultmate and have "turned on" IIS. I am also using Visual Web Developer 2005. I have set up a web site and copied the AC7 files to it. When I try to run Install/Default with VWD, I get a SQL Server error:

Server Error in '/AbleCommerceStore' Application.
--------------------------------------------------------------------------------

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[SqlException (0x80131904): An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)]
CommerceBuilder.Common.Token.get_Instance() +463
CommerceBuilder.Stores.AuditEventDataSource.CountForStore() +9
CommerceBuilder.Services.AbleCommerceHttpModule.Init(HttpApplication context) +230
System.Web.HttpApplication.InitModulesCommon() +66
System.Web.HttpApplication.InitInternal(HttpContext context, HttpApplicationState state, MethodInfo[] handlers) +1006
System.Web.HttpApplicationFactory.GetNormalApplicationInstance(HttpContext context) +259
System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext context) +114
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +350

--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.1434; ASP.NET Version:2.0.50727.1434


Do I need to change database settings within VWD, or the SQL Server Configuration Manager?

I have been trying this for hours & hours for several days. I find myself doing the same things over & over to no avail. (I think this is the definition of stupid)

Any help would be appreciated, I am tired of beating my head on the wall.

[mazhar]

Try by changing the Remote Connections option to use both the TCP/IP and named pipes. You will find this setting under SQL Server surface area configurations.

[jmestep]

kwickstand,
Don't feel bad. I was bit by the SQL remote connection thing. And there are plenty of times I'll work on a piece of code for hours, then come back the next day and go Duh, I forgot C# uses == instead of = in comparisons.

[kwikstand]

Thanks for the quick supply and the support

I didn't even know about the SQL Server 2005 Surface Area Configuration. I have been fiddeling with the settings in the SQL Server Configuration manager. At any rate, I found out that you have to set administrative privileges for SQL Server seperrately from Vista.

Any way I made the changes to remote connection to "Using both TCP/IP and named pipes" and I still get the same error.

I notice that after I try to view in Browser, the database connection is lost in VWD. I right click the AbleCommerce.mdf and modify connections. I click "Test Connection" and it works. I then try to view in browser and get the same Server Error as before.

[kwikstand]

Not only do I still get the SQL Server error, but I notice that in VWD desin view, at the bottom of the license agreement It says:




I have permissions set to Modify for all the users listed. Are there any other Users that I need to add?

Thanks,
Scott

[jmestep]

The installation instructions for Able tell what permissions you need.
Also, here is a link with my woes about installing on Vista:
viewtopic.php?f=42&t=8995&hilit=vista

[kwikstand]

Thanks. I already read the instructions and have made sure of the permission settings. Here is what my setings look like:



I tried running the permission test script, but this is the reult:

[jmestep]

Make sure you have done the other things in that post. Sometimes an error message doesn't apply to the specific error.

[BBHartley]

Your problem is the command line you are using for the installation.

The URL/Command Line must include the domain or IP address + Virtual Server name.

Your installation should look something like:

http://192.168.1.100/Web/default.aspx

Where 192.168.1.100 is your IP address and /Web is the virtual web server you have created. If you simply try to use the command: C:\AbleDirectory\default.aspx you will et the error you are currently getting regardless of your permissions.