SQL Server Database mail

Question

SQL Server Database mail

suunil

SSC Enthusiast

Points: 139
More actions
September 14, 2009 at 7:05 am

#226125

Hello,
I am trying to configure Database mail with SQL server 2005 (express) on 2 different machines. I was able to do it on one of them & the mails are going fine. On the second machine though, the emails are not going & when I do " SELECT * FROM msdb.dbo.sysmail_event_log" I get the following error --> The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2009-09-11T18:38:23). Exception Message: Cannot send mails to mail server. (The length of the data should be a multiple of 16 bytes.). )
Thanks for your help!!
Regards
Suunil

Viewing 5 posts - 1 through 4 (of 4 total)

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

psvirin Mr or Mrs. 500 Points: 542 More actions · Answer 1

Are you sure that was an express edition? As far as I know Mail is not provided with MSSQL 2005 Express.

But here is the dirty hack in order to get rid of this problem: http://weblogs.sqlteam.com/mladenp/archive/2007/07/01/60245.aspx

Hope that helps

-------------------

StarWind Software developer ( http://www.starwindsoftware.com )

MJ-1115929 Ten Centuries Points: 1278 More actions · Answer 2

Hi,

There is no support for database mail in SQL express editions.Also there is no sql server agent available so there is no alerts ,jobs scheduling etc.

You can check whether which version you are running by the following query

select @@version

Regards

Milesh

suunil SSC Enthusiast Points: 139 More actions · Answer 3

I know it works (& I have configured using the same blog) because I was able to configure it on one of the machines but on the 2nd machine (doing the same things) the emails are not going & when I do " SELECT * FROM msdb.dbo.sysmail_event_log" I get the following error --> The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2009-09-11T18:38:23). Exception Message: Cannot send mails to mail server. (The length of the data should be a multiple of 16 bytes.). )

suunil SSC Enthusiast Points: 139 More actions · Answer 4

I know it works (& I have configured using the same blog @ http://weblogs.sqlteam.com/mladenp/archive/2007/07/01/60245.aspx ) because I was able to configure & get it up & running on one of the machines but on the 2nd machine (doing the same things) the emails are not going & when I do " SELECT * FROM msdb.dbo.sysmail_event_log" I get the following error --> The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2009-09-11T18:38:23). Exception Message: Cannot send mails to mail server. (The length of the data should be a multiple of 16 bytes.). )