Yes, you can. In the ConnectionParms.config,  just define your connection information.  In the example below, there are 3 connections.  The serverSelect is set to “Master” which will be the default server connection.  2 others are defined “MasterEQ” and “UserAccess”.


In the DALForSQL code,  you can specify what connection to use.  By default, the connection specified in the serverSelect will be used which in this case is “Master”.   Here is an example of overriding the DAL to use the UserAccess Connection. This is coded in the DALForSQL.