We help IT Professionals succeed at work.

SQL 2000 Reporting Subscriptions to Outside Recipients

Medium Priority
728 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

Comment
Watch Question

Steven WellsSystems Administrator

Commented:
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.

Author

Commented:
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.
Systems Administrator
Commented:
Is your SQL server is in the list of allowed SMTP relay hosts on your exchange server?

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
I will check on this in the morning and report back.

Author

Commented:
Thanks!
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.