Downloading and Installing SQL Server Management Studio

If you have a manual project, or your database is not auto-attaching, try Manually Attaching Kingdom SQL Database. To do that, you will need to download and install Microsoft SQL Server Management Studio (SSMS), following the steps below.

Note: SQL Server Express has backward compatibility issues. Kingdom has updated its bundled version of SQL Server Express over the years. Once a Kingdom database has been opened in a more recent version of Kingdom, the database is no longer compatible with older versions of SQL Server Express. This can be resolved by upgrading your SQL version to match the current Kingdom version, per the guide below. If returning the original Kingdom project to your customer, make a copy of the Kingdom project before connecting to DUG-Insight. If you're unsure please contact support@dug.com.

Guide to Kingdom and SQL versions:

  • Kingdom 2026 requires SQL Server Express 2025 or SQL Server Express 2022
  • Kingdom 2025 requires SQL Server Express 2022 or SQL Server Express 2019
  • Kingdom 2023 requires SQL Server Express 2019
  • Kingdom 2022 requires SQL Server Express 2019 or SQL Server Express 2016 SP2
  • Kingdom 2021 requires SQL Server Express 2019, 2017, 2016, or 2014

Downloading and Installing SQL Server Management Studio

  1. Go to Microsoft's SQL Server Management Studio (SSMS) installation guide.
  2. Download and run the installer using Microsoft's instructions provided on the link above.
  1. Once installed, open SSMS and connect using Windows Authentication, with the Server name set to your computer name (or LOCALHOST) followed by the named instance, DUGInsight, that was set in the Instance Configuration step of Downloading and Installing SQL Server, e.g. LOCALHOST\DUGInsight.

Proceed to Manually Attaching Kingdom SQL Database to attach the Auto SSE Kingdom database manually.