Email validation in ReportManager

Setting up a timed subscription in Reporting Services works just fine on our
server when the email address is joe@.domain.com. The Report server is set
up pointing to our SMTP server and works like a champ. Reports go out and
our chosen format (PDF) is generated and all is good.
When we enter a non-standard Email in the TO field (a RightFax email
address), the timed event runs and gives us a status of "The e-mail address
of one or more recipients is not valid."
Our question is: How can we turn off email validation within reporting
services so it will connect to the SMTP server (Exchange)?
ThanksHi,
This issue is usually caused by the fact that Email Relay is not turned on.
You may see something like the following in the Reporting Services Logfiles:
ReportingServicesService!emailextension!b14!10/14/2004-08:20:06:: Error
sending mail, CDO error -2147220977, will not resend
ReportingServicesService!emailextension!b14!10/14/2004-08:20:06:: Error
sending email. System.Runtime.InteropServices.COMException (0x8004020F):
The server
rejected one or more recipient addresses. The server response was: 550
5.7.1 Unable to relay for xxx@.xxx.xxx
at ReportingServicesCDOInterop.MessageClass.Send()
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Noti
fication notification)
ReportingServicesService!notification!b14!10/14/2004-08:20:06::
Notification 02710147-2025-4ed0-9c58-b37f12b64a79 completed. Success:
False, Status: The e-mail
address of one or more recipients is not valid., DeliveryExtension: Report
Server
Emai
If this is the case, you need to turn on email relay on the SMTP server.
If the error in the Reporting Services log file is not the same, please let
me know the exact error message so that we could get a better idea of the
issue.
The log file is usually located at:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\Logfiles
Thanks & Regards,
Justin Shen
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
| Reply-To: "isicoder" <isicoder@.newsgroups.nospam>
| From: "isicoder" <isicoder@.newsgroups.nospam>
| Subject: Email validation in ReportManager
| Date: Fri, 27 Jan 2006 12:35:16 -0800
| Lines: 16
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| Message-ID: <OPD1vE4IGHA.424@.TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 67.96.36.252
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67707
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Setting up a timed subscription in Reporting Services works just fine on
our
| server when the email address is joe@.domain.com. The Report server is
set
| up pointing to our SMTP server and works like a champ. Reports go out
and
| our chosen format (PDF) is generated and all is good.
|
| When we enter a non-standard Email in the TO field (a RightFax email
| address), the timed event runs and gives us a status of "The e-mail
address
| of one or more recipients is not valid."
|
| Our question is: How can we turn off email validation within reporting
| services so it will connect to the SMTP server (Exchange)?
|
| Thanks
|
|
|
|

EMail subscription fails with LOGON FAILED

I am setting up SQL Reporting enterprise. I can't get email subscriptions to
work. SQL Reporting enterprise is installed and the report works fine when
generated. The security is setup to use a windows account and store
credentials on server. This account has the SA role within SQL and the
database where data is being pulled from. Platform is Win2003 - fully
patched with Reporting service pack 1
There is nothing in the event logs indicating any type of failure.
The SMTP server is setup as remote SMTP server and I've verified the config
file to ensure it is setup correctly. Since I'm getting a logon failure -
I'm not sure its really an email issue at this point. Specifically, the
config file is set up as:
<SMTPServer>172.24.1.25</SMTPServer>
<SMTPServerPort>25</SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate>0</SMTPAuthenticate>
<From>SQLREP@.correctdomain.com</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
At this time out out of ideas - can anyone suggest where to look?What is the login failure you're recieving? Is it in the report server log
file when you try to perform the delivery?
If so the report server service account may not have rights to push email to
your SMTP server. You might need to drop them to the file system and use a
local SMTP server to pass them along to your outbound SMTP server.
-Lukasz
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bill" <Bill@.discussions.microsoft.com> wrote in message
news:60EAFC5B-9844-40DD-AE82-86A766D719E2@.microsoft.com...
>I am setting up SQL Reporting enterprise. I can't get email subscriptions
>to
> work. SQL Reporting enterprise is installed and the report works fine
> when
> generated. The security is setup to use a windows account and store
> credentials on server. This account has the SA role within SQL and the
> database where data is being pulled from. Platform is Win2003 - fully
> patched with Reporting service pack 1
> There is nothing in the event logs indicating any type of failure.
> The SMTP server is setup as remote SMTP server and I've verified the
> config
> file to ensure it is setup correctly. Since I'm getting a logon failure -
> I'm not sure its really an email issue at this point. Specifically, the
> config file is set up as:
> <SMTPServer>172.24.1.25</SMTPServer>
> <SMTPServerPort>25</SMTPServerPort>
> <SMTPAccountName></SMTPAccountName>
> <SMTPConnectionTimeout></SMTPConnectionTimeout>
> <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> <SMTPUseSSL></SMTPUseSSL>
> <SendUsing></SendUsing>
> <SMTPAuthenticate>0</SMTPAuthenticate>
> <From>SQLREP@.correctdomain.com</From>
> <EmbeddedRenderFormats>
> <RenderingExtension>MHTML</RenderingExtension>
> </EmbeddedRenderFormats>
> <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
> <ExcludedRenderFormats>
> <RenderingExtension>HTMLOWC</RenderingExtension>
> <RenderingExtension>NULL</RenderingExtension>
> </ExcludedRenderFormats>
> <SendEmailToUserAlias>True</SendEmailToUserAlias>
> At this time out out of ideas - can anyone suggest where to look?
>|||Thank you for the post. The logon failed is being shown in the web interface
under subscriptions.
The reportserverservice does show a login failure - although I can't imagine
why. I've setup the job with several credentials and all fail. (Including
Domain Admin role) The Reporting service is currently running as a network
service but I have also run it will a privledge domain account. Same error.
I am able to send to the SMTP server from this server without authentication.
I'm still stumped!
From the log file:
ReportingServicesService!dbpolling!6f0!2/10/2005-08:43:09::
NotificationPolling processing item 052e0da7-4e8f-4804-84fb-76bb1b373d62
ReportingServicesService!library!6f0!02/10/2005-08:43:09:: i INFO:
Initializing EnableIntegratedSecurity to 'True' as specified in Server
system properties.
ReportingServicesService!library!6f0!02/10/2005-08:43:10:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon
failed., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon
failed. --> System.Runtime.InteropServices.COMException (0x8007052E): Logon
failure: unknown user name or bad password.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pUserName,
String pDomain, String pPassword, Boolean bTryRemote, IntPtr& pImpToken)
at
Microsoft.ReportingServices.Diagnostics.DatasourceRuntimeContext.MakeUserToken(String userName, String userPwd, String domain)
-- End of inner exception stack trace --
ReportingServicesService!notification!6f0!02/10/2005-08:43:10:: e ERROR:
Error occured processing notification. Logon failed.
ReportingServicesService!notification!6f0!02/10/2005-08:43:10:: Notification
052e0da7-4e8f-4804-84fb-76bb1b373d62 completed. Success: False, Status:
Logon failed., DeliveryExtension: Report Server Email, Report: Expired
Enhancements, Attempt 0
ReportingServicesService!dbpolling!6f0!02/10/2005-08:43:10::
NotificationPolling finished processing item
052e0da7-4e8f-4804-84fb-76bb1b373d62
"Lukasz Pawlowski [MSFT]" wrote:
> What is the login failure you're recieving? Is it in the report server log
> file when you try to perform the delivery?
> If so the report server service account may not have rights to push email to
> your SMTP server. You might need to drop them to the file system and use a
> local SMTP server to pass them along to your outbound SMTP server.
> -Lukasz
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Bill" <Bill@.discussions.microsoft.com> wrote in message
> news:60EAFC5B-9844-40DD-AE82-86A766D719E2@.microsoft.com...
> >I am setting up SQL Reporting enterprise. I can't get email subscriptions
> >to
> > work. SQL Reporting enterprise is installed and the report works fine
> > when
> > generated. The security is setup to use a windows account and store
> > credentials on server. This account has the SA role within SQL and the
> > database where data is being pulled from. Platform is Win2003 - fully
> > patched with Reporting service pack 1
> >
> > There is nothing in the event logs indicating any type of failure.
> >
> > The SMTP server is setup as remote SMTP server and I've verified the
> > config
> > file to ensure it is setup correctly. Since I'm getting a logon failure -
> > I'm not sure its really an email issue at this point. Specifically, the
> > config file is set up as:
> >
> > <SMTPServer>172.24.1.25</SMTPServer>
> > <SMTPServerPort>25</SMTPServerPort>
> > <SMTPAccountName></SMTPAccountName>
> > <SMTPConnectionTimeout></SMTPConnectionTimeout>
> > <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> > <SMTPUseSSL></SMTPUseSSL>
> > <SendUsing></SendUsing>
> > <SMTPAuthenticate>0</SMTPAuthenticate>
> > <From>SQLREP@.correctdomain.com</From>
> > <EmbeddedRenderFormats>
> > <RenderingExtension>MHTML</RenderingExtension>
> > </EmbeddedRenderFormats>
> > <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
> > <ExcludedRenderFormats>
> > <RenderingExtension>HTMLOWC</RenderingExtension>
> > <RenderingExtension>NULL</RenderingExtension>
> > </ExcludedRenderFormats>
> > <SendEmailToUserAlias>True</SendEmailToUserAlias>
> >
> > At this time out out of ideas - can anyone suggest where to look?
> >
>
>|||Update: I failed to use RSKEYMGNT to export the key prior to resetting the
service account context. I set it back and will change the account properly
to see if this resolves the issue.
"Bill" wrote:
> Thank you for the post. The logon failed is being shown in the web interface
> under subscriptions.
> The reportserverservice does show a login failure - although I can't imagine
> why. I've setup the job with several credentials and all fail. (Including
> Domain Admin role) The Reporting service is currently running as a network
> service but I have also run it will a privledge domain account. Same error.
> I am able to send to the SMTP server from this server without authentication.
> I'm still stumped!
> From the log file:
> ReportingServicesService!dbpolling!6f0!2/10/2005-08:43:09::
> NotificationPolling processing item 052e0da7-4e8f-4804-84fb-76bb1b373d62
> ReportingServicesService!library!6f0!02/10/2005-08:43:09:: i INFO:
> Initializing EnableIntegratedSecurity to 'True' as specified in Server
> system properties.
> ReportingServicesService!library!6f0!02/10/2005-08:43:10:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon
> failed., ;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon
> failed. --> System.Runtime.InteropServices.COMException (0x8007052E): Logon
> failure: unknown user name or bad password.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pUserName,
> String pDomain, String pPassword, Boolean bTryRemote, IntPtr& pImpToken)
> at
> Microsoft.ReportingServices.Diagnostics.DatasourceRuntimeContext.MakeUserToken(String userName, String userPwd, String domain)
> -- End of inner exception stack trace --
> ReportingServicesService!notification!6f0!02/10/2005-08:43:10:: e ERROR:
> Error occured processing notification. Logon failed.
> ReportingServicesService!notification!6f0!02/10/2005-08:43:10:: Notification
> 052e0da7-4e8f-4804-84fb-76bb1b373d62 completed. Success: False, Status:
> Logon failed., DeliveryExtension: Report Server Email, Report: Expired
> Enhancements, Attempt 0
> ReportingServicesService!dbpolling!6f0!02/10/2005-08:43:10::
> NotificationPolling finished processing item
> 052e0da7-4e8f-4804-84fb-76bb1b373d62
>
> "Lukasz Pawlowski [MSFT]" wrote:
> > What is the login failure you're recieving? Is it in the report server log
> > file when you try to perform the delivery?
> >
> > If so the report server service account may not have rights to push email to
> > your SMTP server. You might need to drop them to the file system and use a
> > local SMTP server to pass them along to your outbound SMTP server.
> >
> > -Lukasz
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "Bill" <Bill@.discussions.microsoft.com> wrote in message
> > news:60EAFC5B-9844-40DD-AE82-86A766D719E2@.microsoft.com...
> > >I am setting up SQL Reporting enterprise. I can't get email subscriptions
> > >to
> > > work. SQL Reporting enterprise is installed and the report works fine
> > > when
> > > generated. The security is setup to use a windows account and store
> > > credentials on server. This account has the SA role within SQL and the
> > > database where data is being pulled from. Platform is Win2003 - fully
> > > patched with Reporting service pack 1
> > >
> > > There is nothing in the event logs indicating any type of failure.
> > >
> > > The SMTP server is setup as remote SMTP server and I've verified the
> > > config
> > > file to ensure it is setup correctly. Since I'm getting a logon failure -
> > > I'm not sure its really an email issue at this point. Specifically, the
> > > config file is set up as:
> > >
> > > <SMTPServer>172.24.1.25</SMTPServer>
> > > <SMTPServerPort>25</SMTPServerPort>
> > > <SMTPAccountName></SMTPAccountName>
> > > <SMTPConnectionTimeout></SMTPConnectionTimeout>
> > > <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> > > <SMTPUseSSL></SMTPUseSSL>
> > > <SendUsing></SendUsing>
> > > <SMTPAuthenticate>0</SMTPAuthenticate>
> > > <From>SQLREP@.correctdomain.com</From>
> > > <EmbeddedRenderFormats>
> > > <RenderingExtension>MHTML</RenderingExtension>
> > > </EmbeddedRenderFormats>
> > > <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
> > > <ExcludedRenderFormats>
> > > <RenderingExtension>HTMLOWC</RenderingExtension>
> > > <RenderingExtension>NULL</RenderingExtension>
> > > </ExcludedRenderFormats>
> > > <SendEmailToUserAlias>True</SendEmailToUserAlias>
> > >
> > > At this time out out of ideas - can anyone suggest where to look?
> > >
> >
> >
> >|||I am getting a logon failed when I set up my subscription through th
GUI in Report Manager. I confirmed that the SMTP settings wer
correct in the RSReportSever.config file. The Log is as follows: Ca
you help?
ReportingServicesService!library!d84!09/21/2005-14:39:10:: i INFO
Initializing EnableIntegratedSecurity to 'True' as specified i
Server system properties
ReportingServicesService!library!d84!09/21/2005-14:39:10:: e ERROR
Throwin
Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException
Logon failed.,
Info
Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException
Logon failed. --> System.Runtime.InteropServices.COMExceptio
(0x8007052E): Logon failure: unknown user name or ba
password. a
System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int3
errorCode, IntPtr errorInfo
at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(Strin
pUserName, String pDomain, String pPassword, Boolean bTryRemote
IntPtr& pImpToken
a
Microsoft.ReportingServices.Diagnostics.DatasourceRuntimeContext.MakeUserToken(Strin
userName, String userPwd, String domain
-- End of inner exception stack trace --
ReportingServicesService!notification!d84!09/21/2005-14:39:10::
ERROR: Error occured processing notification. Logon failed
ReportingServicesService!notification!d84!09/21/2005-14:39:10:
Notification 4105c963-0eb9-4f69-bbbc-81ab27964a43 completed.
Success: False, [b:f30cd15b21]Status: Logon failed.
DeliveryExtension: Report Server [/b:f30cd15b21]Email, Report
Incomplete Loan Applications, Attempt
ReportingServicesService!dbpolling!d84!09/21/2005-14:39:10:
NotificationPolling finished processing ite
4105c963-0eb9-4f69-bbbc-81ab27964a4

Email setup with Reporting Services

I am having no luck getting RS to send email. I see no error messages in any
of the logs.
I have correct SMTP settings. These same setting work for my Project Server
emails.
What should I be looking at to help debug this issue?
Thankshmm...
Double check the <RSEmailDPConfiguration> element in your
RSReportServer.config file. In the ReportServerService_**** log file in
the\LogFiles folder, check to make sure the email successfully sent. Check
the event log on the SMTP server you are using for any errors.
If all of the above checks out, double check your firewall settings to make
sure SMTP outgoing is allowed. Also, if you are sending attachments, you
will have to open up the firewall to allow these to go out.
HTH
Adrian M.
"GRupe" <GRupe@.discussions.microsoft.com> wrote in message
news:8C7FCACB-1608-4CF9-BB97-63A091DAB05D@.microsoft.com...
>I am having no luck getting RS to send email. I see no error messages in
>any
> of the logs.
> I have correct SMTP settings. These same setting work for my Project
> Server
> emails.
> What should I be looking at to help debug this issue?
> Thanks

Email setup for Admins

Hello all,
Can someone point me to a site that takes you thru the steps involve in
setting up the following;
We want the server to email a list of admins when the system is having
problems.
Thanks
--
Deasun
Home Site: www.tirnaog.com
Check out: The Code Vault in my forums section.In article <047E210D-909A-4F8C-AA4C-8FC891518A61@.microsoft.com>,
Deasun@.discussions.microsoft.com says...
> Hello all,
> Can someone point me to a site that takes you thru the steps involve in
> setting up the following;
> We want the server to email a list of admins when the system is having
> problems.
> Thanks
>
version?
--
Graham (Pete) Berry
PeteBerry@.Caltech.edu|||Sorry should have said:
2005
--
Deasun
Home Site: www.tirnaog.com
Check out: The Code Vault in my forums section.
"Pete Berry" wrote:
> In article <047E210D-909A-4F8C-AA4C-8FC891518A61@.microsoft.com>,
> Deasun@.discussions.microsoft.com says...
> > Hello all,
> >
> > Can someone point me to a site that takes you thru the steps involve in
> > setting up the following;
> > We want the server to email a list of admins when the system is having
> > problems.
> >
> > Thanks
> >
> version?
> --
> Graham (Pete) Berry
> PeteBerry@.Caltech.edu
>

Email if errors Exists in the error tables

I am setting my error tables.What i want to do is.If i find any data within my error tables i want an email to be sent to me.

How can i achieve this?

Please let me know

How are you populating those tables? do you want to receive an email on the first/each error or do you want to receive a single email at the end?

|||

Create a SQL Task that returns a value if you want to send an email or not.

Put the returned value in a variable.

Conditionally branch to email if the variable has the found value.

The SQL could be something like SELECT COUNT(1) cnt FROM ErrorTable. Have the SQL task return a single row. In mappings put variable 0 into a variable such as FoundError.

Add an email task, connect the two. Double click the line (constraint) and set it to an expression such as

@.FoundError > 0.

Hope that helps.

|||one single email only

|||

sureshv wrote:

one single email only

Then, Larry's suggestion should work for you. Wait until all data flow are done and then use an Execute SQl task in control flow to check is there were any errors; then you can use an expression in a precedence constraint to decide whether the email should be sent or not. There are another threads in this forums that tackle the how-to-send-an-email question

|||

I have Sql task and in General Tab in the

sql statement : i type SELECT COUNT(1)
FROM dbo.hb_test_error

when i execute and see now it workes fine

result set: from none to singlerow

Then Result set Tab

Variable Name : User::FoundError

Result Name :any name

Then i connect to email task

In precedence constraint editor

Evaluation operator : expression

Expression FoundError >0

i have this error

[Execute SQL Task] Error: Executing the query "SELECT COUNT(1) FROM dbo.hb_test_error" failed with the following error: "Parameter name is unrecognized.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

How do i solve this?

|||Set Result Name to: 0 (that's a zero)

Email format for Reporting Services

Hi, this question is related to Reporting Services on SQL Server 2000. When creating a report and setting it to send via email as an attached excel spreadsheet, the email is in the format HTML. Does anyone know if it possible to default this format to something else like Rich Text. I have a feeling that this might involve a change to the RSEmailDPConfiguration within the RSReportServer.config file but am not sure which tag needs changing or adding.

Any help/suggestions greatfully received.According to documentation:

rsreportserver.config

EmbeddedRenderFormats

Specifies the rendering format used to encapsulate a report within the body

of an e-mail message. Images within the report are subsequently embedded within

the report. Valid values are MHTML and HTML4.0.

Does not look like you'll get Rich Text in an email without some custom code.

cheers,
Andrew|||

RTF is not supported by out-of-the-box RS. Theoretically you can write your own renderer but it's a difficult task, plus then you'll need to write custom delivery provider to support it as well. Support for RTF is in the wish list for the next RS version.

|||Thanks for both of your comments. I had a feelling it might be a custom option.

Email Error: The delivery extension for this subscription could not be loaded.

I am just getting started using scheduled emails and after setting up the
config file and setting up a schedule...I get the following error reported
on the RS (and no email):
"The delivery extension for this subscription could not be loaded."
when the subscription fires.
Can some one point me in the right direction on where to get more
information on this error. Does this mean that the EMAIL extension could
not be loaded or,
that the rendering format could not be loaded or,
what?
My first guess is that I did not set up the the email config section
correctly. What do you think and where on my system (logs) should I look to
get more details on this error. Win2003 server has a working SMTP relay
(tested with CDO VBS script).
thanks in advance.
dlrLook in the ReportServerService<date>.log file for more error information.
Also in the RSReportServer.config file make sure the SMTPServer element and
From element are filled in.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
news:eFPk2xKgEHA.1196@.TK2MSFTNGP11.phx.gbl...
> I am just getting started using scheduled emails and after setting up the
> config file and setting up a schedule...I get the following error reported
> on the RS (and no email):
> "The delivery extension for this subscription could not be loaded."
> when the subscription fires.
> Can some one point me in the right direction on where to get more
> information on this error. Does this mean that the EMAIL extension could
> not be loaded or,
> that the rendering format could not be loaded or,
> what?
> My first guess is that I did not set up the the email config section
> correctly. What do you think and where on my system (logs) should I look
to
> get more details on this error. Win2003 server has a working SMTP relay
> (tested with CDO VBS script).
> thanks in advance.
> dlr
>|||ok Daniel. That problems seems to be a one time thing. Nothing in the log
file and repeated experiments today have basic email "working". Well
actually a problem HAS come up with the attachments but that is the subject
of another post.
thanks
dlr
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:udRV82KgEHA.592@.TK2MSFTNGP11.phx.gbl...
> Look in the ReportServerService<date>.log file for more error information.
> Also in the RSReportServer.config file make sure the SMTPServer element
and
> From element are filled in.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Dennis Redfield" <dennis.redfield@.acadia-ins.com> wrote in message
> news:eFPk2xKgEHA.1196@.TK2MSFTNGP11.phx.gbl...
> > I am just getting started using scheduled emails and after setting up
the
> > config file and setting up a schedule...I get the following error
reported
> > on the RS (and no email):
> > "The delivery extension for this subscription could not be loaded."
> > when the subscription fires.
> > Can some one point me in the right direction on where to get more
> > information on this error. Does this mean that the EMAIL extension
could
> > not be loaded or,
> > that the rendering format could not be loaded or,
> > what?
> >
> > My first guess is that I did not set up the the email config section
> > correctly. What do you think and where on my system (logs) should I
look
> to
> > get more details on this error. Win2003 server has a working SMTP relay
> > (tested with CDO VBS script).
> >
> > thanks in advance.
> >
> > dlr
> >
> >
>

Email Alert

I have a Windows 2003 server running SQL 2000 SP4. I want to start setting
up email alerts and reporting on the SQL server. what is the most safe and
best way to achive this?Hi docsql,
Welcome to use MSDN Managed Newsgroup Support.
From your description, my understanding of this issue is: You want to know
how to setup a email notification for an alert in SQL Server 2000. If I
misunderstood your concern, please feel free to point it out.
In SQL Server 2000, you can define the Response to an alert and choose the
email operator to notify.
To setup a SQL Mail, you need to configure a mail profile first.
SQL Mail must have a mail profile created in the same user domain account
or context that is used to start an instance of SQL Server. You can create
the profile with a mail client, such as Microsoft Outlook, that is
installed locally on the SQL Server computer.
You can find how to configure SQL Mail in the following article.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad
_1_server_2ecs.asp
Also, following KB article may help you to set up a SQL Agent Mail.
263556 INF: How to Configure SQL Mail
http://support.microsoft.com/?id=263556
315886 INF: Common SQL Mail Problems
http://support.microsoft.com/?id=315886
321183 HOW TO: Troubleshoot Your SQL Mail Issue
http://support.microsoft.com/?id=321183
311231 INF: Frequently Asked Questions - SQL Server - SQL Mail
http://support.microsoft.com/?id=311231
Hope this will be helpful.
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.