Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Database Mail Configuration Problem in a cluster env. (SQL..

  
   Database Forums (Home) -> Clustering RSS
Next:  Which framework to choose? And why?  
Author Message
Julien

External


Since: Sep 11, 2006
Posts: 5



(Msg. 1) Posted: Sun Feb 03, 2008 3:07 pm
Post subject: Database Mail Configuration Problem in a cluster env. (SQL 2005 SP
Archived from groups: microsoft>public>sqlserver>clustering (more info?)
Hello,

I'm trying to configure Database Mail on our Cluster running 2 SQL server
2005 SP2 node.

The configuratoin wizard is running fine and I presume the details entered
are correct:
- Existing user
- FQN mail server etc..

I also made sure the cluster nodes were authorized to relay email on our
exchange mail server.

Trying to send a test mail flags up the following error in the Database Mail
error log:
"Date 07/12/2007 17:18:54
Log Database Mail (Database Mail Log)

Log ID 49
Process ID 4372
Last Modified 07/12/2007 17:18:54
Last Modified By DOMAIN\xxxx

Message
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)
(Please see code for message)"

I also restarted the database server as well as the SQL agent after this
modifications but still no success.

Any ideas?

Thanks

Julien

 >> Stay informed about: Database Mail Configuration Problem in a cluster env. (SQL.. 
Back to top
Login to vote
Geoff N. Hiten

External


Since: Feb 23, 2005
Posts: 443



(Msg. 2) Posted: Mon Feb 04, 2008 9:29 am
Post subject: Re: Database Mail Configuration Problem in a cluster env. (SQL 2005 SP [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
You may need to put a couple of entries for the short and FQDN cluster names
in the hosts file on each node.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP




"Julien" wrote in message

> Hello,
>
> I'm trying to configure Database Mail on our Cluster running 2 SQL server
> 2005 SP2 node.
>
> The configuratoin wizard is running fine and I presume the details
> entered
> are correct:
> - Existing user
> - FQN mail server etc..
>
> I also made sure the cluster nodes were authorized to relay email on our
> exchange mail server.
>
> Trying to send a test mail flags up the following error in the Database
> Mail
> error log:
> "Date 07/12/2007 17:18:54
> Log Database Mail (Database Mail Log)
>
> Log ID 49
> Process ID 4372
> Last Modified 07/12/2007 17:18:54
> Last Modified By DOMAIN\xxxx
>
> Message
> 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)
> (Please see code for message)"
>
> I also restarted the database server as well as the SQL agent after this
> modifications but still no success.
>
> Any ideas?
>
> Thanks
>
> Julien
>

 >> Stay informed about: Database Mail Configuration Problem in a cluster env. (SQL.. 
Back to top
Login to vote
Julien

External


Since: Sep 11, 2006
Posts: 5



(Msg. 3) Posted: Mon Feb 04, 2008 9:59 am
Post subject: Re: Database Mail Configuration Problem in a cluster env. (SQL 200 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Spot On!

Thanks a lot Geoff.

Julien

"Geoff N. Hiten" wrote:

> You may need to put a couple of entries for the short and FQDN cluster names
> in the hosts file on each node.
>
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
>
>
> "Julien" wrote in message
>
> > Hello,
> >
> > I'm trying to configure Database Mail on our Cluster running 2 SQL server
> > 2005 SP2 node.
> >
> > The configuratoin wizard is running fine and I presume the details
> > entered
> > are correct:
> > - Existing user
> > - FQN mail server etc..
> >
> > I also made sure the cluster nodes were authorized to relay email on our
> > exchange mail server.
> >
> > Trying to send a test mail flags up the following error in the Database
> > Mail
> > error log:
> > "Date 07/12/2007 17:18:54
> > Log Database Mail (Database Mail Log)
> >
> > Log ID 49
> > Process ID 4372
> > Last Modified 07/12/2007 17:18:54
> > Last Modified By DOMAIN\xxxx
> >
> > Message
> > 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)
> > (Please see code for message)"
> >
> > I also restarted the database server as well as the SQL agent after this
> > modifications but still no success.
> >
> > Any ideas?
> >
> > Thanks
> >
> > Julien
> >
>
>
 >> Stay informed about: Database Mail Configuration Problem in a cluster env. (SQL.. 
Back to top
Login to vote
Bil Click

External


Since: Feb 12, 2008
Posts: 1



(Msg. 4) Posted: Tue Feb 12, 2008 9:16 am
Post subject: Re: Database Mail Configuration Problem in a cluster env. (SQL 2005 SP [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Hi Geof -

Could you please elaborate on your suggestion? Are you speaking of the
HOST file typically in C:\WINDOWS\system32\drivers\etc?

Thanks - Bil Click



*** Sent via Developersdex http://www.developersdex.com ***
 >> Stay informed about: Database Mail Configuration Problem in a cluster env. (SQL.. 
Back to top
Login to vote
Geoff N. Hiten

External


Since: Feb 23, 2005
Posts: 443



(Msg. 5) Posted: Tue Feb 12, 2008 12:45 pm
Post subject: Re: Database Mail Configuration Problem in a cluster env. (SQL 2005 SP [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Yes. That will allow local applications to connect to the virtual
resources.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Bil Click" wrote in message

> Hi Geof -
>
> Could you please elaborate on your suggestion? Are you speaking of the
> HOST file typically in C:\WINDOWS\system32\drivers\etc?
>
> Thanks - Bil Click
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
 >> Stay informed about: Database Mail Configuration Problem in a cluster env. (SQL.. 
Back to top
Login to vote
M W

External


Since: Feb 13, 2008
Posts: 1



(Msg. 6) Posted: Wed Feb 13, 2008 11:16 am
Post subject: Re: Database Mail Configuration Problem in a cluster env. (SQL 2005 SP [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Geoff
I am new. I get a similar error (below)
We also have a clustered server.

SELECT * FROM sysmail_allitems
and I get 3 entires for the e-mails I tried to sent.
The field, status=UNSENT

Any idea how to fix this ?

MW



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.DataAccessAdap
ter.GetAccount(Int32 accountID) at
Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory
..CreateSendMailCommand(DBSession dbSession) at
Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandRunner.
Run(DBSession db) at
Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.Mail
Operation(Object o)


*** Sent via Developersdex http://www.developersdex.com ***
 >> Stay informed about: Database Mail Configuration Problem in a cluster env. (SQL.. 
Back to top
Login to vote
Geoff N. Hiten

External


Since: Feb 23, 2005
Posts: 443



(Msg. 7) Posted: Wed Feb 13, 2008 3:03 pm
Post subject: Re: Database Mail Configuration Problem in a cluster env. (SQL 2005 SP [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Did the hosts file modification not work?

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP


"M W" wrote in message

>
> Geoff
> I am new. I get a similar error (below)
> We also have a clustered server.
>
> SELECT * FROM sysmail_allitems
> and I get 3 entires for the e-mails I tried to sent.
> The field, status=UNSENT
>
> Any idea how to fix this ?
>
> MW
>
>
>
> 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.DataAccessAdap
> ter.GetAccount(Int32 accountID) at
> Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory
> CreateSendMailCommand(DBSession dbSession) at
> Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandRunner.
> Run(DBSession db) at
> Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.Mail
> Operation(Object o)
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
 >> Stay informed about: Database Mail Configuration Problem in a cluster env. (SQL.. 
Back to top
Login to vote
Syed Hasan Zubair

External


Since: May 13, 2008
Posts: 1



(Msg. 8) Posted: Tue May 13, 2008 3:37 am
Post subject: Database Mail issue on Sql Server 2005 64 Bit Clustered [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
i configured the database mail on Sql Server 2005 64 Bit Clustered environment for sending email notifications, but getting this error.


Message
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.CommandRunner.Run(DBSession db)
at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.MailOperation(Object o)



Dont getting a clue how to Resolve this Problem,

Help in this Regard is really appreciated.
 >> Stay informed about: Database Mail Configuration Problem in a cluster env. (SQL.. 
Back to top
Login to vote
Geoff N. Hiten

External


Since: Feb 23, 2005
Posts: 443



(Msg. 9) Posted: Tue May 13, 2008 3:28 pm
Post subject: Re: Database Mail issue on Sql Server 2005 64 Bit Clustered Environment [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
I find I have to insert a Hosts file entry that points the short
VirtualServer name to the virtual IP address of the SQL instance. Then
Database mail can find the clustered instance correctly.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP




"Syed Hasan Zubair" wrote in message ...
>i configured the database mail on Sql Server 2005 64 Bit Clustered
>environment for sending email notifications, but getting this error.
>
>
> Message
> 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.CommandRunner.Run(DBSession
> db)
> at
> Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.MailOperation(Object
> o)
>
>
>
> Dont getting a clue how to Resolve this Problem,
>
> Help in this Regard is really appreciated.
>
>
>
 >> Stay informed about: Database Mail Configuration Problem in a cluster env. (SQL.. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Changing SQL Service account passowrd on a cluster configu.. - Hi, I have SQL 2005 server (with Named Instance) running on a two node Cluster Configuration (Active/Passive). SQL Instance, SQL Server Agent, SQL Server Browser services are running under a service account (domain account). Similarly Cluster service...

Memory configuration for sql server 2000 active/passive cl.. - Dear All, We are installating an acive/passive sql server 2000 cluster. One of my friend recommended to configure the max server memory as total server memory - 256. When I asked him why, he said it will prevent SQL Serer 2000 from using all the..

Cluster problem - An installation of sql2k5 sp2 to one node of a three node active/active/active cluster has failed. It cannot proceed beyond the beginning of the sql2k5 sp2 installation. It fails because it can't install sqlsupport.msi. It seems to want to put the..

Configuring SIS in a Cluster problem - I am attempting to configure SIS in a clustered environment using the instructions found at http://msdn2.microsoft.com/en-us/library/ms345193.aspx. I have added the required dependancies to a new generic resource in the Cluster Adminstration screen and i...

Database Mirror in a SQL cluster - I read that you can implement DB mirror in a cluster. However, someone else said that you cannot. Does anyone have any ideas which is correct?
   Database Forums (Home) -> Clustering All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]