Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Database mail


Database mail

Author
Message
shanila_minnu
shanila_minnu
SSC Veteran
SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)

Group: General Forum Members
Points: 205 Visits: 572
i am using standard edition of sql server 2005..also i need advise on task creat to clean databasemail history ........
Jack Corbett
  Jack Corbett
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: General Forum Members
Points: 11014 Visits: 14858
As I said earlier, if you have McAfee Enterprise you need you McAfee administrator to make the changes or else they will be overwritten by policy.

You can change it on your own by going into VirusScan Console -> Double-Click on Access Protection -> Select the Anti-Virus Standard Protection Category -> Select the Prevent mass mailing worms from sending mail -> Click Edit -> Add DatabaseMail90.exe to the processes to exclude -> Click OK -> Click OK -> Exit VirusScan console by clicking the "X" In the upper right.

Again changing it locally will be overwritten by enterprise policy.



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming
At best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at work

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
shanila_minnu
shanila_minnu
SSC Veteran
SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)

Group: General Forum Members
Points: 205 Visits: 572
please advise how to create maintanence plan to clean databasemail history ........
Dugi
Dugi
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1316 Visits: 3511
shanila_minnu (5/22/2009)
please advise how to create maintanence plan to clean databasemail history ........



Try this:

http://www.sqlservercentral.com/Forums/FindPost721992.aspx

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/
jts2013
jts2013
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1172 Visits: 5009
Jack Corbett (5/18/2009)
In addition to what Jonathan is recommending you should also check your anti-virus setting (if you have AV on your SQL Server). By default McAfee blocks Database mail through it's access protection setting, prevent mass mailing worms from sending mail. When this happens you get the error you listed. You need to add database mail (DatabaseMail90.exe) as an exception to the rule.


I would recomend anyone to check their AV is not blocking port 25 as a starting point, as I have spent three weeks wondering why DB MAil would work on five servers, but not on two others. In the end I spotted a message from McAfee in the Application section of Event Viewer saying it had kindly blocked an outgoing email request ;-)
csecord
csecord
SSC Veteran
SSC Veteran (281 reputation)SSC Veteran (281 reputation)SSC Veteran (281 reputation)SSC Veteran (281 reputation)SSC Veteran (281 reputation)SSC Veteran (281 reputation)SSC Veteran (281 reputation)SSC Veteran (281 reputation)

Group: General Forum Members
Points: 281 Visits: 124
In virus scan console=>Access protection =>prevent massmailing worm from sending mail=>EDIT => Processes to exclude: add "DatabaseMail90.exe"
Vishal Singh
Vishal Singh
Old Hand
Old Hand (380 reputation)Old Hand (380 reputation)Old Hand (380 reputation)Old Hand (380 reputation)Old Hand (380 reputation)Old Hand (380 reputation)Old Hand (380 reputation)Old Hand (380 reputation)

Group: General Forum Members
Points: 380 Visits: 517
Jack Corbett (5/21/2009)
As I said earlier, if you have McAfee Enterprise you need you McAfee administrator to make the changes or else they will be overwritten by policy.

You can change it on your own by going into VirusScan Console -> Double-Click on Access Protection -> Select the Anti-Virus Standard Protection Category -> Select the Prevent mass mailing worms from sending mail -> Click Edit -> Add DatabaseMail90.exe to the processes to exclude -> Click OK -> Click OK -> Exit VirusScan console by clicking the "X" In the upper right.

Again changing it locally will be overwritten by enterprise policy.


I tried this by enabling databasemail90.exe as an exception list but its not working until and unless I completely disable the access protection. (it not waiting for the policy to be overwritten by administrator). Can there be some other possibilities?

-Forum Etiquette: How to post Performance Problems

-Forum Etiquette: How to post data/code to get the best help
Jack Corbett
  Jack Corbett
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: General Forum Members
Points: 11014 Visits: 14858
Are you using SQL Server 2005 or 2008? In 2008 it is changed to DatabaseMail.exe.



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming
At best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at work

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
david_a_wallace
david_a_wallace
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 16
THANK YOU SO MUCH!

I upgraded our company from Exchange Server and SQL 2000 to SQL 2005 and google apps and the database mail has been broken for a while.

Been tearing my hair out when ever I tried to figure out what I did wrong only to discover it was McAfee Smile
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search