Configuring TFS Data Source

  • To Launch successfully, TFS requires a connection to a database, typically located on a server separate to your PC.

  • This guide outlines how to configure this connection.


  1. After installing The Finance Shop and Insula Core Components, click Start>All Programs


  2. Navigate to Insula Software>Utilities and open Data Sources (ODBC)





  3. Navigate to the System DSN tab and click Add.






  4. In the Create New Data Source dialog, select SQL Server Native Client  and then click Finish. (If SQL Server Native Client doesn't appear in the list, it can be installed from TFS Drive:\Setup\Database - MSSQL\Microsoft - SQL Server Native Client Driver\[Applicable SQL Version]\[applicable .msi]





  5. Type a name for the Data source. This will be TFSMain


  6. Select the applicable server from the Server drop-down menu and click Next.






  7. Determine the type of Authentication that this data source will use. This will be dependent on your environment and if unsure, your IT Department should be able to advise. Generally, if your PC is a part of a Domain, you will select With Integrated Windows Authentication. Click Next.






  8. Check Change the default database to: and select the relevant database from the drop-down and then click Next.





  9. Click Finish.





  10. Click Test Data Source...





  11. If the test completes successfully, the Framework client should be able to establish a connection to the database. If not, go back and ensure you entered the correct settings.