Nopcommerce installation on plesk ERROR

Hello everyone,

I want to install nopcommerce on my hosting provider, have cpanel (plesk) installed on hosting.

On my hosting provider in plesk Cpanel I create a database with user.

I have download nopcommerce 4.20 source, run it on visual studio 2019, selected nop.web and click on IIS EXPRESS.

After that his open an webpage (localhost.../Install) and here I can ADD information.

I put : Admin user email - password - confirm password (yes)
        Create sample data (no)
        Use sq server database (yes)
        Create database if doesn't exist (no)
        Enter sql connection values (yes)
>>      Server name : (in my database on cpanel I have "Host name" I put this name here
>>      Database name : (In my database on cpanel I have "database name" I put this name here
        SQL Server name : Use SQL Server account (yes)
>>      SQL Username : (in my database on cpanel when I created my database, also username and paswword I put this
>>      SQL Password : Again password created with username when created a database on cpanel I put this here.



But When I Click on install (localhost.../install) on chrome browser I have this :
"Setup failed: An error occurred while creating the database: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"

Actually I retest it and it give me this message : Setup failed: Database does not exist or you don't have permissions to connect to it


I not understand if I need to do other things, it is my first website.

P@Ch_4 wrote:
Check Create database if doesn't exist

It's not clear if you were using Visual Studio on a separate development machine or on the cPanel server ?

If you are not planning to modify the code maybe you should use the no-source version

If you are using the source code version and want to customise the solution, normally you would build the website on your development machine and then and publish the website to your production (cPanel) server

Thank you for your messages,

I bought an hosting where I pay monthly, where Cpanel (plesk) are installed.

I have created a database (with user and password also) on my hosting provider with cpanel (plesk).

On my computer I run issexpress nop.web with visualstudio where it open Google Chrome. localhost../install
>> here I put the information required
But it give me an error message.

I use code source because I want to modifie theme after I can login on my website on admin..

The error message is saying that you do not have enough permission to access the database from your pc.

I follow all the required step, or maybe made a mistake..

On my hosting provider I made a database with permission also but doesnt work..

I found it is complicated when you are solo, and to understand why and where the error come from, or how to do..

I look at on YouTube :
https://youtu.be/L7NGodeB9sQ

And on the step where he open
> Microsoft sql management studio and create database,
> I dont open microsoft sql management studio but I open my cpanel on my hosting provider, and I create a database here.

I'm true ?

Yes install is not simple and often there are complications depending on the system and setup
I never had success with user and password combination
Normally I used Integrated Windows authentication
Maybe try that and let the install create the database
If there are still problems the install should tell you what it needs

It try with windows authentification with and without create a database if doesn't exist but
It say me :
you do not have permissions to connect..

I stop to try..

thank you for your help and your time

RE: "It try with windows authentication ...you do not have permissions to connect..
RE: "I don't open microsoft sql management studio but I open my cpanel ..."

You can't use windows auth if you are trying to connect from your local PC to your hosting's SQL server.
You must try to use a tool like SSMS from your local PC to verify if you can connect.  You need to get the server name (or IP address) from your hosting provider.  (And, that assumes that they allow you to access the SQL server remotely)