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?
