Skip to content

SQLServerF1

SQLServerF1 – In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, Frequently asked questions, SQL Server Trainings

  • Home
  • SQL Server FAQ
  • SQL Server Errors
  • SQL Server Events
  • SQL Server Trainings
  • Disclaimer

Category: Database Mail

SQL Server Database Mail Failure in Sending E-Mails Other Networks

December 25, 2014 SQLServerF1 Leave a comment
SQLServerF1

SQL Server Database Mail was introduced with SQL Server 2005 onwards and provides a very good way of sending E-Mails through SQL Server. This is very good feature and used widely. It is easy to configure database mail once we know the SMTP server name which can be used to send our E_Mails. Most often or not there are no problems configuring or using database mail feature, however there can be cases where there are problems sending E-Mails.

We would like to discuss about one of the weird issue which causes the database mail to fail sending E-Mails to some E-Mail addresses. In this scenario, Database Mails can be sent to all E-Mail addresses which are part of same network or domain in which the Mail server or SMTP server belongs, but mails cannot be sent to outside networks.

Example: SMTP server name is in domain MyDomain.com and E-Mails can be sent to any E_Mails which belong to this same domain DBA@MyDomain.com, but it fails when we try to send to some other domain like test@otherdomain.com, etc. Below is the error message received.

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 4 (2014-08-23T25:22:48). Exception Message: Cannot send mails to mail server. (The operation has timed out.).

This issue happens due to various reasons. First make sure that the mails can be sent to these addresses from this SMTP server. You can test this by sending the E-Mail from outlook to the failed E-Mail address. Sometimes some domains may be blocked.

If it fails to send E-Mail to local domain, then check if that IP address is On the Mail Server Relay and, if not then add the IP address of that domain to allow the communication. You can add the IP address from below, however this is the task of Network Administrator or Exchange Server Admin.

Mail server -> Exchange Server Manager -> SMTP Connector Properties -> Access Properties -> Access Tab -> Relay button

Once they fix this issue, then the E-Mails can be sent through SQL Server without any problems.

What is SQL Server Database Mail?
Database Mail is an enterprise solution for sending e-mail messages from the SQL Server Database Engine. Using Database Mail, your database applications can send e-mail messages to users. The messages can contain query results, and can also include files from any resource on your network. Database Mail is designed for reliability, scalability, security, and supportability.

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.

 
  • Database Mail

Polls

Which Relational Database Management System Do you Like?

View Results

Loading ... Loading ...

Categories

  • AlwaysON (13)
  • Backup/Restore (21)
  • Blocking (2)
  • Cloud (19)
  • Cluster Shared Volumes (3)
  • ColumnStore Index (1)
  • Connectivity (13)
  • Database Engine (86)
  • Database File Gorw/Shrink (4)
  • Database Mail (1)
  • Database Mirroring (2)
  • Database Snapshot (1)
  • DBCC Commands (6)
  • Encryption (4)
  • Frequently Asked Question and Answers (9)
  • General (18)
  • Import/Export (2)
  • In-Memory OLTP (3)
  • Informatica Errors (459)
  • LogShipping (5)
  • Maintenance Plans (4)
  • MYSQL Errors (168)
  • Operating System (40)
  • Other Products Errors (2,381)
  • Replication (3)
  • SAP Errors (1,662)
  • Security (15)
  • SQL Azure (14)
  • SQL Azure Errors (17)
  • SQL Server (346)
  • SQL Server 2008 R2 (15)
  • SQL Server 2012 (17)
  • SQL Server 2014 (38)
  • SQL Server 2016 (34)
  • SQL Server Analysis Services (2)
  • SQL Server Best Practices (9)
  • SQL Server Browser (2)
  • SQL Server Cluster (9)
  • SQL Server Errors (662)
  • SQL Server Indexes (1)
  • SQL Server Integration Services (1)
  • SQL Server Jobs (4)
  • SQL Server Known Issues (103)
  • SQL Server Management Studio (8)
  • SQL Server Memory (2)
  • SQL Server Monitoring (7)
  • SQL Server on Linux (2)
  • SQL Server Performance (28)
  • SQL Server Reporting Services (1)
  • SQL Server Startup (11)
  • SQL Server Waits (23)
  • SQL Server/Service Pack Installation (42)
  • Sybase Errors (106)
  • TeraData Errors (500)
  • Third-Party Tools for SQL Server (24)
  • TraceFlags (7)

Archives

  • November 2020
  • August 2017
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • December 2015
  • November 2015
  • August 2015
  • July 2015
  • June 2015
  • May 2015
  • April 2015
  • March 2015
  • February 2015
  • January 2015
  • December 2014
  • November 2014
  • October 2014
  • September 2014
  • August 2014
  • July 2014

Recents Posts

  • Scrambled Database refreshes in SQL ServeR
  • SQL Server Consolidation Frequently Asked Questions and Answers
  • The login is From an Untrusted Domain and Cannot be Used with Windows Authentication
  • Updates About SQL Server 2016 on Linux
  • Details about EXECSYNC Wait Type in SQL Server
January 2021
M T W T F S S
 123
45678910
11121314151617
18192021222324
25262728293031
« Nov    

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Recent Comments

  • Arun on SQL Server 2012 SP1 Upgrade Step ‘msdb110_upgrade.sql’ Encountered Error 537, State 3, Severity 16
  • Raja raman on SAP Error Messages and Error Codes from SAP Error 12-109 to 12-118
  • Almeida on SQL Server 2012 SP1 Upgrade Step ‘msdb110_upgrade.sql’ Encountered Error 537, State 3, Severity 16
  • Lydia on SQL Server Installation Wizard disappears After Setup Support Files
  • Tejas Shah on Oracle Database Errors or Warnings from Error ORA-02851 to ORA-02878

RSS Related News

  • Disclaimer
Powered by WordPress and Dynamic News.