Solved

SSRS report not being auto emailed to recipient after Exchange Upgrade

Posted on 2011-09-21
10
335 Views
Last Modified: 2012-05-12
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
Comment
Question by:manelson05
  • 6
  • 4
10 Comments
 
LVL 25

Expert Comment

by:TempDBA
ID: 36574280
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
 

Author Comment

by:manelson05
ID: 36575012
Where is report configuration located?
0
 

Author Comment

by:manelson05
ID: 36575192
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
 
LVL 25

Expert Comment

by:TempDBA
ID: 36575257
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
 

Author Comment

by:manelson05
ID: 36575392
Where would the report library be? I need to find the library then the report then create a bogus subscription, right?
0
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 

Author Comment

by:manelson05
ID: 36575526
Not sure on how I create the subscription
0
 

Author Comment

by:manelson05
ID: 36575693
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
 

Author Comment

by:manelson05
ID: 36576156
I found the subscriptions but do not see where to modify or resubmit.
0
 
LVL 25

Accepted Solution

by:
TempDBA earned 500 total points
ID: 36576209
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
 
LVL 25

Expert Comment

by:TempDBA
ID: 36581762
Did it help?
0

Featured Post

Do email signature updates give you a headache?

Do you feel like you are constantly making changes to email signatures? Are the images not formatting how you want them to? Want high-quality HTML signatures on all devices, including on mobiles and Macs? Then, let Exclaimer solve all your email signature problems today.

Join & Write a Comment

Suggested Solutions

Not sure what the best email signature size is? Are you worried about email signature image size? Follow this best practice guide.
This process describes the steps required to Import and Export data from and to .pst files using Exchange 2010. We can use these steps to export data from a user to a .pst file, import data back to the same or a different user, or even import data t…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

708 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

12 Experts available now in Live!

Get 1:1 Help Now