Authentication

Database authentication should use Windows authentication whenever available for the best security and seamless user interface.

When Windows authentication isn't available, the database login can be stored with the data source connection string or entered when the job is opened if User Logon is configured.

It should be noted that when the password is entered as part of the data source connection, it can be viewed in plain text in the settings.

You can set an Admin Password in the Global Settings Wizard to require a password to edit job settings and prevent users from accessing decrypted passwords in the settings or modifying jobs accidentally.

The logon password can also be used to encrypt or decrypt PDF files.