SQL 2005 Database Mail Question

  • dba92081

    SSC Eights!

    Points: 934

    Is it possible to have Database Mail work with a 64-bit SQL 2005 cluster environment?  I keep getting the error message below when trying to send an email message.  I am not sure where to look to fix this.  Any suggestions?  We are running version 9.00.2153.00.

    Thank you in advance for any advice!

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

    08/31/2006 11:04:51,,Error,756,1)

    Exception Information<nl/>===================<nl/>

    Exception Type: System.NullReferenceException<nl/>

    Message: Object reference not set to an instance of an object.<nl/>

    Data: System.Collections.ListDictionaryInternal<nl/>

    TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Objects.Account

    GetAccount(Int32)<nl/>HelpLink: NULL<nl/>Source: DatabaseMailEngine<nl/>

    <nl/>StackTrace Information<nl/>===================<nl/>  

    at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DataAccessAdapter.GetAccount(Int32 accountID)<nl/>  

    at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.SessionManager.GetAccount(Int32 accountID)<nl/>  

    at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateSendMailCommand(DBSession dbSession)<nl/>  

    at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandRunner.Run(DBSession db)<nl/>  

    at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.MailOperation(Object o),3604,,,

    8/31/2006 11:04:51 AM

  • MarkusB

    SSC-Dedicated

    Points: 37369

    I'm not sure what is your problem, but I can confirm that Database mail works on x64 clustered environment.

    To check everything you can do the following:

    1. run sp_configure to see if DatabaseMail XPs are enabled

    2. In SSMS under management check your profile and account settings

    3. Check the Database mail log

    If you want to use Database mail for SQL Agent notifications, check the properties and after making any changes to your profile, you need to restart SQL Agent.

    Hope this helps

    Markus

    [font="Verdana"]Markus Bohse[/font]

  • Michelle-164472

    SSCommitted

    Points: 1715

    See this thread...

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=584081&SiteID=1

    It includes this MS article:

    http://support.microsoft.com/kb/320027

    Hope this helps...Michelle

Viewing 3 posts - 1 through 3 (of 3 total)

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