Skip to end of banner
Go to start of banner

How to setup a connection to SQL database using Windows authentication

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

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

  • No labels