![]() We will need to test and see if we can send DB Mail via PowerShell or other scripts (rule out impact of DB Mail service and see if we could directly send email to your SMTP server to isolate the issue further). ![]() If telnet to the IP and port from DB Mail server to SMTP server is successful, it means the network from DB server to SMTP server is good. Open “Server Manager” > “Add roles and features” > click “Next” until reaching the “Features” step > tick “Telnet Client” > click “Install” > when the feature installation finishes, click “Close”. Open Windows Start menu > Type "Control Panel" > Press Enter > “Programs” > "Programs and Features" > Turn Windows features on or off > Select "Telnet Client" > Press “OK" Open CMD as administrator and run below command to telnet your target server IP and portįor example, to verify connection to 192.168.0.10 on port 25, issue the command: If the DB Mail server can communicate with other server without issue, then the problem lies on the network traffic with SMTP server If the telnet is not successful, it means the network communication from DB Mail server to SMTP server has caused the problem. In SQL DB Mail server, telnet the SMTP server to see if SQL machine can communicate with the IP and port of your SMTP (the port number configured in your profile). Steps: Open SSMS, select Management, right-click Database Mail, and select Configure Database Mail -> Manage Database Mail accounts and profiles > Next. The type of SMTP authentication you have chosen.Whether or not you have checked the box “this server requires a secure connection(SSL)”.The Port Number you have chosen for this account.Check DB Mail account profile’s security configuration options and port number you have chosen for further troubleshooting purpose.Install Path:\Program Files\Microsoft SQL Server\MSSQL1.SQL2019\MSSQL\Binn\DatabaseMail.exe Check and ensure the SQL Server service account has permission to call the Database mail’s executable file (DatabaseMail.exe).Check and ensure DB Mail has been enabled.SELECT * FROM _event_log ORDER BY log_date DESC Check SQL DB Mail errors from DMV and logs.General Troubleshooting Steps to Narrow Down RCA In this case, TLS 1.2 needs to be enabled at DB Mail server. Scenario 2: SQL DB Mail failure caused by SMTP mail server requesting TLS 1.2. If your SMTP server requires implicit TLS, then SQL Server DB Mail will not be able to send email using this SMTP server. Scenario 1: Implicit SSL/TLS mode is not supported for SQL Server DB Mail. General Troubleshooting Steps to Narrow Down RCA.It also discusses 2 special scenarios with SQL Server Database Mail that commonly cause mail sending failure This blog discusses troubleshooting steps to investigate the failure of SQL Server Database Mail service on sending email.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |