Creating Azure Website & Database

Modified on Thu, 15 Apr 2021 at 09:29 AM

Transmille's recommended deployment of ProWeb V6 utilises Microsoft Azure (https://azure.microsoft.com/en-gb/) to host the ProWeb database as well as website.


To configure an Azure account and set up the database/website please follow the below instructions. Alternatively, Transmille offers a deployment service for ProWeb to your Azure account without any configuration steps.


1) Sign up for an Azure Account - Follow the steps at the Azure website : https://azure.microsoft.com/en-gb/ (Please note that as Azure is a service not offered by Transmille the process for signing up for an account is outside of our control).


2) After configuring and signing in to your account, visit the Azure portal (https://portal.azure.com).



3) Click on the 'Create a resource' button in the top left.



4) In the Resource Window, click on 'Web + Mobile, then click 'View All'. Select 'Web App + SQL' from the list.



5) On the right-hand side of the screen, a summary of the service will appear. Click the 'Create' button at the bottom of this new window.



6) Enter an 'App Name'. This will be the internal name for your Web Portal. For example, CompanyXYZProWeb will be accessible at http://companyxyzproweb.azurewebsites.net. Select your subscription and ensure that 'Resource Group' is selected as New to keep ProWeb separate from any other services your company may use. At this time you can select an App Service plan and Location. For further information on App Service Plans and pricing please refer to https://azure.microsoft.com/en-gb/pricing/details/app-service/. Transmille advises that plans D1, B1 or B3 will be perfectly sufficient for most small to medium calibration laboratories.



7) Click on the SQL Database (This may be highlighted with a Red Exclamation Mark as in the above image) to start configuration of the SQL database.


8) Select 'Create a new database'.


9) Call the new database 'ProWeb' and then click on 'Target Server'. Create a unique name and address for your database i.e. 'CompanyXYZProWeb'. This database will be accessible in SQL Server Management Studio at companyxyzproweb.database.windows.net/ProWeb.


10) Create a unique administrator login Username and Password (do NOT use the login name Admin and ensure that your password is secure). Select a location from the Drop Down box that is closest to the majority of your customers.


11) Press the rightmost select button. From the 'Pricing Tier' selection on the SQL Database column make sure that a suitable pricing is selected. Transmille recommend that for small companies the Basic database with 2GB of storage will be plenty, but larger companies will require the Standard tier with larger databases. Note - This can be upgraded in the future as more users use your ProWeb service.



12) Click select at the bottom of the SQL Database column. Your new database will now be created and automatically selected.


13) Click the 'Create' button at the bottom of the Web App + SQL Column.



14) The Azure portal will display a message stating that deployment has started. This indicates that your Azure Service is now being started. You can see this notification by pressing the Bell icon in the top bar of the Azure Portal. Depending on the state of the Azure Service this process can take upwards of 10 minutes, however, will typically take less than 1 minute.


15) Your Azure service will now be accessible via the Resource Groups Selection.



16) Select your newly created ProWeb resource by clicking on its name.

17) Within the ProWeb resource you will see the following :


        SQL Server

        App Service

        SQL Database

        App Service Plan



18) In this next step we will configure the SQL Server to accept connections from your local server (i.e. the server that is within your premises / your workstations look to for data) for upload of data to the ProWeb Service.

19) Click the SQL Server (in the example image identified as companyxyzproweb)  to open the SQL Server configuration menu.

20) Click the 'Firewall / Virtual Networks' link.


21) On the Firewall / Virtual Networks tab, ensure that 'Allow access to Azure services' is in the ON position, and click the button labelled 'Add client IP', followed by clicking on the save button (The Save button will become available after clicking add client IP). NOTE - This makes the assumption that you are connecting from the site/location you will be uploading data from. If you do not have a fixed IP address you will need to update this rule each time your external IP address changes.


22) You can now test your connection to the SQL Server using Microsoft SQL Server Studio as below : 

23) Click the Properties tab in the SQL Server settings in Azure and copy the Server Name (in this example companyxyzproweb.database.windows.net) into the Server Name box in the connection window of SQL Server Studio. Use the Server Admin Login and the password that was configured earlier and click connect.



24) If the Firewall settings have been configured correctly you will successfully connect to the SQL Server.

25) To upload files to the ProWeb server you must configure FTP settings. To do this click back until you return to the resource group for the ProWeb Service, and then select the App Service.

26) Click on the 'Deployment Credentials' option in the sidebar and enter an FTP/deployment username and password as indicated. After configuring click the Save button. You will see these details for the ProWeb desktop utility.

27) At this stage contact Transmille who will deploy ProWeb to your server on your behalf.

28) To configure the website and ProWeb desktop application, refer to the other solutions in this folder.


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article