title: nopCommerce: Database does not exist or you don't have permission to connect to it
body: <p>While trying to <strong>install nopCommerce</strong> in Azure, I get the following error: Database does not exist or you don't have permissions to connect to it. :(</p>
  
  <p><a href="https://i.stack.imgur.com/QZBxD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QZBxD.png" alt="Problem"></a></p>
  
  <p><strong>The process</strong> I've been through was quite straightforward:</p>
  
  <ol>
  <li><a href="https://azuremarketplace.microsoft.com/en-us/marketplace/apps/nopCommerce.nopCommerce" rel="nofollow noreferrer">Get nopCommerce</a></li>
  <li>Give a name to the app</li>
  <li>Create the Resource Group</li>
  <li>Define the App Service plan / Location</li>
  <li>Create a SQL server</li>
  <li>Create a DB</li>
  <li>Create a SQL Admin user</li>
  <li>Allow connections from my IP to all the databases in the DB server in the SQL Server Firewall</li>
  </ol>
  
  <p>The problem is quite explanatory but I can't seem to fix it.</p>
  
  <p><a href="https://blogs.msdn.microsoft.com/sql_protocols/2008/04/30/steps-to-troubleshoot-sql-connectivity-issues/" rel="nofollow noreferrer">This link tells the process one needs to go through in order to troubleshoot</a>.</p>
  
  <p>What shall I do?</p>