Summary:

When the application (Sage CRM) is started and running, in what circumstances will Sage CRM trigger the connection to database that requires the id and password again?

Resolution:

If you set the HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\eWare\Config\CRM\SQLLogging value for a CRM install to 6 in the registry and then perform an iisreset the ewaresql log will output information about when CRM is making a connection with the database and the login details it is using each time.