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.