• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 350
  • Last Modified:

SSRS report not being auto emailed to recipient after Exchange Upgrade

We recently upgraded our mail server form Exchange 2007 to Exchange 2010.
A SSRS report normally runs every tuesday and email this report to a specific user.
Current SQl is 2005 and We have Exchange 2010 Std running on Server 08 R2

What has changed, what do I need to do to restore receiving this report?
0
manelson05
Asked:
manelson05
  • 6
  • 4
1 Solution
 
TempDBACommented:
Do the proxy mail server address a/c where the email is requested for is changed?

I mean to say can you check in report configuration for email property and the a/c given is same in the exchange server?
0
 
manelson05Author Commented:
Where is report configuration located?
0
 
manelson05Author Commented:
I went in and looks at configuration the account was deleted so I used SA to authenticate, also updated the serrver name.

Is it possible to force run the report to make sure it worked?
0
Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

 
TempDBACommented:
yeah. just create a dummy subscriptiojn to an earlier published report and schedule it to run after 5 minutes. If it runs and you the the report mail, it means its working.
0
 
manelson05Author Commented:
Where would the report library be? I need to find the library then the report then create a bogus subscription, right?
0
 
manelson05Author Commented:
Not sure on how I create the subscription
0
 
manelson05Author Commented:
How do I do this:
"just create a dummy subscriptiojn to an earlier published report and schedule it to run after 5 minutes. If it runs and you the the report mail, it means its working. "
0
 
manelson05Author Commented:
I found the subscriptions but do not see where to modify or resubmit.
0
 
TempDBACommented:
1. Click on report manager i.e. go to the reporting page
2. Click on any report -> Go to subscription tab
3. Click on new subscription
4. Add a new subscription.

The pages will somewhat look like the screenshots in the below link:-

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27319967.html
0
 
TempDBACommented:
Did it help?
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.

Join & Write a Comment

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

  • 6
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now