Connection string options affecting trace

By default, it is not allowed to trace everything done by an application. To be able to trace SQL statements and parameter values the application being traced must allow this. This is done with the AllowedTraceLevel connection string option.

The option AllowedTraceLevel can be set to none, safe, or confidential. The default setting is safe. The following trace categories are allowed to be traced on the different levels:

None: No tracing is allowed on the connection.
Safe: ActivityTrace, Error, Internal, Info, and Connect are allowed to be traced. This is the default.
Confidential: All trace categories are allowed to be traced, including SqlStatements, and SqlParameters.

The connection string options Database, User ID, and Application Name can be used to filter the trace output. One or many Databases, User IDs, and Application Names can be specified in the configuration file under the <filters>-tag. By doing that, trace will only be enabled for the connections with the specified database(s), user ID(s), and/or application name(s).

Reference

ConnectionString Property

MimerConnectionStringBuilder Class