Connect to an Existing Farm Database

You can use the Connect to existing database dialog box to connect to the existing Farm. You can select the Connection String or Connection provider for the new database.

1. Select the computer name on which the Farm Database is installed from the Server Name field.

2. Select Connection String.

3. Enter the following details:

   1. Authentication Type: This field is used to provide information on the process used to validate a user. AVEVA Work Tasks solution supports both Windows and SQL server authentication process. Example: Windows.
      

   2. User ID: This field is used to enter the SQL user ID for SQL Server type of authentication. For Windows Authentication, this field appears disabled.
      

   3. Password: This field is used to enter the SQL password for SQL Server type of authentication. For Windows Authentication, this field appears disabled.
      

   4. Advanced Settings: This is an optional field. It is used to enter any additional connection information such as connection Timeout etc. Example: Connection Timeout = 20.

      While creating a data source for repository, use the following custom settings to set properties for the connection pool.

      encrypt=true; enableltm=true; connectionretrywaittime=30; maxconnectionretries=10; sqlcommandtimeout=300;

      encrypt: Ensures secure communication between AVEVA Work Tasks Server and SQL Server when a certificate is installed on the SQL Server for SSL encryption.
      

      enableltm: AVEVA Work Tasks internally implements the light weight transaction mode by reusing the connection which is already open within the same transaction. With this implementation a connection which is used from a transaction is returned back to the connection pool only when the transaction is completed. Since the same connection is used within the transaction, the transaction becoming distributed is reduced to a great extent. With this feature AVEVA Work Tasks controls the transaction from escalating to a distributed transaction which is very expensive.

      The above property can be used to turn off this feature. The default value is set as True.

      connectionretrywaittime: While opening a new connection, if the database server is not available, the default behavior is to retry for the connection. This setting can be used to set the wait time for retry for a new connection. The default value is set as 30 Seconds. The value should be set in seconds.

      maxconnectionretries: While opening a new connection, if the database server is not available, the default behavior is set to retry for a new connection. This setting can be used to set the retry count. The default value is set infinite.

      sqlcommandtimeout: Sets the wait time before terminating the attempt to execute a SQL command and generating an error. The default value is set as 300.

      Note: These settings are case sensitive and should be mentioned only in lower case.

   5. Database: This field is used to select the machine with database installed. Example: FarmDB.

      AVEVA Work Tasks will validate if at least one server is installed.

4. Click Test Connection to ensure database connectivity.

   You must have the following permissions on the Database Server:

   SELECT, INSERT, UPDATE, and DELETE permissions.

   EXECUTE permission for Stored Procedures.

5. Click Next to continue with the wizard.

6. Click OK.