Description

When you specify credentials for or override a database connection using the "-login" option on the command line, Report Commander now supports a new syntax that better handles complex override scenarios.

The Command Line Builder will now generate command lines using the new syntax. The old syntax will continue to work.

The new syntax is as follows, with all sections optional:

-login:{server:new server}{database:new database}{schema:new schema}{userid:user ID}{password:unencrypted password}{encryptedpassword:encrypted password}

Note: The password or encryptedpassword section must come last.

For example, to set just the user ID and password:

-login:{userid:albert}{password:P@ssw0rd}

To use an encrypted password generated by Report Commander:

-login:{userid:albert}{encryptedpassword:5pkVfiMJHp2MsPoZUsPKc2zSRD7O94Jx}

To override the database name and set user ID and password:

-login:{database:proddb}{userid:albert}{password:P@ssw0rd}

See the user guide for more details.