XIA Configuration Server

Automated SQL Database Documentation and Security Auditing Tool

XIA Configuration automatically documents SQL Server and Azure SQL databases, capturing schema, security, permissions, configuration settings, and relationships across your environment. The tool generates audit‑ready reports, highlights misconfigurations, and tracks changes over time.

Start your free trialView example document
An icon that represents a SQL database audit.

SQL Database Automated Documentation Tool

Using XIA Configuration's powerful IT infrastructure documentation features you can create professional branded documentation without friction.

This documentation is essential for business continuity, disaster recovery and technical handovers.

View sample document.

Cover page of SQL Database Documentation.

Compare SQL Server  and Azure SQL Databases

Using XIA Configuration's powerful configuration comparison feature you can:

  • Detect and prevent unauthorized modifications or configuration drift for your SQL Server and Azure SQL databases.
  • Ensure consistent configuration by comparing settings across development, test, and production environments.
  • Compare different databases for differences.
Screenshot of a SQL Server instance configuration comparison component selection.
XIA Configuration allows you to select what components to compare.
Screenshot of a SQL Server database configuration comparison.
XIA Configuration automatically detects differences between SQL Server and Azure SQL databases including the configuration of the database and the database schema.

SQL database settings documented by XIA Configuration

XIA Configuration supports the following SQL database settings and information:

  • Database Creation Script
  • Database Automatic Options
  • Database Containment Options
  • Database Cursor Options
  • Database Scoped Configuration Options
  • Database FILESTREAM Options
  • Database Miscellaneous Options
  • Database Recovery Options
  • Database Service Broker Options
  • Database Maintenance Options
  • Database State Information
  • File Groups
  • Files
  • Tables
  • Column Definitions
  • Foreign Keys
  • Views
  • Stored Procedures
  • User Defined Functions
  • Triggers
  • Assemblies

View a sample document showing this information.

SQL Server Support

In addition to database‑level documentation and reporting, XIA Configuration also documents full SQL Server instances, including configuration, logins, roles, jobs, and availability groups.

For more information, see our page on SQL Server instance documentation.

The Microsoft SQL Server logo.

Microsoft SQL Server and Azure SQL Database documentation FAQ

Here are answers to the most common questions about documenting Microsoft SQL Server and Azure SQL Databases with XIA Configuration.

Does XIA Configuration need an agent installed on the SQL Server?

No. XIA Configuration is a completely agentless SQL documentation tool. It uses SQL Management Objects (SMO) for server data and PowerShell remoting for host information, ensuring no software footprint is left on your production SQL Servers. For Azure SQL only SQL Management Objects (SMO) access is required.

Why is Microsoft SQL Server and Azure SQL Database documentation important?

Documenting Microsoft SQL Server and Azure SQL Databases provides a clear record of your databases' structure, permissions, and configurations. This helps IT teams manage changes, troubleshoot issues, and ensure compliance with industry standards. Microsoft SQL Server and Azure SQL databases are core technologies that underpins other essential platforms and applications.

How does this software help with security audits?

The software automates the collection of SQL logins, database users, and object permissions. By providing a snapshot of your security state, including surface area configurations and encryption settings, it helps IT teams to quickly prepare evidence to help demonstrate compliance during formal audits.

Can XIA Configuration document multiple Microsoft SQL Databases?

Yes. XIA Configuration supports documenting all databases on a given Microsoft SQL Server or Azure SQL Logical Server, giving administrators a unified view across complex environments.

Can I automate Microsoft SQL Server and Azure SQL database documentation updates?

Yes. You can schedule recurring scans to automatically capture changes and keep documentation current. Each run maintains version history, so you can track changes over time without manual effort.

What export formats are available for Microsoft SQL Server and Azure SQL database documentation?

Documentation can be exported to both PDF and Microsoft Word formats, making it easy to share, review, and include in audit packs or compliance reports.

Does XIA Configuration modify my SQL Servers or databases?

No. XIA Configuration performs a read‑only scan using SMO (and optionally PowerShell remoting for gather host information for on-premises SQL Server). No changes are made to the target system and is safe for production.