Using Google SMTP server (smtp.gmail.com) when configuring subscriptions unders SSRS 2008
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
September 2nd, 2010 11:45pm

Hi, Do the following steps to configure RS to drop to a local smpt server when you are using outside emails: Configure RS to drop to a local SMTP server 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 = “IP” or "smtp.gmail.com". Delivery - Outbound Security: select Windows Integrated Security, and enter credentials for your domain account. 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 Hope this helpfully, thanks, Jerry
Free Windows Admin Tool Kit Click here and download it now
September 6th, 2010 6:45am

Hi Jerry, Thank you for the info. Regards, SW
September 9th, 2010 1:19am

Hi, Do the following steps to configure RS to drop to a local smpt server when you are using outside emails: Configure RS to drop to a local SMTP server 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 = “IP” or "smtp.gmail.com". Delivery - Outbound Security: select Windows Integrated Security, and enter credentials for your domain account. 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 Hope this helpfully, thanks, Jerry Dear Jerry, Me too facing problem in sending mail using smtp server. iam able to send mail using our company's smtp to our company's id and not able to send to any other external ids... May i know wat u mean by installing Local smtp server? in my system there already xists our company's smtp server in the IIS , default server list. is tht enought? i did follow ur steps. But i am getting the following error, Failure sending mail: The filename, directory name, or volume label syntax is incorrect. Mail will not be resent could u plz say me whether the following rsconfig is correct? <RSEmailDPConfiguration> <SMTPServer>smtp.gmail.com</SMTPServer> <SMTPServerPort> </SMTPServerPort> <SMTPAccountName> </SMTPAccountName> <SMTPConnectionTimeout> </SMTPConnectionTimeout> <SMTPServerPickupDirectory> C:\Inetpub\mailroot </SMTPServerPickupDirectory> <SMTPUseSSL>false</SMTPUseSSL> <SendUsing>1</SendUsing> <SMTPAuthenticate> </SMTPAuthenticate> <From>name@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> plz let me know.. Thanks in Advance !! --------------------------- Radhai Krish | Golden Age is no more far | --------------------------
Free Windows Admin Tool Kit Click here and download it now
October 23rd, 2010 8:21am

After changing the pickUpDirectory adres i am getting my status to be mail sent to defined mail ids. But no mail is sent, i did followed http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/08d565db-74d1-4930-901f-bafb81efe64f but i am not able to get the SSRS Url Home page when i am logging in the SQL server Agent in Domain account...? please help !!! Thanks !--------------------------- Radhai Krish | Golden Age is no more far | --------------------------
October 23rd, 2010 10:59am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics