?
Solved

SQL 2000 Reporting Subscriptions to Outside Recipients

Posted on 2009-02-09
5
Medium Priority
?
648 Views
Last Modified: 2012-05-06
My company has an old SQL 2000 server that is hosting various databases and reports. Our developers want to be able to set up report subscriptions to be e-mailed to addresses outside of the domain in which the SQL 2000 server resides.

They can configure subscriptions to be sent to e-mail addresses within the domain, but whenever they set a subscription to be delivered to an e-mail address outside of the domain the subscription window shows the following:

"The e-mail address of one or more recipients is not valid."

The contents of the relevant section of the RSReportServer.config file is posted below.

Thank you in advance.
<Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
				<MaxRetries>3</MaxRetries>
				<SecondsBeforeRetry>900</SecondsBeforeRetry>
				<Configuration>
					<RSEmailDPConfiguration>
						<SMTPServer>EXCHANGE-SERVER.DOMAIN.LOCAL</SMTPServer>
						<SMTPServerPort></SMTPServerPort>
						<SMTPAccountName></SMTPAccountName>
						<SMTPConnectionTimeout></SMTPConnectionTimeout>
						<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
						<SMTPUseSSL></SMTPUseSSL>
						<SendUsing></SendUsing>
						<SMTPAuthenticate></SMTPAuthenticate>
						<From>DO-NOT-REPLY@DOMAIN.LOCAL</From>
						<EmbeddedRenderFormats>
							<RenderingExtension>MHTML</RenderingExtension>
						</EmbeddedRenderFormats>
						<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
						<ExcludedRenderFormats>
							<RenderingExtension>HTMLOWC</RenderingExtension>
							<RenderingExtension>NULL</RenderingExtension>
						</ExcludedRenderFormats>
						<SendEmailToUserAlias>True</SendEmailToUserAlias>
						<DefaultHostName></DefaultHostName>
						<PermittedHosts></PermittedHosts>
					</RSEmailDPConfiguration>
				</Configuration>
			</Extension>

Open in new window

0
Comment
Question by:dfxdeimos
  • 3
  • 2
5 Comments
 
LVL 12

Expert Comment

by:Steven Wells
ID: 23597022
You could do this:

Create a contact in Active Directory with the details of the external email address and then configure your sql script to email the contact.

Contact will then have a local address, thus allowing exchange to relay externally correctly, rather than sql.
0
 
LVL 14

Author Comment

by:dfxdeimos
ID: 23597278
Well, I know there is a way to make it able to directly e-mail to outside addresses, so that is the solution that I am looking for here. Thanks though.
0
 
LVL 12

Accepted Solution

by:
Steven Wells earned 2000 total points
ID: 23597316
Is your SQL server is in the list of allowed SMTP relay hosts on your exchange server?
0
 
LVL 14

Author Comment

by:dfxdeimos
ID: 23597353
I will check on this in the morning and report back.
0
 
LVL 14

Author Closing Comment

by:dfxdeimos
ID: 31544780
Thanks!
0

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Are you looking for the options available for exporting EDB files to PST? You may be confused as they are different in different Exchange versions. Here, I will discuss some options available.
There can be many situations demanding the conversion of Outlook OST files to PST format and as such, there is no shortage of automated tools to perform this conversion. However, what makes Stellar OST to PST converter stand above the rest? Let us e…
The video tutorial explains the basics of the Exchange server Database Availability groups. The components of this video include: 1. Automatic Failover 2. Failover Clustering 3. Active Manager
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question