A regular SQL Server connection using SQL Server Authentication in ETL Validator looks like below : 




Notice that there is no option to provide 'Instance' for the SQL Server connection. Starting from ETL Validator v3.4.3, there 'Custom' option that can used to specify a custom JDBC URL. 


Since ETL Validator uses the JTDS jdbc driver, the custom JDBC URL for specifying an instance would look like : 


jdbc:jtds:sqlserver://MYPC:1433/database;instance=SQLEXPRESS



The custom URL option is also available for other connections such as Oracle, DB2 and Hive 2.