I created a 'Other - JDBC Driver' datasource using 'net.sourceforge.jtds.jdbc.Driver' (MSSQL2.cfc) as classname in order to be able to connect to a named instance.
It is now listed in the administrator as 'MSSQL - Microsoft SQL Server (Vendor jTDS)'. This means I can not edit the datasource properly.
A few options would be available:
- an extra tab for each datasource that allows editing the dsn string
- custom arguments for each jdbc string
- save the datasource by type
- implement more options for the MSSQL2 driver (so instance can be provided)