Post reply

Database Mail is not working anymore

  • June 5, 2007 at 8:22 am

    #119108

    Hi All!

    Today I came up with a bright idea that I should have a new NT account and use it whereever I need to use SQL Database Mail. Things went well firstly. I configured almost every instance below the production and tested succesfully with this brand new account. Lastly, close the end of the day, I configured the prod. server with the very same account and now it *does not work!!*

    In short: I have an NT account that works well on all other SQL server for SQL Database Mail Profile account. But this account does not work on the production server that is a cluster. It produces the following error.

    1) Exception Information  =================== 

    Exception Type: System.NullReferenceException 

    Message: Object reference not set to an instance of an object. 

    Data: System.Collections.ListDictionaryInternal 

    TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Objects.Account GetAccount(Int32) 

    HelpLink: NULL 

    Source: DatabaseMailEngine   

    StackTrace Information  ===================    

    at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DataAccessAdapter.GetAccount(Int32 accountID)    

    at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateSendMailCommand(DBSession dbSession)    

    at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateCommand(DBSession dbSession)    

    at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandRunner.Run(DBSession db)    

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

    I tried removing all the profiles and accounts, waiting till the DatabaseMail process is shut down itself and configure the profile and account again. Even this one didn't work

    Looking forward for your responses,

    Zubeyir.

  • June 5, 2007 at 10:14 am

    #710884

    Hi,

    did you use local or domain Windows account? Cluster can not access local accounts, you should be running on the Domain user account.

    Regards,Yelena Varsha

  • June 5, 2007 at 10:18 am

    #710886

    Thanks Yelena. It's a domain account.

    Zubeyir

  • June 5, 2007 at 10:57 am

    #710906

    Did you add this account to SQL Server? Maybe it has to be added to the individual servers? Make sure what machine you are on. Recently we could not find our accounts in the proper Built-in groups and then realized the cluster failed over to another machine where the group membership was not configured yet.

    There also could be a Firewall issue getting to the Domain Controller for getting the account information.

    Regards,Yelena Varsha

  • June 5, 2007 at 12:07 pm

    #710925

    Thanks for the reply Yelena.

    This account is not added to SQL Server, and it hasn't to be. This is just an SMTP account to reach the exchange server in the same domain. It is apparent that we need to find something with security but couldn't figure it out yet

    Regards,

    Zubeyir

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

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