Solved

SSRS report not being auto emailed to recipient after Exchange Upgrade

Posted on 2011-09-21
10
340 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
Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

 
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
 

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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Following basic email etiquette rules will help you write a professional email and achieve a good, lasting impression with your contacts.
A list of top three free exchange EDB viewers that helps the user to extract a mailbox from an unmounted .edb file and get a clear preview of all emails & other items with just a single click on mailboxes.
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…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

821 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