April 9, 2010 at 12:23 pm
Hello,
I have SQL Server and Agent running fine since years on sql 2005 X64 bit. all my jobs delivers emails once the job completes successfully. All of a sudden this morning, I didnt get any emails from any job on that server(jobs ran successfully).
I tried to send emails using,
use msdb
go
sp_send_dbmail @profile_name ='sqlserver-prod',
@recipients = 'xxx@domain.com',
@subject ='Test e-mail'.
After checking the logs i can see mail sent successfully but i didnt received the mail. I tried to send emails outside (gmail account) and it was working absolutely fine. But I cant get mails to my inbox.
After talking to my Windows team, they said they changed Domain Controllers last night. Does that make any difference? Do I need to restart any of my services? (I really dont want to do that.) Is this a bug in SQL server 2005 sp3 on x64 bit Enterprise Edition? I can see same problem happend in SQL 2000, see below.
http://www.sqlservercentral.com/Forums/Topic826907-110-1.aspx?Highlight=sql+agent+maintenance+jobs
Thanks
April 12, 2010 at 8:38 am
dallas13 (4/9/2010)
Hello,I have SQL Server and Agent running fine since years on sql 2005 X64 bit. all my jobs delivers emails once the job completes successfully. All of a sudden this morning, I didnt get any emails from any job on that server(jobs ran successfully).
I tried to send emails using,
use msdb
go
sp_send_dbmail @profile_name ='sqlserver-prod',
@recipients = 'xxx@domain.com',
@subject ='Test e-mail'.
After checking the logs i can see mail sent successfully but i didnt received the mail. I tried to send emails outside (gmail account) and it was working absolutely fine. But I cant get mails to my inbox.
After talking to my Windows team, they said they changed Domain Controllers last night. Does that make any difference? Do I need to restart any of my services? (I really dont want to do that.) Is this a bug in SQL server 2005 sp3 on x64 bit Enterprise Edition? I can see same problem happend in SQL 2000, see below.
http://www.sqlservercentral.com/Forums/Topic826907-110-1.aspx?Highlight=sql+agent+maintenance+jobs
Thanks
Sounds to me like what they did, has had the effect of denying internal mail relay. I have never heard of that. Generally external relay is denied (i.e your gmail test would fail), but internal relay is generally allowed.
Try writing a simple ssis or create a job that will fail so you can try other ways of sending out a mail; if no joy speak to your email team about internal relay.
HTH
Adam Zacks-------------------------------------------Be Nice, Or Leave
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply