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

Errors trying to setup Database Mail in SQL 2005

 
   Database Help (Home) -> Notification Services RSS
Next:  "Notification Services" compared to &qu..  
Author Message
gea

External


Since: Mar 10, 2008
Posts: 2



(Msg. 1) Posted: Mon Mar 10, 2008 10:24 am
Post subject: Errors trying to setup Database Mail in SQL 2005
Archived from groups: microsoft>public>sqlserver>notificationsvcs (more info?)

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 
Back to top
Login to vote
gea

External


Since: Mar 10, 2008
Posts: 2



(Msg. 2) Posted: Mon Mar 10, 2008 1:53 pm
Post subject: RE: Errors trying to setup Database Mail in SQL 2005 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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 
Back to top
Login to vote
Joe Webb1

External


Since: Apr 28, 2004
Posts: 118



(Msg. 3) Posted: Tue Apr 01, 2008 1:45 pm
Post subject: Re: Errors trying to setup Database Mail in SQL 2005 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
DST update errors - HI ALL, I ran the DST update scripts posted by Microsoft and I got the following errors, can someone look at it and provide me with some hints? How can I find out whcih database needed for the scripting update???? ..

SQL-NS 2005 StockBroker Sample doesn't notify - From Ch.3 of Shyam Pather's SQL-NS book, I have followed the instructions exactly as stated in the book, I get success on the TEST and setup_all and I get no errors when aI start the service as described on pg. 69-70. I run the Test.sql file that..

Notification Services 2005 Client Components Install problem - Hi, I am trying to install NS Client components on an IIS machine for my subscription management interface. The NS server will run on a different box. My IIS box has .Net framework installed but when I try to start the installation, I get an error..

database 'DBNAME' is not enabled for SQL cache notification - I'm getting this message on SqlCacheDependencyAdmin.EnableTableForNotifications and aspnet_regsql.exe -C connstr -lt Yet, the following execution has finished successfully: ALTER DATABASE dbname SET ENABLE_BROKER

Accessing NS Instance on a Database Server from a Web Server - Hello. I'm new to SQL Server 2005 Notification Services. I'm trying to access an Instance of SQL 2005 NS on a remote Database Server from a Web Service on a different web server, using the following code: <C#> using..
   Database Help (Home) -> Notification Services 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 ]