Speak with your email team to work this one out.
In Exchange / M365 you need to ensure the IP address of the sql servers are listed in the connect and relay boxes of the smtp configuration and connectors.
It may be different depending on the mail service you use but your mail team will be able to tell you what’s going on as that a smtp response.