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.
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 220.127.116.11 and the End IP to 255.255.255.255