Installation from Azure Web App Gallery fails with SQL script error

I just tried to install nopCommerce from the Azure Web App Gallery. It fails with the following message:


"An error occurred during execution of the database script. The error occurred between the following lines of the script: "1" and "14". The verbose log might have more information about the error. The command started with the following: "/*************************************************" Incorrect syntax near '-'. http://go.microsoft.com/fwlink/?LinkId=178587 Learn more at: http://go.microsoft.com/fwlink/?LinkId=221672#ERROR_SQL_EXECUTION_FAILURE. Learn more at: http://go.microsoft.com/fwlink/?LinkId=221672#ERROR_INSUFFICIENT_ACCESS_TO_ADMINISTRATIONCONFIG."


Anyone an idea of a work around? Thank you!

I've just tested it. The installation works fine on Azure (from gallery)

Thank you for testing. I'm glad it works for you. It certainly didn't in my Azure subscription. I deleted the database, the database server and the Web App and started all over. Same result.

As a workaround the following worked:

1. Set up a database server and a Web app in Azure

2. Downloaded the source code of nopCommerce and built the solution

3. Tested it locally, which worked just fine

4. From within Visual Studio published to the Web App I set up in step 1

Now we've got a running instance of nopCommerce on Azure. :-)

a.m. wrote:

when are you going to have version 3.60 available on Azure Apps Gallery?

nkagelaris wrote:
It already has been submitted to WPI. Now it all depends on Microsoft team and how much time they need to approve the new version

a.m. wrote:

How long does it take usually to approve a version? is it a matter of 2-3 days or it could take weeks or more?

Usually it takes a couple of weeks

a.m. wrote:

I just tried this twice today and it doesn't work.  Are there specifics that are important?  For example, can you use the free database option?

Could you please post the entire error text?

a.m. wrote:

It's exactly the same as the OP.