1

Topic: Adjustment DataBase Mail SQL 2008

All greetings
I adjust DataBase Mail on SQL 2008, sending of the test letter is returned with an error
Mail it was not possible to deliver to receivers because of email server failure. (Message sending through the security account 1 (2018-02-05T10:58:54). The message on an exception: it is not possible to send the message on an email server. (Operation wait time effused.).
If the traffic goes through a proxy the server, whether it is possible to use at sending of adjustment of a proxy of the server and where they are in a SQL server 2008?
If to send through the mail client it is direct from the server where it is installed SQL at the disconnected adjustments of a proxy (used thunderburd) mail leaves, means administrators on  nevertheless adjusted unconditionally the traffic on smtp servers.

2

Re: Adjustment DataBase Mail SQL 2008

alvenav;
You yours smtp the server telnet th from the sequel-server see?

telnet <smtp_ip_address> 25

3

Re: Adjustment DataBase Mail SQL 2008

The answer on telnet smtp.mail.ru 25:
220 smtp48.i.mail.ru ESPTP ready

4

Re: Adjustment DataBase Mail SQL 2008

falvenav;
And, so wait a moment at you smtp on a mail ? At them like the port accordingly 465 is mandatory used TLS for transfer, and.
Though I can be mistaken.
Anyway, if the server sees itself smtp it is necessary for you to adjust correctly authorization https://help.mail.ru/mail-help/mailer/popsmtp

5

Re: Adjustment DataBase Mail SQL 2008

On these adjustments also did

6

Re: Adjustment DataBase Mail SQL 2008

alvenav;
Well , show then result:

select * from msdb.dbo.sysmail_configuration
select pa.profile_id, pa.account_id, a.name, s.servertype, s.servername, s.port, c.credential_id/*c.credential_identity, a.email_address*/
from msdb.dbo.sysmail_profileaccount pa
join msdb.dbo.sysmail_account an on pa.account_id = a.account_id
join msdb.dbo.sysmail_server s on s.account_id = a.account_id
left join sys.credentials c on c.credential_id = s.credential_id
select * from msdb.dbo.sysmail_event_log where log_date> = getdate () - 1 and event_type <> ' information'

7

Re: Adjustment DataBase Mail SQL 2008

felix_ff, late saw the message, tried on the server without a proxy, too did not work. As a result, dares two methods:
1. Update setting from here (it if without a proxy)
https://support.microsoft.com/ru-ru/hel … sql-server
2. Setting and adjustment stunnel
Without a proxy standard adjustments work
With  earned with these adjustments:
; Enable support for the insecure SSLv3 protocol
options =-NO_SSLv3
[gmail-smtp]
client = yes
accept = 127.0.0.1:25
connect = smtp.gmail.com:465
465 on  should be opened