TFS4JIRA Self-Hosted | How to bulk change sync account password

Owned by Damian Kilkowski (Inactive) (Deactivated)
Last updated: Mar 28, 2023
2 min read

The below method works with TFS4JIRA Self-Hosted 9.0 or 9.7 or higher.

TFS4JIRA has a hidden functionality that allows advanced users to amend the sync account password for more than one profile in TFS4JIRA. To achieve this task access to the database is needed. This tutorial will focus on access to SQL CE database.

  1. Backup. Before we introduce any changes or corrections in the SQL CE database it is wise to back it up first.

    1. Stop TFS4JIRA application pool in IIS, by default it is called TFS4JIRA Sync App Pool

    2. Copy config.sdf file to a save location/fiolder (default location: C:\inetpub\wwwroot\tfs-jira-synchronizer\App_Data)

  2. Access database. All profiles visible in TFS4JIRA are stored in the config.sdf database. It is a SQL CE database. In order to access the database please use the tutorial link: How to access (view) SQL Server CE database file from TFS4JIRA Synchronizer

  3. Querying the database. Below you will see all the steps needed to prepare the database in order to populate profiles with new password.

    1. Set existing passwords to NULL -

    2. update SyncProfiles set CipheredTfsPassword = NULL, CipheredJiraPassword = NULL Where Name =''

    3. CipheredTfsPassword, CipheredJiraPassword - choose which password will be changed

    4. Where Name='' is optional where you can filter which profiles should be effected

  4. Entering a new password.

    1. The new password must be inserted in plain text in the following fields: TfsPassword, JiraPassowrd

    2. update SyncProfiles set TfsPassword = 'password in plain text', JiraPassword = 'password in plain text' Where Name =''

    3. Where Name='' is optional where you can filter which profiles should be effected

    4. TfsPassword, JiraPassword - choose which password will be changed

  5. Disconnect / close LINQpad or any other tool you use to connect to SQL CE database

  6. Start TFS4JIRA application pool in IIS, by default it is called TFS4JIRA Sync App Pool

  7. Login to TFS4JIRA configurator page (the first connection will be longer).

  8. Passwords are now corrected.