I could use some help setting up the SQL database for the commercial version on my ISP's SQL Server 2005. The ISP gives me access to the server through a web interface that allows backup and restore and also through direct SQL Management Studio access. I've had the most luck in the past with creating a new database on the server and then restoring my local version to the new database through the web interface. I can't do this with DSC because a DSC backup contains three files; data, log, and full text search information. The web restore feature only allows two files; data and log.

I have not tried creating the database through Management Studio with the CreateDB.sql script. I guess I'm not sure exactly how do do that. Any help would be appreciated.

Linden

Try running CreateDB.sql directly via Management Studio. Before you can run CreateDB.sql directly you need to replace three viables, $(DatabaseName) to "dotshoppingcart",  $(PrimaryFilePhysicalName) to your db file and  $(PrimaryLogFilePhysicalName) to the log file.

Thanks for the reply. I don't seem to have rights to create a new database through Management Studio. I'll send the script to my ISP and see if they will run it for me.

Does $(DatabaseName) have to be "dotshoppingcart" or can it be something else like "myshoppingcart" ?

Linden

DatabaseName could be anything. Just make sure the connection string in your web.config has the same value.

BTW, running ecommerce on a shared environment is not a commended practice by PCI Compliance. You might want to run it on at least VPC which you have total control over. Data security is the most important thing as running business on internal.

Yes, I certainly agree that it is best to run on a VPC but unfortunately cost is often the most important thing in running a small business anywhere. The cost of a VPC is significantly more than a shared server. Thanks again for your help.

Linden