We help IT Professionals succeed at work.

SQL 2000 Reporting Subscriptions to Outside Recipients

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

Open in new window

Watch Question

Steven WellsSystems Administrator

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.


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
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


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


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.


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.