Specifies the user name and password to enable access to
    databases, particularly remote databases.

    This clause lets you explicitly provide user name and password
    information in the CONNECT statement. If you do not specify user
    name and password information in the ALIAS clause or the ATTACH
    clause, SQL uses the user name and password specified in this
    clause as the default for each alias specified.

    For more information about when to use this clause, see the
    ATTACH statement.