Post reply

SQL Server Database mail

  • 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

  • September 14, 2009 at 3:58 pm

    #1053483

    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 )

  • September 14, 2009 at 9:04 pm

    #1053536

    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

  • September 14, 2009 at 10:37 pm

    #1053557

    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.). )

  • September 14, 2009 at 10:40 pm

    #1053558

    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.). )

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

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