SQL Server 2005 SP2 Database Mail Problem

Question

Post reply

SQL Server 2005 SP2 Database Mail Problem

Viewing 8 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

MohammedU SSCoach Points: 19644 More actions · Answer 1

Did you enabled database mail procedures in SAC?

Check sql error and mail log for more info...

MohammedU
Microsoft SQL Server MVP

Ned Smith SSC Enthusiast Points: 118 More actions · Answer 2

Yes, Database mail stored procedures are enabled in the Surface Are Configuration.

The only messages in the log files is the one that I reported which came from the

Application event log and an "Activation failed" error that was in the Database Mail

Log.

Ned Smith

JDC-286127 Mr or Mrs. 500 Points: 503 More actions · Answer 3

There is a hotfix related to Database Mail and SP2, I'm not positive the KB article off the top of my head but do a search on microsoft's website

Simone Fleming SSC Enthusiast Points: 148 More actions · Answer 4

We are receiving the same error message as stated in this post. The KB article is a hotfix for database mail, but it seems to be related only to private accounts and the error message is different. Did this fix work to fix the "Invalid Parameter" error?

Thanks,

Simone

pujain SSCrazy Points: 2903 More actions · Answer 5

i am getting the same issue, does anybody has any solution for this.

homebrew01 SSC Guru Points: 55566 More actions · Answer 6

homebrew01

SSC Guru

Points: 55566

August 8, 2011 at 9:15 am

#1365290

Are you still on SP2 ?? I hope not.

pujain SSCrazy Points: 2903 More actions · Answer 7

pujain

SSCrazy

Points: 2903

August 8, 2011 at 9:16 am

#1365291

no, SP3

homebrew01 SSC Guru Points: 55566 More actions · Answer 8

What are your specific problems, errors, settings etc ?? ....

Being specific will get you better answers (not that I am likely to have any).

Also, I think it would be better to start a new thread instead of bringing up a 4 year old thread of someone else's issues that are not exactly the same as yours (SP2 vs SP3 for example)