Page Comparison

Solution:

In some cases, users are unable to access TFS (after a random interval) due to an SQL authentication error. 

A potential fix for this issue is to add in the SQL Authentication Credentials into the ODBC connection, and then trying to enter them again upon startup of TFS.

Open up your data sources, and then Data Sources (ODBC) 32-Bit (64 Bit OS),

Image Added

Then, configure the TFSMain ODBC connection.:

Image Added

Once you are presented with this screen, press next once (we do not need to alter any settings, unless they have changed):

Image Added

When presented with this dialog, enter the username and password that has been assigned to this your SQL login:

Continue to click next until you are at the end (no need to alter settings as it's already been set up).

Once you are at the end, click finish and then test the data source. You will be given a success/fail based on the information you have put as the credentials for the SQL authentication.

Once this has been configured, open TFS once more and when presented with the SQL login prompt, enter the username / password as normal.

You should now have access to TFS.

If users still continue to have issues with their SQL authentication, check the setup of the user that has been provided for the SQL Auth credentials.