OS - Windows 7 Enterprise (x64) Server - SQL Server 2008 My information is from this thread... http://social.msdn.microsoft.com/forums/en-us/sqlreportingservices/thread/7F0180BE-AE90-48A9-90E4-33355CEB8398 I have read on several threads that SSRS 2008 doesn't support SMTP servers, or any servers for that matter, that are remote and require authentication. I was wondering if this was true because I don't see the point in having it because most companies don't host their own mail server. Our company does not have a in-house mailing server. Google provides all that for us remotely. Why isn't cdoBasic SMTP authentication supported anymore? This is very frustrating that I cannot send report subscriptions through Google's SMTP because of this fault in the SSRS. Please tell me if my information is misleading or if there is a work around to this. Thank you!

Hi Spidermain50, In SQL Server Reporting Services, we can configure the server to deliver reports using a remote SMTP server. However, the SMTP should anonymous access authenticaon or NTLM authentication supported. If configuring E-Mail delivery to use a network SMTP server, which does not support either anonymous access authenticaon or NTLM authentication, the delivery will fail. In order to use a remote(network) sMTP server, which does not support the authentications described before, in Reporting Services, we can configure a local SMTP to deliver the mails. Install Local SMTP server On the Start menu, click Control Panel, double-click Add or Remove Programs, and then click Add/Remove Windows Components. In the Components list, click Application Server, and then click Details. In the Subcomponents of Application Server list, click Internet Information Services (IIS), and then click Details. In the Subcomponents of Internet Information Services (IIS) list, select the SMTP Service check box, and then click OK. Click Next. If you are prompted for the Windows CD or the network install path, follow the instructions. Click Finish. Configure Local SMTP server Go to “Manage my computer” - Internet Information Services - Default SMTP Virtual Server (right click) - Properties - Delivery - Advanced... Set Smart host = <The network SMTP server>. Delivery - Outbound Security: Select the authentication that is used for the remote SMTP server. In RSReportServer.config, set the following entries: Set <SMTPServerPickupDirectory> to the local pickup directory for your SMTP server, usually C:\Inetpub\mailroot. Set <SendUsing> to 1 Set <From> to a user that exists in AD If you have any more questions, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT

Hi Jin, I tried that solution on Windows XP and MS SQL Server 2005 but it doesn't work. What more I think there is no AD in WindowsXP. I wanted to ask if I need mail server, or IIS smtp virtual server is enough to send emails ?