troubleshooting Question

Need  Help with SQL 2008 R2 Reporting Services & MS Exchange

Avatar of rpajak1
rpajak1Flag for United States of America asked on
SSRSMicrosoft SQL Server 2008Exchange
1 Comment1 Solution681 ViewsLast Modified:
Hello Everyone...

I have a customer who asked me to install and configure SQL 2008 R2 Reporting Services.  His goal is to have scheduled reports emailed to him on a daily basis.

He  has an Exchange 2000 Server and he is not sure if he wants to migrate to Exchange 2010 or if he wants to drop the Exchange Server all together and use MIcrosoft Hosted Exchange services in the Cloud.

We did the research already and we found out that we cannot integrate SQL 2008 R2 Reporting Services with the Hosted Cloud Solution.  

One option is:  
My customer wants us to use the existing Exchange 2000 Server for a few weeks and after we get Exchange 2010 up and running, we could reconfigure Reporting Services to use the new Exchange Server.

Another possible (?) option:
My client pointed me to some links on the web and now he believes he can use *ANY* smtp server for SQL 2008 R2 Reporting Services to send reports. So he suggest we install a SMTP Server on the SQL server and use the SMTP Services on the localhost.  Then we don't have to install a Exchange Server and we can just use the MS Hosted Exchange Cloud Services.

I also need to find a link to show me how to configure SQL 2008 R2 Reporting Services from scratch for a novice.

Any help would be appreciated.

Sincerely

R

ASKER CERTIFIED SOLUTION
lcohan
Database Analyst
Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros