Set the transactional attributes first to ensure the first connection establishes fine