Hello All, I have read thru numerous posts and have reviewed several links with no luck. I am trying to use gmail smtp servers (smtp.gmail.com) to configure SSRS 2008 to send email. It's running on Server 2003 Standard SP2. No Exchange server, we use gmail. Error message I receive is "Failure sending mail: The report server has encountered a configuration error. Mail will not be resent." Here is a copy of my RS Email Config: <Configuration> <RSEmailDPConfiguration> <SMTPServer>smtp.gmail.com</SMTPServer> <SMTPServerPort></SMTPServerPort> <SMTPAccountName></SMTPAccountName> <SMTPConnectionTimeout> </SMTPConnectionTimeout> <SMTPServerPickupDirectory> </SMTPServerPickupDirectory> <SMTPUseSSL></SMTPUseSSL> <SendUsing>2</SendUsing> <SMTPAuthenticate></SMTPAuthenticate> <From>myemailaddress@gmail.com</From> <EmbeddedRenderFormats> <RenderingExtension>MHTML</RenderingExtension> </EmbeddedRenderFormats> <PrivilegedUserRenderFormats> </PrivilegedUserRenderFormats> <ExcludedRenderFormats> <RenderingExtension>HTMLOWC</RenderingExtension> <RenderingExtension>NULL</RenderingExtension> <RenderingExtension>RGDI</RenderingExtension> </ExcludedRenderFormats> <SendEmailToUserAlias>True</SendEmailToUserAlias> <DefaultHostName>gmail.com</DefaultHostName> <PermittedHosts> </PermittedHosts> </RSEmailDPConfiguration></Configuration> Any help would be greatly appreicated! Regards, Dave

Hello All, I have read thru numerous posts and have reviewed several links with no luck. I am trying to use gmail smtp servers (smtp.gmail.com) to configure SSRS 2008 to send email. It's running on Server 2003 Standard SP2. No Exchange server, we use gmail. Error message I receive is "Failure sending mail: The report server has encountered a configuration error. Mail will not be resent." Here is a copy of my RS Email Config: <Configuration> <RSEmailDPConfiguration> <SMTPServer>smtp.gmail.com</SMTPServer> <SMTPServerPort></SMTPServerPort> <SMTPAccountName></SMTPAccountName> <SMTPConnectionTimeout> </SMTPConnectionTimeout> <SMTPServerPickupDirectory> </SMTPServerPickupDirectory> <SMTPUseSSL></SMTPUseSSL> <SendUsing>2</SendUsing> <SMTPAuthenticate></SMTPAuthenticate> <From>myemailaddress@gmail.com</From> <EmbeddedRenderFormats> <RenderingExtension>MHTML</RenderingExtension> </EmbeddedRenderFormats> <PrivilegedUserRenderFormats> </PrivilegedUserRenderFormats> <ExcludedRenderFormats> <RenderingExtension>HTMLOWC</RenderingExtension> <RenderingExtension>NULL</RenderingExtension> <RenderingExtension>RGDI</RenderingExtension> </ExcludedRenderFormats> <SendEmailToUserAlias>True</SendEmailToUserAlias> <DefaultHostName>gmail.com</DefaultHostName> <PermittedHosts> </PermittedHosts> </RSEmailDPConfiguration></Configuration> Any help would be greatly appreicated! Regards

Hi Dave, In SQL Server Reporting Services, we can only use a remote SMTP server, which is anonymous access authenticaon or NTLM authentication supported, to deliver reports. In this case, we can try using any of the following workarounds to configure Reporting Services to use Google SMTP server: Use a local SMTP server to deliver reports instead of the Google SMTP server Use a local SMTP server to deliver the mails to the Google SMTP server Implementing your own delivery extension to use the Google SMTP server In order to deliver the mails to the Google SMTP server using local SMTP server, we can follow these steps: Install Local SMTP server a. On the Start menu, click Control Panel, double-click Add or Remove Programs, and then click Add/Remove Windows Components. b. In the Components list, click Application Server, and then click Details. c. In the Subcomponents of Application Server list, click Internet Information Services (IIS), and then click Details. d. In the Subcomponents of Internet Information Services (IIS) list, select the SMTP Service check box, and then click OK. e. Click Next. If you are prompted for the Windows CD or the network install path, follow the instructions. f. Click Finish. Configure Local SMTP server a. Go to “Manage my computer” - Internet Information Services - Default SMTP Virtual Server (right click) - Properties - Delivery - Advanced... b. Set Smart host = <The network SMTP server>. c. Delivery - Outbound Security: Select the authentication that is used for the remote SMTP server. d. 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 For more information, please see: Implementing a Delivery Extension: http://msdn.microsoft.com/en-us/library/ms154050.aspx If you have any more questions, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT

Hi Jin: Regarding 1. Install Local SMTP Server and 2. Configure Local SMTP Server, how is this done on Windows 7 Professional Edition and IIS 7.0?