2

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.

Improve this question
5
  • 2
    you need to create an email account with single email id then Create OPERATOR and add email ids to that operator as many as you want.
    – AA.SC
    Commented Dec 2, 2015 at 13:02
  • 1
    @AA.SC,As your instruction, i have created single an email account in SMTP, Also created Operator (like "SQL Job Failure") . And "SQL Job Failure" Operator email name , i have given multiple email id. But still getting same error.
    – Md Haidar Ali Khan
    Commented Dec 3, 2015 at 6:26
  • 1
    @AA.SC, Is there required any distribution list within mailing list.
    – Md Haidar Ali Khan
    Commented Dec 3, 2015 at 6:34
  • 2
    did you verified your profile by sending test emails? If yes and its working fine then follow steps to create operator mentioned in answer.
    – AA.SC
    Commented Dec 3, 2015 at 7:18
  • 1
    @AA.SC, Yes i did verified with sending test email. For Single email it's working properly.
    – Md Haidar Ali Khan
    Commented Dec 3, 2015 at 7:21

1 Answer 1

Reset to default
1

Create Database Email operator

Step 1: enter image description here

Step 2: enter image description here

Step 3: enter image description here

One More step enable Sql Server Agent properties for notifying alerts and restart agent once these properties are settled.

Sql Server Agent -> Properties -> enter image description here

Improve this answer
1
  • 1
    you are awesome. You saved my a day.
    – Md Haidar Ali Khan
    Commented Dec 3, 2015 at 7:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.