SQL Server Notifications not being sent

Last weekend we moved our SQL Server from one server (Windows 2003, SQL 2005) to a new server (Windows 2012, SQL 2012) and copied over all the users and roles to the new server. The Migration went rather smoothly and the users are able to use the database without problem however all the notifications that come from that server are no longer sent. The accounts are still there the Jobs are still there and running without problem but the notifications are not going out. I have checked the SQL Agent and emailing is enabled and I can send out emails to my email from Database Email yet no notifications are sent.

What could be the issue? No firewall is on and the Exchange server it not rejecting the emails eventhough they are being sent from DB Mail. I Don't know where else to look.
TimSr. System AdminAsked:
Who is Participating?
 
Patrick BogersDatacenter platform engineer LindowsCommented:
Hi

Only enabling mail is not enough, you need to set operators and notifications.
Have a quick look on this link and you will find the problem.
https://www.mssqltips.com/sqlservertip/1523/how-to-setup-sql-server-alerts-and-email-operator-notifications/

Cheers
0
 
Tom CieslikIT EngineerCommented:
If you're using Exchange server to send notification from SQL make sure that new IP address of new SQL is added to  mail flow/receive connector / Relay scope.

If not, then Exchange is not accepting emails from SQL.

(This path is an example from Exchange 2013)
0
 
Daniel_PLDB Expert/ArchitectCommented:
Hi,

Let's verify what's going on at DBMail logs by executing following query

SELECT * FROM msdb.dbo.sysmail_event_log;

Open in new window


Regards,
Daniel
0
Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

 
Deepak ChauhanSQL Server DBACommented:
If you are able to send email from database then no issue with DB mail configuration. Please check the link shared by Patrick Bogers .
1. Agent job require Operator to send Completion / Failure event notification. So check the Agent job property if operator is set there and same operator exists on server.

2. SQL Server Agent should be enable for DB mail notification. You can check it from SQL Agent property if  "Enable email Profile " check box is marked or not.
0
 
TimSr. System AdminAuthor Commented:
I followed the link from Patrick Bogers and I am now getting alerts in my email but I wanted to get notifications from my jobs when the complete. from this example I can see that DB Mail is working but it is not sending notifications when a job completes.

This is probably a new case but I ran into this issue on a new job I created where I am rebuilding the index, reindexing, updating statistics and backing up the databases.  'Non-SysAdmins have been denied permission to run DTS Execution job steps without a proxy account.  The step failed.' The domain admin is running this job and I checked secuity and he is a Sysadmin so I don't understand the issue. Could this be whats causing the notifications to not go out when a job is ran?
0
 
Tom CieslikIT EngineerCommented:
Do you have setup notifications inside your Job under SQL Server Agent ?
You must specify if you want to send email or page or Net Send and select trigger like

Job succeeds
Job fails
Job completes
0
 
TimSr. System AdminAuthor Commented:
Yes, I have that set up to send an email when the job completes.
0
 
Deepak ChauhanSQL Server DBACommented:
Create NON sysadmin user in MSDB and add them into "DatabaseMailUserRole", this role already exists in MSDB database.
0
 
Tom CieslikIT EngineerCommented:
Did you check your email configuration ?

Go to Management / Database Mail

Check email server settings.

Then if you're using internal Exchange go to your email server Mail Flow / Receive Connector and double check if your SQL server IP is in  Relay Connector / Scoping / on Remote Network setting as allow to send email through this connector.
0
 
Tom CieslikIT EngineerCommented:
Tim, did you've used our advises ? If yes, please close this question and award Expert by selecting Best Solution and/or assisted solution
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.