Add a Connection String

You can add a connection string, also known as a database, to link to your site. Multiple strings can be added, but only one string can be marked active at a time.

  1. Log into your Cityworks site. See Log In for more information.
  2. Click Host Management.

IMPORTANT: This page is only viewable in 23 and 23.1. Starting at 23.2, any host management is done through the host application.

Two tabs appear: Main and Connection Strings. From the Main tab, you can restart the IIS. From the Connection Strings tab, you can add links to databases.

  1. Click New.

The Create Connection String panel opens.

  1. Select a Database Type, such as SQL server or Oracle server.
  2. Enter the Server site.
  3. Enter the Database name.
  4. Enter the username and password. Click the eye icon to make the password visible or not.
  5. Click Create.

TIP: You can also select the Advanced option and enter the Server, Database, User, and Password in a string instead of using the fields.