Changes to Enterprise Insights on-premise installations in version 11.23.X

The installation and upgrade process for self-hosted Enterprise Insights is changing with version 11.23. Read on to understand what's new and what steps you need to take.

Enterprise Insights 11.23 contains a reliability and flexibility update for the self-hosted installer. It introduces answer file support for repeatable deployments, comprehensive pre-flight validation, and expanded SQL Server connectivity options.

Benefits of the change

Installing and upgrading Enterprise Insights in self-hosted environments has historically required careful manual input and could surface errors late in the process. This release addresses that by:

• Catching problems before they start: credentials, version compatibility, and database readiness are all validated before any changes are made
• Enabling repeatable, unattended deployments: a new answer file lets you configure once and reuse across environments and upgrades
• Supporting more deployment topologies: remote SQL Server, non-default ports, and self-signed certificates now work without manual script modifications
• Making upgrades seamless: existing ETL jobs are detected and handled automatically, eliminating common upgrade errors

All changes are fully backward compatible. Existing installations using default settings will continue to work without modification.

What's included

Answer file for unattended deployments

You can now pre-configure all installer inputs in a single answer file and run installations without interactive prompts. A documented template (Install.Answers.psd1) is included in the installer package, organized into clear sections (Data Warehouse, SSIS Catalog, SQL Admin, ETL Job, and Jira Align connection) with inline comments explaining each setting.

Key benefits:

• Eliminate manual entry: no more typing 15+ values at each install or upgrade
• Reduce errors: pre-validated configuration catches typos and missing values before deployment starts
• Enable automation: fully scriptable for CI/CD pipelines and scheduled upgrades
• Document your environment: the answer file serves as a living record of your deployment configuration
• Hybrid mode: leave any value blank to be prompted interactively; pre-fill the rest

To get started, copy the included template, fill in your environment values, and pass it to the installer. For fully unattended operation, add the -Force flag to skip confirmation prompts while retaining all safety checks. See the Self-Hosted Enterprise Insights Guide for detailed instructions.

Security: Answer files containing credentials should be stored securely and excluded from source control. See the template comments for guidance.

Pre-flight validation

The installer now performs a comprehensive set of checks before making any changes to your environment:

• Credential verification: all database connections are tested up front, so you will know immediately if a password or server name is wrong
• Version compatibility: Enterprise Insights and Jira Align versions are compared, with a warning on mismatch to prevent accidental misalignment
• Database readiness: active connections, open transactions, and database state are checked to prevent deployment failures
• Existing ETL job detection: if a job with the same name already exists, the installer shows its current status and safely handles the replacement

This means configuration problems surface immediately, not partway through a deployment.

Flexible SQL Server connectivity

The installer now supports a wider range of SQL Server deployment topologies:

• Remote SQL Server: Data Warehouse, SSIS catalog, and Jira Align databases can each be on separate servers
• Non-default ports: standard server,port format is now supported across all connections
• Self-signed certificates: a single configuration option enables certificate trust across all SQL connections, eliminating the need to manually edit the script

Additional improvements

• Smoother upgrades: upgrading with the same ETL job name now works seamlessly. The installer detects the existing job, displays its status, and handles the replacement automatically, including safely stopping a running job before deployment begins.
• Better error reporting: when an error occurs, the installer identifies which step failed, provides the specific error with resolution guidance, and reports which steps were not yet executed
• Schema deployment reliability: required deployment files are validated before starting, and failures are detected and reported immediately with log file references
• Updated branding: legacy product references updated to "Enterprise Insights" throughout the installer

Resolved issues

This release addresses several issues reported by customers and identified during testing:

• "MODIFY File Failed. Size is greater than MAXSIZE": the SSISDB file size configuration now checks current file sizes before applying limits, preventing errors when database files have grown beyond the original defaults
• "The specified job already exists" during upgrades: re-running the installer with the same ETL job name no longer fails. The existing job is detected and replaced safely.
• "The certificate chain was issued by an authority that is not trusted": self-signed certificate environments are now supported via a single configuration option, eliminating the need to manually edit the script
• Schema deployment failures not reported: the installer now validates deployment results and halts immediately with a clear error message and log file location if the schema update is unsuccessful
• Installer requires localhost SQL Server: the installer now supports remote SQL Server instances and non-default ports for all connections

Changes to installation and upgrade procedures

The installer package now includes the following files:

For new installations:

No special action required. Follow the Self-Hosted Enterprise Insights Guide included in the installer package. We recommend using the included answer file template for a streamlined experience.

For upgrades from a previous version:

1. Ensure both Install.ps1 and Install.Helpers.ps1 are present in your installer directory. Both files are now required.
2. Run the installer as before. All new settings default to previous behavior.
3. We recommend creating an answer file from the included template (Install.Answers.psd1) to simplify this and future upgrades.

System requirements are unchanged: PowerShell 5.1, Windows Server 2019 or later. Compatibility has been verified with SQL Server 2019.

If you have questions about this change or installing/upgrading Enterprise Insights on-premise, please contact Atlassian Support.