Database Configuration
Introduction
The Database Configuration page is a mandatory step in the initial setup of the AI Command Center. It is displayed only once, during the first-time launch of the AI Command Center, and is used to configure the primary Database required for system operation.
The AI Command Center uses this Database to store:
- Configuration data
- Tenants
- Users and roles
- Process definitions
- Runtime state, logs, and audit information
⚠️ Once the configuration is completed successfully, these settings cannot be modified through the UI. Any future change requires manual intervention at the Database or deployment level.
Supported Databases & Authentication Modes
The AI Command Center supports Microsoft SQL Server and PostgreSQL, with authentication options varying by hosting platform.
| Database | Hosting Platform | Supported Authentication Modes |
|---|---|---|
| Microsoft SQL Server | Windows | SQL Server Authentication, Windows Authentication |
| Microsoft SQL Server | Linux | SQL Server Authentication only |
| PostgreSQL | Windows | Username & Password |
| PostgreSQL | Linux | Username & Password |
Important Notes
- Windows Authentication is supported only for SQL Server running on Windows
- Linux deployments support password-based authentication only
- PostgreSQL does not support Windows Authentication
Configuration Fields
The fields displayed during setup depend on the selected Database Type, Platform, and Authentication Mode.
Microsoft SQL Server (Windows)
Authentication Type: SQL Server Authentication
| Field | Description |
|---|---|
| Server Name | Hostname or network address of the SQL Server instance |
| Database Name | Name of the Database to be used by AI Command Center |
| Authentication Type | SQL Server Authentication |
| User Name | SQL login name |
| Password | Password for the SQL login |
| Encryption Key | Key used to encrypt sensitive data stored by the system |
Authentication Type: Windows Authentication
| Field | Description |
|---|---|
| Server Name | Hostname or network address of the SQL Server instance |
| Database Name | Name of the Database to be used |
| Authentication Type | Windows Authentication |
| Encryption Key | Key used to encrypt sensitive data |
🔹 In this mode, the AI Command Center connects to SQL Server using the IIS Application Pool identity.
Microsoft SQL Server (Linux)
Only SQL Server Authentication is supported.
| Field | Description |
|---|---|
| Server Name | SQL Server host |
| Database Name | Database name |
| User Name | SQL login |
| Password | SQL login password |
| Encryption Key | Encryption key |
PostgreSQL Server (Windows & Linux)
PostgreSQL uses username/password authentication only.
| Field | Description |
|---|---|
| Host | PostgreSQL server hostname or IP address |
| Port | PostgreSQL port (default: 5432) |
| Database Name | Database name |
| User Name | PostgreSQL login |
| Password | Login password |
| Encryption Key | Encryption key |
Validating the Configuration
Before proceeding, you must validate the database connection.
- Click Validate to test the connection
- Validation checks: - Server reachability - Authentication credentials - Database access permissions
Database Creation Rules
- If the database does not exist: - The configured user must have the Create Database permission
- If the database already exists: - Administrative privileges are not required
On successful validation, click Next to continue setup.
SQL Server Login Setup (SSMS)
A. SQL Server Authentication (sysadmin)
Use this option when the Database does not exist and must be created automatically.
- Open SQL Server Management Studio (SSMS)
- Connect using an administrator account
- Navigate to Security → Logins → New Login
- Select SQL Server authentication
- Enter: - Login name - Password
- (Recommended) Disable Enforce password policy for service accounts
- Go to Server Roles
- Select sysadmin
- Click OK
B. Windows Authentication (sysadmin)
This option applies only to SQL Server on Windows.
- Identify the IIS Application Pool name used by AI Command Center (default example):
IIS APPPOOL\AI Command Center
- Open SQL Server Management Studio (SSMS)
- Navigate to Security → Logins → New Login
- Select Windows authentication
- Enter the Application Pool identity exactly as shown above
- Go to Server Roles
- Select sysadmin
- Click OK
PostgreSQL Login Setup (pgAdmin)
Create Login with Database Creation Permission
- Open pgAdmin
- Connect as a superuser (for example,
postgres) - Navigate to Login/Group Roles → Create → Login/Group Role
- Set:
- Name
- Can login? → Yes
- Go to Privileges
- Enable Can create databases
- (Optional) Enable Superuser if full administrative access is required
- Set the password under Definition
- Click Save
Platform-Specific Considerations
- Windows Authentication works only with:
- Microsoft SQL Server
- Windows-hosted AI Command Center
- Linux deployments support password-based authentication only
- Existing databases can be reused without sysadmin privileges
- The Encryption Key is critical and must be securely preserved
⚠️ Losing the Encryption Key may result in:
- Inability to decrypt stored credentials
- Failed upgrades or reinstallation
Upgrade Notes
- Upgrading from Control Room 7.3.x to AI Command Center is supported
- If using a custom IIS Application Pool account:
- Ensure password changes are updated in IIS
- Otherwise, a Service Unavailable error may occur
Official References
Microsoft SQL Server
- Installation (Windows): https://learn.microsoft.com/sql/database-engine/install-windows/install-sql-server
- SQL Server on Linux: https://learn.microsoft.com/sql/linux/sql-server-linux-setup
- Authentication Modes: https://learn.microsoft.com/sql/relational-databases/security/choose-an-authentication-mode
PostgreSQL
- Installation: https://www.postgresql.org/docs/current/installation.html
- pgAdmin: https://www.pgadmin.org/docs/
- Role & Privilege Management: https://www.postgresql.org/docs/current/user-manag.html