Set up connection between Targetprocess web application and its database | Targetprocess - Enterprise Agility Solution

Set up connection between Targetprocess web application and its database

Targetprocess web application establishes permanent connection with SQL server containing database. Parameters of this connection are saved within file named:


By default, this file is located in the following folder on the hosting server


The connection string is controlled by special XML property. The line with this property is starting with:

<property name="connection.connection_string">

Example of the connection string:

 <property name="connection.connection_string">Server=metelskySRV;initial catalog=TargetprocessDB;user=sa;password=sa;Language=English</property>

Connection string includes following parameters:

  • Server: an URL address of an active SQL server containing Targetprocess database;
  • Initial catalog: a name of Targetprocess database deployed on the SQL server;
  • User id and Password / Integrated Security: credentials used for Authentication when connection between web application and the database is established;
  • Language: local settings for SQL server and database schema.

Two modes of Authentication are supported.

More about connection string could be found at

Using Login and Password authentication mode

With this mode, you have to specify valid login and password to provide Targetprocess application with access to its database on the SQL server.

user id=sa;password=sa;

To include values that contain a semicolon, single-quote character, or double-quote character, the value must be enclosed in double quotation marks. If the value contains both a semicolon and a double-quote character, the value can be enclosed in single quotation marks. The single quotation mark is also useful if the value starts with a double-quote character.

Using Windows authentication mode

With this mode, login and password are not specified in the connection string explicitly.

Integrated Security=SSPI;

Targetprocess Image

Instead, the Identity of Targetprocess application pool settings in the IIS manager on the application hosting server is used for the connection to database in this case. You have to make sure that this Identity is provided with full control access to Targetprocess SQL database. On the screenshot above, Identity name is Network Service.

Plugins connection setup

When you modify settings or change access mode on the SQL server, please make sure that both main web application and each of standalone Plugins are still able to connect to Targetprocess database.

For plugins, database connection is configured in files:


For example, for Search plugin:


By default, value of connection.connection_string setting for every plugin should be equal to the one used for main web application.

Targetprocess Image

With Windows authentication mode used, the Identity of Log On As user selected for Plugin Service is used for the database connection. On the screenshot above, Identity name is Local System.

Services for all Plugins should be restarted after the change of connection string. Then the IIS server with Targetprocess web application should be restarted as well.

Troubleshooting connection issues

Should you have any difficulties with web application or SQL server setup, please contact your DB administrator, IT manager or Targetprocess Support Team.

Still have a question?

We're here to help! Just contact our friendly support team

Find out more about our APIs, Plugins, Mashups and custom extensions. Join our community of passionate users and even discuss directly with our developers.

Or contact
a sales representative

Get a live
product demo

Let one of our product specialists create your account
and shape Targetprocess for your company needs.