Using Standard Authentication

You can configure the connector to authenticate your connection using your Redshift user name and password.

To configure standard authentication:

  1. To access the authentication options, open the ODBC Data Source Administrator where you created the DSN, select the DSN, and then click Configure.
  2. If Auth Type is not already set to Standard, then from the Auth Type drop-down list, select Standard.
  3. In the User field, type your user name for accessing your Redshift account.
  4. In the Password field, type the password corresponding to the user name you typed.
  5. Encrypt your credentials by selecting one of the following:
    • If the credentials are used only by the current Windows user, select Current User Only.
    • Or, if the credentials are used by all users on the current Windows machine, select All Users Of This Machine.
  6. To save your settings and close the dialog box, click OK.

Related topics