SQL 2000 Reporting Subscriptions to Outside Recipients

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

LVL 14
dfxdeimosAsked:
Who is Participating?
 
Steven WellsSystems AdministratorCommented:
Is your SQL server is in the list of allowed SMTP relay hosts on your exchange server?
0
 
Steven WellsSystems AdministratorCommented:
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
 
dfxdeimosAuthor 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.
0
 
dfxdeimosAuthor Commented:
I will check on this in the morning and report back.
0
 
dfxdeimosAuthor Commented:
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.