nopCommerce 3.2 Installation/Deployment Errors Explanation:

Hello,
for a last few day i am trying to install/deploy nopCommerce 3.2 project on hosting company web server and got installation errors.
After few attempts and no particular help from hosting company, maybe you would be able to explain what went wrong...

I was working on nopCommerce 3.2 locally (changed some styles, products) and deployed via FTP by VS2012.

All files uploaded, but i cannot install the project with SQL option:
(regular installation "Use build in data storage" works fine)

when i choose option Use SQL Server (or SQL Express) database [Recommende -> i get strange errors like:

error 1:

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server).

In cases when i trying to use Connection String installation and when i using "ENTER SQL CONNECTION VALUES".

There is existing DataBase that i using its connection string on installation process.
After talking to support service, they got no answer what maybe wrong.
Is there some configuration that hosting company should have, or i made some thing wrong on a process?


Thank you in advance for any help & direction.

Rigth now, can you access the database using SQL Server?

If you can, could you create the database nopcommerce store in your local machine and make a backup file(.bak) and restore it in your host.

Hey,

I can connect to DB that is on Hosting Web Server via SQL Management Studio.

I did what you proposed: restored existing DB on Web Server and still got installation page.

I tried to change connection details inside Settings.txt and got an error instead of regular installation page:

error that is not part of regular error.html that we got with the project:

Run Time Error:
"An exception occurred while processing your request. Additionally, another exception occurred while executing the custom error page for the first exception. The request has been terminated. "

Hi MaxLeb,

From the error message, it indicate you have entered wrong SQL server details. Could you please check it again? Can you login to your SQL server?

Hey,

Yes, i can connect to sql server of hosting company via Sql Server Management Studio.

What do you think?

Is there some thing incorrect with deployment process or hosting company configurations?

And another issue:

when i change connection string inside Setting.txt to connection of the Data Base, i get an error.

It happens in 2 cases: 1.when  i try to connect to DB
                                 2.when i try to use another *.sdf file (in case of Sql Compact installation that works fine)

Is the SQL Server on the same server as the web?  If so, try using localhost as the SQL Server name
Be sure to "Use SQL Server account" (not Windows integrated)

MaxLev wrote:
Hi!
Sorry ... if it is true, just try( for regular installation)  ..
Data Source=XXXXX;Initial Catalog=YYYYY;Integrated Security=True;Persist Security Info=False;MultipleActiveResultSets=True

where
XXXXX - your MS SQL server name(NOT localhost);
YYYYY - --"-- DB name

MaxLev wrote:

... when you try install nop, please do not touch Setting.txt :)

Best regards.

Hey all,

first of all thank you for your willingness to help, but that did work (yet).

I tried to do as you all said and still stuck in Installation screen....OMG...

Tried new approach:
1. I made small query-project to see if i able to connect to data-base server of hosting company from local machine, and
it was good, but when i tried to use this connection string inside web.config, there is no change: i still get installation screen.

2. I used the same connection string and tried to hard code connection string inside Nop.Data solution=>
worked well on a local machine database(connected to different data bases on local machine), but when i entered connection string of hosting database i got this runtime error:

"The provider did not return a ProviderManifestToken string." =>(VS2012 -> Inner Exception).


and when i try to create installation with connection string option i get this error:

A. Setup failed: Database does not exist or you don't have permissions to connect to it
B. Setup failed: An error occurred while updating the entries. See the inner exception for details.
C. Setup failed: An error occurred while creating the database: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. => I am using SQL CONNECTION VALUES!!!!

i think that i saw all available errors that could be.

If anybody would like to give a try, let me know...:)