Error using CDOSYS in a process

Hi !
I created a backup process that sends me an email (CDOSYS) with the result
of this operation, following the instructions at
http://support.microsoft.com/defaul...;312839&sd=tech
The problem is that the stored procedure sp_send_cdosysmail crashes if it's
run inside a SQL Server 2000 SP3a process (schedule or manual execution is
the same) but it run fine if I use query analyzer to exec the sp. Process
and query analyzer window have a single TSQL instruction (exec...) but the
SQL Server Agent keeps on stopping after a while with an error (I don't
remember the message but it was something like "not responding after 30
secs") if I run the process.
What could it be ? Thank you.
Mauro CastaldiI strongly suggest using CDO within sp_OACreate. Try using xp_smtp_sendmail
instead... http://www.aspfaq.com/2403
http://www.aspfaq.com/
(Reverse address to reply.)
"Mauro Castaldi" <no.spam.kastaldi@.hotmail.com> wrote in message
news:41e10c24$0$8209$5fc30a8@.news.tiscali.it...
> Hi !
> I created a backup process that sends me an email (CDOSYS) with the result
> of this operation, following the instructions at
> http://support.microsoft.com/defaul...;312839&sd=tech
> The problem is that the stored procedure sp_send_cdosysmail crashes if
it's
> run inside a SQL Server 2000 SP3a process (schedule or manual execution is
> the same) but it run fine if I use query analyzer to exec the sp. Process
> and query analyzer window have a single TSQL instruction (exec...) but the
> SQL Server Agent keeps on stopping after a while with an error (I don't
> remember the message but it was something like "not responding after 30
> secs") if I run the process.
> What could it be ? Thank you.
> Mauro Castaldi
>

Error using CDOSYS in a process

Hi !
I created a backup process that sends me an email (CDOSYS) with the result
of this operation, following the instructions at
http://support.microsoft.com/default.aspx?scid=kb;en-us;312839&sd=tech
The problem is that the stored procedure sp_send_cdosysmail crashes if it's
run inside a SQL Server 2000 SP3a process (schedule or manual execution is
the same) but it run fine if I use query analyzer to exec the sp. Process
and query analyzer window have a single TSQL instruction (exec...) but the
SQL Server Agent keeps on stopping after a while with an error (I don't
remember the message but it was something like "not responding after 30
secs") if I run the process.
What could it be ? Thank you.
Mauro CastaldiI strongly suggest using CDO within sp_OACreate. Try using xp_smtp_sendmail
instead... http://www.aspfaq.com/2403
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Mauro Castaldi" <no.spam.kastaldi@.hotmail.com> wrote in message
news:41e10c24$0$8209$5fc30a8@.news.tiscali.it...
> Hi !
> I created a backup process that sends me an email (CDOSYS) with the result
> of this operation, following the instructions at
> http://support.microsoft.com/default.aspx?scid=kb;en-us;312839&sd=tech
> The problem is that the stored procedure sp_send_cdosysmail crashes if
it's
> run inside a SQL Server 2000 SP3a process (schedule or manual execution is
> the same) but it run fine if I use query analyzer to exec the sp. Process
> and query analyzer window have a single TSQL instruction (exec...) but the
> SQL Server Agent keeps on stopping after a while with an error (I don't
> remember the message but it was something like "not responding after 30
> secs") if I run the process.
> What could it be ? Thank you.
> Mauro Castaldi
>

Error using CDOSYS in a process

Hi !
I created a backup process that sends me an email (CDOSYS) with the result
of this operation, following the instructions at
http://support.microsoft.com/default...312839&sd=tech
The problem is that the stored procedure sp_send_cdosysmail crashes if it's
run inside a SQL Server 2000 SP3a process (schedule or manual execution is
the same) but it run fine if I use query analyzer to exec the sp. Process
and query analyzer window have a single TSQL instruction (exec...) but the
SQL Server Agent keeps on stopping after a while with an error (I don't
remember the message but it was something like "not responding after 30
secs") if I run the process.
What could it be ? Thank you.
Mauro Castaldi
I strongly suggest using CDO within sp_OACreate. Try using xp_smtp_sendmail
instead... http://www.aspfaq.com/2403
http://www.aspfaq.com/
(Reverse address to reply.)
"Mauro Castaldi" <no.spam.kastaldi@.hotmail.com> wrote in message
news:41e10c24$0$8209$5fc30a8@.news.tiscali.it...
> Hi !
> I created a backup process that sends me an email (CDOSYS) with the result
> of this operation, following the instructions at
> http://support.microsoft.com/default...312839&sd=tech
> The problem is that the stored procedure sp_send_cdosysmail crashes if
it's
> run inside a SQL Server 2000 SP3a process (schedule or manual execution is
> the same) but it run fine if I use query analyzer to exec the sp. Process
> and query analyzer window have a single TSQL instruction (exec...) but the
> SQL Server Agent keeps on stopping after a while with an error (I don't
> remember the message but it was something like "not responding after 30
> secs") if I run the process.
> What could it be ? Thank you.
> Mauro Castaldi
>

Error Sending Email

Hello All
I have an issue sending email through a data driven subscription using
remote SMTP
ReportingServicesService!emailextension!4!12/13/2007-07:29:52:: Error
sending mail, CDO error -2147220977, will not resend
ReportingServicesService!emailextension!4!12/13/2007-07:29:52:: Error
sending email. System.Runtime.InteropServices.COMException (0x8004020F): The
server rejected one or more recipient addresses. The server response was:
550 must be authenticated
at ReportingServicesCDOInterop.MessageClass.Send()
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification
notification)
I am logging to my m/c as a user with admin rights (No domain login). The
Reporting Service Service account is the same as login account. SQL agent
also runs as same user account.
SMTP is a ISP's. I have changed
<SendEmailToUserAlias>False</SendEmailToUserAlias>. In my Antivirus console
in Access protection I disabled prevent Mass Mailing worms from port 25. The
From Email is a valid email that I use with SMTP Server.
I am not sure how to resolve this authentication error. I have read
somewhere Reporting Service Service Account should have permission on SMTP
server. I don't know how this is possible with remote SMTP server.
Can someone help me with this? I have been trying to resolve this couple
of days now.
RegardsOn Dec 13, 7:34 pm, "Achuthan Sundar" <achu...@.cubisone.com> wrote:
> Hello All
> I have an issue sending email through a data driven subscription using
> remote SMTP
> ReportingServicesService!emailextension!4!12/13/2007-07:29:52:: Error
> sending mail, CDO error -2147220977, will not resend
> ReportingServicesService!emailextension!4!12/13/2007-07:29:52:: Error
> sending email. System.Runtime.InteropServices.COMException (0x8004020F): The
> server rejected one or more recipient addresses. The server response was:
> 550 must be authenticated
> at ReportingServicesCDOInterop.MessageClass.Send()
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification
> notification)
> I am logging to my m/c as a user with admin rights (No domain login). The
> Reporting Service Service account is the same as login account. SQL agent
> also runs as same user account.
> SMTP is a ISP's. I have changed
> <SendEmailToUserAlias>False</SendEmailToUserAlias>. In my Antivirus console
> in Access protection I disabled prevent Mass Mailing worms from port 25. The
> From Email is a valid email that I use with SMTP Server.
> I am not sure how to resolve this authentication error. I have read
> somewhere Reporting Service Service Account should have permission on SMTP
> server. I don't know how this is possible with remote SMTP server.
> Can someone help me with this? I have been trying to resolve this couple
> of days now.
> Regards
This link might help.
http://www.systemwebmail.com/faq/4.3.2.aspx
Regards,
Enrique Martinez
Sr. Software Consultant