installing nopCommerce on host4asp.net

Hi everyone I am currently trying to set up nopCommerce on a host4asp.net server and I am having some problems.

1 The first step I did as to unzip nopCommerce 4.10(no Source) into the root (httpdocs) file.

2 The second step Is after clicking preview site I am redirected to the nopCommerce install page where I input user and database information (Note that the database is a clean one).

3 I clicked install then all my problems start. . .

After clicking install I get this error :  

Setup failed: Cannot find the object "dbo.QueuedEmail" because it does not exist or you do not have permissions.

and If I do import a database that was created on my local machine by nopCommerce SQL scripts I get this error.

Setup failed: Sequence contains more than one element.

anyone else have this problem ?

Where is the database - on the host's server?  Can you use their control panel or SSMS to see if the database is there and the tables created?  (do you have permissions to create tables?)

(This may help  https://github.com/nopSolutions/nopCommerce/issues/3114)

Hi, I had the same problem. I installed nopCommerce 4.1 on a Host, where I had to create a Database and a Admin User for it (let's say, the Admin User Name was MyAdmin). But this user wasn't the db owner and when I created the tables and stored procedure in the nopCommerce initialization process, they were named like "MyAdmin.QueuedEmail"

This means, all was created in the Schema "MyAdmin". The hoster gave me enough rights to change the standard schema for my user to dbo and then the installation worked.

I changed the Schema in the DB with
USE yourDatabase;
ALTER USER [yourUser] WITH DEFAULT_SCHEMA = dbo;

@[email protected] thank you allot I have been struggling with this for some time I really appreciate it

[email protected] Thank you very mutch! Your sql request very helped )