I can't really check right now but under your client access properties
settings or in the connection properties there is an option for the
connection to ask for a password when needed or to prompt every time - are
you sure you don't have the odd one here and there accidentally set up to
prompt every time ?