I have an external SMTP provider: auth.smtp.1and1.co.uk
I am trying to send SQL
Server Reporting Services emails via this on an Windows 2012 Azure VM.
It is configured sufficiently correctly for emails to be generated, but I've not configured something or mis-configured something as the emails then stay in the queue.
Setup details
Configured SMTP Virtual
Server
General: IP Address: Fixed value
Access: Access Control: Authentication: ticked Anonymous access
Access: Connection Control: All except the list below (which is empty)
Access: relay restrictions: Only the list below (which contains 127.0.0.1), ticked 'allow all..' option
Delivery: Outbound Security...:Basic Authentication with username and password completed, ticked TLS encryption
Delivery: Outbound connections...:TCP port=587
Delivery: Advanced: FQDN=ServerName, smarthost=auth.smtp.1and1.co.uk
I then set the following SSRS rsreportserver.config values:
<SMTPServer>100.92.192.3</SMTPServer>
<SendUsing>2</SendUsing>
<SMTPServerPickupDirectory> c:\inetpub\mailroot\pickup </SMTPServerPickupDirectory>
<From>
[email protected]</From>
Tried so far
1) turning the smtp service off and on again (just in case)
2) run SMTPDiag with no errors (also no emails)
3) tried turning off the firewall for the ports (and more generally to see if it made a difference)
4) tried generation from powershell which resulted with message in queue
5) added 25 and 857 as endpoint
6) perused the event log and found some warnings that appear to be about the recipient
Message delivery to the remote domain 'gmail.com' failed for the following reason: Unable to bind to the destination
server in DNS.
Message delivery to the host '212.227.15.179' failed while delivering to the remote domain 'gmail.com' for the following reason: The remote
server did not respond to a connection attempt.
7) tried pinging but this appears to be blocked on azure
8) tried more powershell sending on different domains variants (localhost, boxname, internal ip used in smtp properties, 127.0.0.1) - none resulting in success
9) tried adding a remote domain - no change
Could anyone recommend what step 10 should be in fixing this issue please?