I would like to say that as i want to configure multiple database mail in single account name in sql server 2012.
This is SQL-Cluster-DB , so as per direction from head, If any sql job will fail , then notification should be myself (i,e; DBA) as well as System Administrator.
For single account name , a single email id is working properly. when i am going to change 'Outgoing mail server (SMTP)' with one mail id to two mail id like this way:
Outgoing mail server (SMTP) Email address : first mail id; second mail id display name : MS SQL Server 2012 Backup notification reply e-mail : first mail id; second mail id Server name : (My company mail server) Port NO:(my company smtp mail port no)
After configuration of multiple mail id in email address , i am getting this error
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2015-12-02T10:36:37). Exception Message: Cannot send mails to mail server. (The specified string is not in the form required for an e-mail address.). )
when i am remove one email id from email address as well as reply e-mail of SMTP require configuration , then test mail is working properly.
My Question is like that: 1) Is it possible to configure multiple emailid alert notification in a single account ) Again required 'second account name' for second email alert notification.
My Working environment of SQL server 2012 is like that :
1) windows server 2012 R2 1) Microsoft SQL Server Standard (64-bit) 3)SQL Server is in Cluster Environment (that's why multiple sql alerts notification required) 4)System is in Domain environment. 5)It's Online Server
Any suggestion or help will be appreciated.