August 31, 2006 at 1:28 pm
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
September 1, 2006 at 8:36 am
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]
September 1, 2006 at 10:05 am
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply