Hi guys, an issue started on 29 Dec 2010. This is a QAS server which I use to send my SQL Overview mails http://www.sqlservercentral.com/articles/Administration/63042/
this server sends mail via an exchange server which worked fine until 29th. The PRD server is on the same domain and there is no issues sending mails.
Since the 29 Dec 2010 errors
The activated proc [dbo].[sp_sysmail_activate] running on queue msdb.dbo.ExternalMailQueue output the following: 'The service queue "ExternalMailQueue" is currently disabled.'
in SQL Server log every 5 seconds
We checked McAfee and made sure that 'Prevent mass mailing worms from sending mail' is unchecked
I also receive
Mail not queued. Database Mail is stopped. Use sysmail_start_sp to start Database Mail. (Microsoft SQL Server, Error: 14641)
I then run
after I run
alter queue ExternalMailQueue with status = on
I check the status with
SELECT is_broker_enabled FROM sys.databases WHERE name = 'msdb'
and all is fine but I still can't send mails out anymore. There is nothing in the Security log beside an ANONYMOUS LOGOFF on 29th
Application log has
Database Engine Instance=QAS_SErver;Mail PID=13976;Error Message:The connection is not open.
when the mails to send.
What else can I check?
There is nothing in the Dbmail log, only mail queue has started messages when I ran it manually. no mail queue has stopped messages
MCITP: Database Administrator 2005
MCTS DBA 2008