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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL

From novice to tech pro — start learning today.