Azure SQL Database

This is a guide to help you configure Azure SQL database, configuration may differ between regions.

STEP 1. Select SQL Database from the menu of your Azure Dashboard

STEP 2. Add a new database

STEP 3. Create resources

Create a new resource group if required and provide a suitable name.
The database name should be set to ISMSRiskManager
Create a new server instance and enter the credentials.

TIP!

For Consultants and for app evaluation choose the cheapest SQL Database configuration.
Click “Configure database”

Select “looking for basic….”

Click apply to set you subscription to the lowest available.

Click through the Next buttons, all these settings can remain as default.

STEP 4. SQL Server Credentials

STEP 5. Create the database

Review and Create the database and wait until is initialised.

STEP 6. Gather the credentials

Return to the dashboard and select the ISMSRiskManager database.

The server name is displayed for later use with your user name and password.

STEP 7. Set the Azure firewall for your location

Click Set server firewall

The IP Address of your location is shown, copy paste this IP Address or your known IP Address range to the Start and End IP with a suitable reference.

If this is not configured, 27k1 ISMS will display a message to advise you.

STEP 8. Set the Azure firewall for any location

Although it is not good practice, Consultants may wish to access the app from any location.

  • Ensure a strong password is used to access your azure account and the SQL Database is also a very strong password.
  • Set the rule name as an example to Any Location
  • Set the Start IP to 1.1.1.1 and the End IP to 255.255.255.255
0 Comments

There are no comments yet

Leave a comment

Your email address will not be published. Required fields are marked *