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. >> Stay informed about: Errors trying to setup Database Mail in SQL 2005