I have gone thru and set up Database Mail and am trying to send a test message. When I send the test, the following is shown in the log: 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) If I try to send a mail directly in Queryanalyzer by using the sp_send_dbmail sp, it says Mail Queued, but then when I look in the log, the same error above shows. All the info I have found on the Internet seems to be related to clustered server. This is not a clustered server. Our Mail Server is a Lotus Notes Server. Any help would be greatly appreciated.
I should note that I have tested the SMTP server by writing a simple VB.Net program that uses the System.Net.SMTPClient class to send a message and it works fine. "gea" wrote: > I have gone thru and set up Database Mail and am trying to send a test > message. When I send the test, the following is shown in the log: > > 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) > > > If I try to send a mail directly in Queryanalyzer by using the > sp_send_dbmail sp, it says Mail Queued, but then when I look in the log, the > same error above shows. All the info I have found on the Internet seems to > be related to clustered server. This is not a clustered server. > > Our Mail Server is a Lotus Notes Server. > > Any help would be greatly appreciated.
Hi gea - This news group is dedicated to SQL Server Notification Services. You'll probably have more luck getting responses from another news group or forum. HTH.. Joe -- Joe Webb SQL Server MVP http://weblogs.sqlteam.com/joew/ On Mon, 10 Mar 2008 13:53:15 -0700, gea wrote: > I should note that I have tested the SMTP server by writing a simple > VB.Net program that uses the System.Net.SMTPClient class to send a > message and it works fine. > > "gea" wrote: > >> I have gone thru and set up Database Mail and am trying to send a test >> message. When I send the test, the following is shown in the log: >> >> 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) >> >> >> If I try to send a mail directly in Queryanalyzer by using the >> sp_send_dbmail sp, it says Mail Queued, but then when I look in the >> log, the same error above shows. All the info I have found on the >> Internet seems to be related to clustered server. This is not a >> clustered server. >> >> Our Mail Server is a Lotus Notes Server. >> >> Any help would be greatly appreciated.
