The manual installation steps are suitable for the shared hosting plans without remote desktop access to the server. We strongly recommend to use at least dedicated plan since you can tighten the most security settings including enabling important data encryption in database.
Prerequisites on your server machine:
1) Install Windows 2008 Server with IIS 7 enabled
2) Install Microsoft SQL Server 2008 or later
You could get the free version Microsoft SQL Server 2008 R2 SP1 Express Edition with Advanced Services. Please download either SQLEXPRADV_x64_ENU.exe for 64bit OS or SQLEXPRADV_x86_ENU.exe for 32bit OS. Make sure you install the all the features including Full-Text Search and Client Components.
3) Install Microsoft .NET Framework 3.5 SP1
4) Register WCF service on IIS
-
Open Command Prompt as “Administrator”.
-
Navigate to C:\Windows\Microsoft.NET\Framework\v3.0\Windows Communication Foundation.
-
Run this command "servicemodelreg -i".
Steps to prepare on your local machine:
1) Install Microsoft SQL Server 2008 or later to your local machine
2) Download the install package and unzip all files into a local directory on your local machine
If you are running on Vista or Windows 2008 server OS, make sure you open command window (right click) run as administrator to get enough permission for the following steps.
3) Go to "Install" sub-directory of the unzipped directory and run
InstDSC.exe <database server name> <database name> <database data file path>
<encryption key path> [<smtp email server>] [<system email address>]
For example,
InstDSC.exe .\SQLExpress dotshoppingcart c:\dbdata c:\key mail.yourserver.com system@yourdomain.com
If you have space in your path, please add double quotes around the path.
Steps to configure DotShoppingCart on your server:
4) Upload all the DotShoppingCart files from the local install directory up to your server via FTP or any other method.
5) Backup the database dotshoppingcart from your local SQL server, upload the backup file to your server and the restore it to the SQL server on your server. After database dotshoppingcart is restored, run the following SQL script via SQL client provided by your ISP.
alter database dotshoppingcart SET ENABLE_BROKER
6) Configure IIS and point the site or virtual directory to Web subdirectory. Use "Integrated" in the managed pipeline mode.
7) Grant the Modify permission of the file Web\DSC.config and sub folders web\App_Data, web\App_Themes, web\Files and web\Images to "NT AUTHORITY\NETWORK SERVICE" (assume your identity running app pool is "NT AUTHORITY\NETWORK SERVICE").
8) Upload the encryption key file DotshoppingcartMaster.key from your local machine (the path specified in the step 3) to a directory your server. Do not choose the directory within Web directory. Grant the read permission of DotshoppingcartMaster.key to "NT AUTHORITY\NETWORK SERVICE". Open up Web\web.config for edit. Search for "protectedKeyFilename" and update the path after it to the directory on your server.
9) Update connectionString in web\web.config to the appropriate value which is usually provided by your ISP. If the database login is not windows credential, you have to run the following SQL script to assign the database login to the correct roles. Please replace "Your database login" with your database login.
EXEC sp_addrolemember N'aspnet_Membership_FullAccess', N'Your database login'
EXEC sp_addrolemember N'aspnet_Membership_BasicAccess', N'aspnet_Membership_FullAccess'
EXEC sp_addrolemember N'aspnet_Membership_BasicAccess', N'Your database login'
EXEC sp_addrolemember N'aspnet_Membership_ReportingAccess', N'aspnet_Membership_FullAccess'
EXEC sp_addrolemember N'aspnet_Membership_ReportingAccess', N'Your database login'
EXEC sp_addrolemember N'aspnet_Profile_FullAccess', N'Your database login'
EXEC sp_addrolemember N'aspnet_Profile_BasicAccess', N'aspnet_Profile_FullAccess'
EXEC sp_addrolemember N'aspnet_Profile_BasicAccess', N'Your database login'
EXEC sp_addrolemember N'aspnet_Profile_ReportingAccess', N'aspnet_Profile_FullAccess'
EXEC sp_addrolemember N'aspnet_Profile_ReportingAccess', N'Your database login'
EXEC sp_addrolemember N'aspnet_Roles_FullAccess', N'Your database login'
EXEC sp_addrolemember N'aspnet_Roles_BasicAccess', N'aspnet_Roles_FullAccess'
EXEC sp_addrolemember N'aspnet_Roles_BasicAccess', N'Your database login'
EXEC sp_addrolemember N'aspnet_Roles_ReportingAccess', N'aspnet_Roles_FullAccess'
EXEC sp_addrolemember N'aspnet_Roles_ReportingAccess', N'Your database login'
EXEC sp_addrolemember N'aspnet_Personalization_FullAccess', N'Your database login'
EXEC sp_addrolemember N'aspnet_Personalization_BasicAccess', N'aspnet_Personalization_FullAccess'
EXEC sp_addrolemember N'aspnet_Personalization_BasicAccess', N'Your database login'
EXEC sp_addrolemember N'aspnet_Personalization_ReportingAccess', N'aspnet_Personalization_FullAccess'
EXEC sp_addrolemember N'aspnet_Personalization_ReportingAccess', N'Your database login'
EXEC sp_addrolemember N'aspnet_WebEvent_FullAccess', N'Your database login'
EXEC sp_addrolemember N'DSC_Public', N'Your database login'
EXEC sp_addrolemember N'Sql_Dependency_Starter', N'Your database login'
EXEC sp_addrolemember N'Sql_Dependency_Subscriber', N'Your database login'
10) Move OrderPipeline from Windows service into web application. Please refer to this entry.