October 3, 2011 at 3:01 am
We have configured Database Mail, while testing we are getting below error please help me on this.
How can we reslove this.
for testing we used below code.
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'Simplesolve',
@recipients = 'sarath.vellampalli@gmail.com',
@body = 'Use new feature of Database mail. No MAPI client needed',
@subject = 'New Feature of Database Mail'
we are getting below 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
Kindest Regards,
Sarath Vellampalli
October 3, 2011 at 3:37 am
Looks like a bug. Is your SSMS patched to the latest SP and/or CU?
-- Gianluca Sartori
October 4, 2011 at 1:20 pm
Gianluca is spot on, there were numerous bugs related to database mail up to SP3. It is best if you update to, at a bare minimum, Service Pack 3
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply