MixERP not only supports multi-tenancy but also shared hosting environments. In this tutorial I will show you how to host MixERP with SQL Server in one of the most popular ASP.net hosting service providers-- Interserver.Hosting MixERP with Interserver
Because of their awesome support and blazingly fast servers, Interserver is regarded as one of the best and most affordable web hosting companies. Having been a professional web host for over 19 years, Interserver have been praised for their server quality, speed, and friendly support staff.Purchase Interserver ASP.net Hosting
Purchase any ASP.net web hosting plan that fits your need. Once your account is activated, log in to your Plesk control panel.
Download the file mixerp.interserver.net.zip. Extract it somewhere and you will see the following files:
Log in to your hosting control panel. On the dashboard, click "Databases" and then click "Add New Database".
Your database is now created but you still need to add a user for Reporting module. Create a user called "report_user" for read-only access. Click on "User Management" link on top-right corner of the page. Now click the button "Add Database User".
Select "MS SQL" from the dropdown list.
Now, click on the newly created user "report_user".
Now change the dropdown list "Role" to "Read Only" and click OK.
Click on "Databases" on your control panel dashboard and click "Import Dump" and upload the file "db.bak" you've downloaded and extracted earlier and press OK. Wait for this process to complete. Once this gets done, refresh the page. You will notice that now there are numerous tables in the database.
Before you upload the site, you need to delete the default landing site contents present in the "httpdocs" directory.
Click on "Files" on your control panel dashboard. Click on "httpdocs". Select all files by clicking on the checkbox on the table header on the first column and remove all files by pressing "Remove" button.
Once you've removed all files, click "Upload" button and point it to "site.zip" you've downloaded and extracted earlier.
Once the upload is complete, select the file "site.zip" and click "Extract Files" button. Put a tick mark on the option "Replace existing files" and press OK.
The files are now extracted to your website's root folder "httpdocs".
Click on the directory "Resources" with a "plural s" and then "Configs" and then "DomainsApproved.json".
Now edit the file "SQLServer.config" file similarly.
Navigate to the file manager and click on the directory "Tenants" on the root folder (httpdocs). Rename the existing directory to exactly match your database name.
You can check your site now. Open a browser window and point the url to your domain name. If you see errors, edit web.config file and add the following line inside <system.web> node.
<customErrors mode="Off" / >
This will enable you to troubleshoot errors and get the ball rolling.
On your MixERP website, click on the button "Admin Area".
Contact us if you need help. Cheers!