How to set up Targetprocess web application connection to its database

Targetprocess web application establishes permanent connection with SQL server containing database. Parameters of this connection are saved within web.config file. By default, this file is located in c:/inetpub/wwwroot/TargetProcess2/wwwroot/ 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">.

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 https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring.aspx

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.

<property name="connection.connection_string">Server=.sqlexpress2k8r2;initial catalog=TargetProcess2;user id=sa;password=sa;Language=English</property>

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.

<property name="connection.connection_string">Server=.sqlexpress2k8r2;initial catalog=TargetProcess2;Integrated Security=SSPI;Language=English</property>

Application Pool Identity

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 at c:/inetpub/wwwroot/TargetProcess2/Plugins/_plugin_name_/PluginSettings.config file (e.g. ../TargetProcess2/Plugins/SubversionIntegration/PluginSettings.config).

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

Log On As user for Plugins

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.

Get started for free

How many people would be using Targetprocess?
  • Myself
  • 2–20
  • 21–100
  • 101–1000
  • 1000+
By clicking Continue you agree to our Terms of service and Privacy policy