How i need to install dashcommerce on a web server using a sqlexpress database on my local server?

I've installed it on a lan and it works fine. But when i use a web server and the sqlserver on my lan i receive allways the error 40 (Named pipes provider error ).

Firewall=ok; Windows and sql authentication=ok; tcp/ip connection only=ok; port 1433 open=ok; user and password=ok; connection string=ok.

Where is the bug?

Can i install dashcommerce csk2 on WebHost4life? If yes how?

If you are getting the named pipes provider error, you have a configuration issue, which is unrelated to the Commerce Site install.

CSK2 installs and runs on WH4L, although they don't have the installer built into their list of applications (they only have CSK1). To get it running, set up your default application / domain, running under ASP.NET 2.0, make sure NETWORK SERVICE has Read/Write/Modify, and all of your typical setup for any site. Make sure your blank database is created (you should have to create a user which will be db_owner), and you have your username/password on hand for your account). Finally, FTP the unzipped commerce site to your WH4L site (contents of Commerce.Web should be uploaded into site1).

Pull up your site in a browser, and if your site is properly configured, you should be redirected to the commerce site install screen, where you'll enter your SQL username, password, and database server, select the database, and continue with the install. The install will run install scripts in the database (so your database permissions need to be correct) and modify your web.config (so your file permissions need to be correct).

Ok. Thank you, Great!

Now i have found another trouble.

I've created a database named csk, but i can not execute the query to create tables on this db (why it's not possible?)

Executing one of thats from query analyser i get the error 2147217900 Incorrect syntax near GO.

In the install process step 3 of 6, without tables, i get the error "Incorrect syntax near '0x0a0d'"

Help me, please.

Why are you running these manually, when the install process (in v2) runs them for you?

Because it not works. I allways get the same error of previous local setup. To solve it i had to run sql files manually first.

I'm having problems installing on WebHost4Life.com, too! 

I deleted and recreated the database (same name and credentials). I deleted the files/folders, re-downloaded from dashcommerce, re-uploaded to a new folder (Commerce.Web). I then set this as a .net2.0 application, gave Network Service full permission to the web.config, cleared by browser cache, and navigated to  the Install/Install.aspx page.

I get to step 2 of 6, fill in sql389.mysite4now.com for my database server, uncheck "use trusted connection", and supply the username and password. Click Next. On step 3 I pick my database from the drop-down list, check the "drop objects" box, and click Next, and get "Incorrect syntax near '0x0a0d'."

Anyone have any ideas?

 - www.JoeLevi.com 

The steps you take seem to be correct. However, I've always had success by (1) giving Network Service Read/Write/Modify to all files and subfolders, not just the web.config, and (2) not dropping objects (if you have an empty database, you don't need to drop anything).

Then again, you can manually run the SQL scripts, to see if/where you get any errors, then manually update the web.config.

I have found the same problem. When i have asked the solution to w4l the helpdesk answered me that with 30$ they could install the kit for me!!!!!

At last, I've installed the kit. After getting the "incorrect sintax near..." i've executed the sql file manually and it works. But in the login i've found another trouble:

The 'System.Web.Security.SqlMembershipProvider' requires a database schema compatible with schema version '1'.  However, the current database schema is not compatible with this version.  You may need to either install a compatible schema with aspnet_regsql.exe (available in the framework installation directory), or upgrade the provider to a newer version.

Why don't you do what it says run C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql.exe

or

You could also try running MembershipSchema.sql  and  BaseMembershipData.sql  from the Install\InstallScripts directory from dashCommerce

Thank you very much.

Finally my e-commerce site is entirely working.

Last help, please: what's user id and password for admin?

admin:admin (by default)

Why when i try to access the admin login i'm redirect to the login page?

So you've logged in as admin, you see the Admin tab, and when you click that, you are taken back to the login page?

I try to access.../admin/default.aspx and i'm redirect to .../login.aspx