XIA Configuration

Azure SQL Server Documentation Tool

Automatically document your Azure SQL servers

Use our Azure SQL server documentation tool XIA Configuration to automatically document your Azure SQL servers.

For detailed documentation of SQL servers, see the SQL page.
Screenshot of Azure SQL servers in the XIA Configuration web interface
Automatically document Azure SQL servers

Information documented by XIA Configuration

Find out more about the Azure SQL server configuration documented by XIA Configuration below:

To see all the Azure settings documented by XIA Configuration, navigate up to Azure

General Settings

View and document general SQL server settings.

Show details
  • Resource Type
  • Resource Group Name
  • Subscription Name
  • Subscription Identifier
A SQL Server is a logical construct that acts as a central administrative point for a collection of Azure SQL databases.
Screenshot of Azure SQL server general settings in a document generated by XIA Configuration
View Azure SQL server general settings in a document generated by XIA Configuration

Location

View and document the location of the SQL server.

Show details
  • Location Display Name
  • Location Map

Server

View and document server configuration.

Show details
  • Fully Qualified Domain Name
  • Server Version
Screenshot of Azure SQL server settings in the XIA Configuration web interface
Automatically document Azure SQL server settings

Authentication Settings

View and document authentication settings.

Show details
  • Active Directory Administrator
  • Require Azure Active Directory Authentication
  • SQL Administrator Login

Audit Policy

View and document if auditing is enabled on the SQL server.

Network

View and document network configuration.

Show details
  • Deny Public Network Access
  • Minimum TLS Version
  • Connection Policy
  • Allow Access to Azure Services

Outbound Network Access

View and document if outbound network access is restricted.

Screenshot of Azure SQL server outbound network access settings in a document generated by XIA Configuration
View Azure SQL server outbound network access settings in a document generated by XIA Configuration

Firewall Rules

View and document firewall rules.

Show details
  • Name
  • Start IP Address
  • End IP Address

Virtual Network Rules

View and document virtual network rules.

Show details
  • Name
  • Virtual Network Identifier
  • Virtual Network Name

Transparent Data Encryption

View and document transparent data encryption.

Show details
  • Key Type

Databases

View and document databases.

Show details
  • Name
  • Maximum Size
  • Backup Storage Redundancy
  • SKU

Failover Groups

View and document failover groups.

Show details
  • Name
  • Database Identifiers
  • Database Names
  • Grace Period
  • Partner Location
  • Partner Resource Group Name
  • Partner Server Name
  • Read/Write Failover Policy
  • Replication Role

Private Endpoint Connections

View and document private endpoint connections.

Show details
  • Name
  • Private Endpoint Name
  • Private Endpoint Identifier
  • Request/Response Message

Locks

View and document the locks added to the SQL server.

Show details
  • Name
  • Type
  • Scope
  • Scope Type

Role Assignments

View and document SQL server role assignments.

Show details
  • Account Name
  • Account Type
  • Role
  • Scope
Screenshot of Azure SQL server role assignments in the XIA Configuration web interface
Automatically document Azure SQL server role assignments

For more information about Azure, please view the Azure page.

Try our Azure SQL server documentation tool for free