Configuring the Kingdom Link

If your Kingdom project is stored as an Access database, or you have attached your project to an SQL Server, you can connect your project database to Insight and begin linking items from your Kingdom database.

Microsoft SQL Kingdom projects in Auto SQL Server Express (SSE) mode need to be attached before you can link the projects in Insight (see Downloading and Installing SQL Server). Kingdom does this automatically, thus a project can be left open in Kingdom and then connected to Insight, or manually attached (see Manually Attaching Kingdom SQL Database).

Attaching in Insight

Attaching in Insight

To attach a Microsoft SQL Kingdom project, Advanced Database Settings need to be configured in Insight.

  1. Open the Links tab from Insight's Control Panel.
  2. Click Browse to select your Kingdom database file and click Open.
  3. Under the Kingdom Link Settings panel, expand the Advanced Database Settings sub-panel.
  4. At Select database, make sure that SQL Server is selected. Fill in the required fields as follows:
    • Host — localhost
    • Instance — DUGInsight
    • Authentication — Windows.
  5. Click Connect to attach and establish a link to the Kingdom project.

If not the connection is unsuccessful, refer to the following prerequisites/troubleshooting steps to help you get connected to an SQL database:

Connect Insight with Kingdom database

Connect Insight with Kingdom database
  1. Launch Insight.
  2. In the Control Panel, open the Links tab.
  3. Expand the Kingdom Link Settings panel.
  4. Click Browse to browse to the Kingdom project (.tks file) that you want to connect to.
  5. Insight will automatically detect the database type. If the automatic detection fails, you can change the database type in the Advanced Database Settings sub-panel.
    To configure the SQL Server settings, see     Downloading and Installing SQL Server.
  6. Once connection is established, the Manage Resources button will be enabled. Click this and the Manage Remote Resources window will be displayed.
  7. Alternatively, you can click the Add icon at the relevant tabs and select Add from Kingdom. This will open the Manage Remote Resources window as well.

Switching between SQL Server and Access databases

Switching between SQL Server and Access databases

If you have been working on sessions that are linked to Kingdom's Access database, these sessions will work fine and continue to reference to the Access database. However, you can switch to an SQL database.

  1. In the Control Panel, open the Links tab.
  2. Expand the Kingdom Link Settings panel, click Disconnect to disconnect the link.
  3. Expand the Advanced Database Settings sub-panel.
  4. At Select database, select SQL Server.
  5. Enter the fields similar to the Attaching in Insight method above.
  6. Click Connect to reconnect to the SQL database. Once you have successfully reconnected, you can save the session and Insight will connect to the SQL database in the future.

Note: If any of the items imported from the Access database have been deleted in the SQL database, these items will no longer be available.

To export an SQL database to Access, see Exporting SQL Database to Access.

Using SQL Server port number to connect

If there are more than one SQL servers running, enter the port number of the server that has the correct database in the Port field.

To find the correct port number:

  1. Open the SQL Server Configuration Manager.
  2. Expand the SQL Server Network Configuration settings and click the Protocols for DUGINSIGHT link.
  3. In the right panel, right click the TCP/IP protocol.
  4. Scroll down until the IPALL section (expand this if necessary by clicking the [-] icon).
  5. Copy the TCP Dynamic Ports number and add it to the Kingdom Link Settings > Advance Database Settings > SQL Server > Port field.
  6. Exit the SQL TCP/IP Properties window by clicking the Cancel button.