September 8, 2011 at 7:20 am
Is this a firewall issue?
September 8, 2011 at 7:47 am
lets do some basic diagnostics;
does this return STARTED or something different?
EXECUTE msdb.dbo.sysmail_help_status_sp --STARTED?
try stopping and starting the mail service:
EXECUTE msdb.dbo.sysmail_stop_sp;
GO
EXECUTE msdb.dbo.sysmail_start_sp;
and finally, yes, you probably need to bouhce the SLQ Agent.
this is not the exact issue you mention, but Kimberly tripp has a similar issue requiring the stop and start of the Agent.
Lowell
September 8, 2011 at 8:04 am
HOw long does it take to stop the Mail Service? It has been over 10 min's , the query is still executing. Will keep updated when the service stops.
Lowell (9/8/2011)
lets do some basic diagnostics;does this return STARTED or something different?
EXECUTE msdb.dbo.sysmail_help_status_sp --STARTED?
try stopping and starting the mail service:
EXECUTE msdb.dbo.sysmail_stop_sp;
GO
EXECUTE msdb.dbo.sysmail_start_sp;
and finally, yes, you probably need to bouhce the SLQ Agent.
this is not the exact issue you mention, but Kimberly tripp has a similar issue requiring the stop and start of the Agent.
September 9, 2011 at 11:58 pm
Tried stopping the mail service using EXECUTE msdb.dbo.sysmail_stop_sp;
, Even after 1 hr the Query is executing. Unable to stop the service.
(: Hakuna Matata 🙂 (9/8/2011)
HOw long does it take to stop the Mail Service? It has been over 10 min's , the query is still executing. Will keep updated when the service stops.Lowell (9/8/2011)
lets do some basic diagnostics;does this return STARTED or something different?
EXECUTE msdb.dbo.sysmail_help_status_sp --STARTED?
try stopping and starting the mail service:
EXECUTE msdb.dbo.sysmail_stop_sp;
GO
EXECUTE msdb.dbo.sysmail_start_sp;
and finally, yes, you probably need to bouhce the SLQ Agent.
this is not the exact issue you mention, but Kimberly tripp has a similar issue requiring the stop and start of the Agent.
September 12, 2011 at 12:49 am
Even after 3.5 hours , I was unable to stop the mail service. What could be the issue. Can restarting the SQL server solve this issue.
(: Hakuna Matata 🙂 (9/9/2011)
Tried stopping the mail service usingEXECUTE msdb.dbo.sysmail_stop_sp;
, Even after 1 hr the Query is executing. Unable to stop the service.(: Hakuna Matata 🙂 (9/8/2011)
HOw long does it take to stop the Mail Service? It has been over 10 min's , the query is still executing. Will keep updated when the service stops.Lowell (9/8/2011)
lets do some basic diagnostics;does this return STARTED or something different?
EXECUTE msdb.dbo.sysmail_help_status_sp --STARTED?
try stopping and starting the mail service:
EXECUTE msdb.dbo.sysmail_stop_sp;
GO
EXECUTE msdb.dbo.sysmail_start_sp;
and finally, yes, you probably need to bouhce the SLQ Agent.
this is not the exact issue you mention, but Kimberly tripp has a similar issue requiring the stop and start of the Agent.
September 12, 2011 at 2:48 am
Try these things
Right click on Sql server Agent > Properties > Now click on Enable mail profile
Click on ok.
September 12, 2011 at 2:53 am
The mail profile has already been enabled. I
mandeep.joon (9/12/2011)
Try these thingsRight click on Sql server Agent > Properties > Now click on Enable mail profile
Click on ok.
September 12, 2011 at 4:43 am
I restarted the Database Mail service, deleted the existing profiles & accounts and created a new profile & account. Yet I am unable to send Test Mails. In the database Mail log I can only find the entries of restarting the Mail Service, no logs generated for the test mails sent. Somebody help me please as the Mail service is down from 1st September.
(: Hakuna Matata 🙂 (9/12/2011)
The mail profile has already been enabled. Imandeep.joon (9/12/2011)
Try these thingsRight click on Sql server Agent > Properties > Now click on Enable mail profile
Click on ok.
September 13, 2011 at 12:38 am
Can restarting the SQL Server resolve my issue, Since this is a Production Server used 24/7, I am reluctant to restart the SQL Server. My other concern is what if I am unable to restart the SQL Server. I am unable to restart the Server, how can I troubleshoot this issue?
September 13, 2011 at 10:21 am
Check with your IT / Tech Services department to make sure there's been no recent changes to the Exchange Server (assuming your company uses that), there's this nifty little setting in Exchange that "Allow Server to relay mail" (not sure on the exact wording here), and it's server specific (for any server with SMTP installed).
Of course you could google or BOL the relaying issue as well (there's tons of articles on that out there - ex: http://technet.microsoft.com/en-us/library/dd277329.aspx)
Without that set, you'll experience issues that you're describing. You can send thousands of emails (without any errors) but none are ever received.
Also, were any recent windows updates installed on the server?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 13, 2011 at 5:56 pm
Just check with your system administrators to see if they have recently made any changes to the SMTP server or any Antivirus software is blocking the mails or ports etc..
Thank You,
Best Regards,
SQLBuddy
September 14, 2011 at 7:06 am
The IT Team confirms that we don't use Exchange Server. I tried using my Gmail Id with the following settings:
Server Name: smtp.gmail.com
port no: 587
Check : This server requires a secure connection
Check Basic Authentication with my gmail id & password.
Default public profile
Still the same problem
MyDoggieJessie (9/13/2011)
Check with your IT / Tech Services department to make sure there's been no recent changes to the Exchange Server (assuming your company uses that), there's this nifty little setting in Exchange that "Allow Server to relay mail" (not sure on the exact wording here), and it's server specific (for any server with SMTP installed).Of course you could google or BOL the relaying issue as well (there's tons of articles on that out there - ex: http://technet.microsoft.com/en-us/library/dd277329.aspx)
Without that set, you'll experience issues that you're describing. You can send thousands of emails (without any errors) but none are ever received.
Also, were any recent windows updates installed on the server?
September 14, 2011 at 7:22 am
The same Gmail settings worked fine on my other production server.
(: Hakuna Matata 🙂 (9/14/2011)
The IT Team confirms that we don't use Exchange Server. I tried using my Gmail Id with the following settings:Server Name: smtp.gmail.com
port no: 587
Check : This server requires a secure connection
Check Basic Authentication with my gmail id & password.
Default public profile
Still the same problem
MyDoggieJessie (9/13/2011)
Check with your IT / Tech Services department to make sure there's been no recent changes to the Exchange Server (assuming your company uses that), there's this nifty little setting in Exchange that "Allow Server to relay mail" (not sure on the exact wording here), and it's server specific (for any server with SMTP installed).Of course you could google or BOL the relaying issue as well (there's tons of articles on that out there - ex: http://technet.microsoft.com/en-us/library/dd277329.aspx)
Without that set, you'll experience issues that you're describing. You can send thousands of emails (without any errors) but none are ever received.
Also, were any recent windows updates installed on the server?
September 14, 2011 at 6:08 pm
Something might be blocking the mail relay from this server. Check if the ports are being blocked by any antivirus software , file filters etc...
Thank You,
Best Regards,
SQLBuddy
September 15, 2011 at 1:37 am
The issue has been resolved finally. I had to restart the SQL Server. Once restarted The server started sending all the mails that were in queue. Still have no clue as to what was the issue.
Viewing 15 posts - 16 through 29 (of 29 total)
You must be logged in to reply to this topic. Login to reply