SQL 2000 Reporting Subscriptions to Outside Recipients

Posted on 2009-02-09
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

Question by:dfxdeimos
    LVL 12

    Expert Comment

    by:Steven Wells
    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.
    LVL 15

    Author Comment

    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.
    LVL 12

    Accepted Solution

    Is your SQL server is in the list of allowed SMTP relay hosts on your exchange server?
    LVL 15

    Author Comment

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

    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Set up iPhone and iPad email signatures to always send in high-quality HTML with this step-by step guide.
    Find out how to use Active Directory data for email signature management in Microsoft Exchange and Office 365.
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now