How do I create an SQL Azure database to be used for BitTitan Audit Logging?

 

This is a two-step process:

  1. Create SQL Database
  2. Configure Firewall Settings

 

1. Create SQL Database

  1. Follow the Microsoft guide on creating a SQL database: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-single-database-get-started?tabs=azure-portal
  2. Note: Under the Pricing tier field, select the pricing tier you require.  (Recommended setting is Standard S3: 100 DTU, 250GB.)

Note: You may need to log out and log in again before your new SQL Database will show in your portal.

 

2. Configure Firewall Settings

  1. Select the Resource Group that you created the SQL database server in.
  2. Click on Overview.
  3. Click on the SQL database AuditEventLog, then click on Set Server Firewall at the top of the screen.
  4. Add the following IP address information
    • Under Rule name, enter ALL
    • Under Start IP address, enter 1.1.1.1
    • Under End IP address, enter: 255.255.255.255
  5. Make sure that Allow access to Azure services is set to ON.

 

Note: This is a required configuration since, by default, no one has access.

You are now ready to enable audit logging within your MigrationWiz project.

Refer to What is the BitTitan Audit Logging Service and what parameters need to be set? for more information on how to enable audit logging within your MigrationWiz project Advanced Options. 

Was this article helpful?
0 out of 1 found this helpful