How to setup a connection to the MSSQL instance using Windows authentication

Owned by Damian Kilkowski (Inactive) (Deactivated)
Last updated: May 23, 2023
1 min read

To enable Windows Authentication to the MSSQL instance please follow below steps:

  1. Please amend the following entry in web.config file (default location: C:\inetpub\wwwroot\tfs-jira-synchronizer)

    1. from: <add name="SyncProfileContextExpressConnection" connectionString="Data Source=localhost\TFS4JIRA; Database=TFS4JIRA; User Id=TFS4JIRA_Synchronizer_User; Password=B$3K94ynVQf7aDm!; MultipleActiveResultSets=True" providerName="System.Data.SqlClient" />

    2. to: <add name="SyncProfileContextExpressConnection" connectionString="Data Source=localhost\TFS4JIRA; Initial Catalog=TFS4JIRA;Integrated Security=True; MultipleActiveResultSets=True" providerName="System.Data.SqlClient" />

  2. Add access for ApplicationPoolIdentity user to SQL Express database OR change the Identity of TFS4JIRA Sync App Pool user to the one with permissions to SQL Express database. To do the latter please follow below steps:

    1. Stop TFS4JIRA Sync App Pool application pool in IIS using IIS Manager (cmd: inetmgr)

    2. Go to Advanced Settings

    3. Click (…) next to Identity

    4. Choose Custom account

    5. Enter authorized (in SQL instance) user credentials and click OK

    6. Start TFS4JIRA Sync App Pool application pool

      Â