Configuration

This section explains each of the properties in the configuration blade.

Fig 1: TSA SQL Server configuration

General

Property	Description
Name	The name that will be visible when selecting a data source.

Server

Property	Description
Use Variables	Tick to use variables for the Server Instance, User Name, and Password settings, or enter them manually.
Server Instance	The address, either URL or the IP address, where the server can be accessed.
Use SQL Server Authentication	Some SQL credentials do not need a Password to be specified, while others do. Tick to enter a Password.
User Name	The username used to log into the SQL database.
Password	The password used to log into the SQL database. Applies if Use SQL Server Authentication is ticked.

Database

Property	Description
Database	The database from which data is retrieved.
Primary Key	The column or attribute of the SQL Query used to identify rows in the result (applies when Specify SQL Query is ticked).