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
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>
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
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.
By default, value of
connection.connection_string setting for every plugin should be equal to the one used for main web application.
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
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.