The connection settings tab allows for the configuration of the SQL Server instance, database and credentials to use when connecting to the database.


   



Instance Name

The name of the SQL server or instance name - for example "DEMO-SQL01" or "DEMO-SQL01\SQLExpress".


Database Name

The name of the database against which the query should be executed.


Use Default Credentials

Uses windows authentication to connect to the SQL instance using the XIA Automation Server service account.


Use Specific Credentials

Uses SQL authentication to connect to the SQL Server with the specified SQL login credentials.