Search code examples
sql-serverazurefirewallnopcommerce

nopCommerce: Database does not exist or you don't have permission to connect to it

While trying to install nopCommerce in Azure, I get the following error: Database does not exist or you don't have permissions to connect to it. :(

Problem

The process I've been through was quite straightforward:

  1. Get nopCommerce
  2. Give a name to the app
  3. Create the Resource Group
  4. Define the App Service plan / Location
  5. Create a SQL server
  6. Create a DB
  7. Create a SQL Admin user
  8. Allow connections from my IP to all the databases in the DB server in the SQL Server Firewall

The problem is quite explanatory but I can't seem to fix it.

This link tells the process one needs to go through in order to troubleshoot.

What shall I do?

Solution

  • Fixed it by selecting "Enter raw connection string".

    In order to get that string, inside of the Azure Portal, went to Connection Strings and got it from there adjusting to the message prompt while selection the raw connection string option.

    enter image description here