Hi All ! I am trying to do a normal subscription of a report. i got the following error in status can any one plz help !!! Failure sending mail: The transport failed to connect to the server. --------------------------- Radhai Krish | Golden Age is no more far | --------------------------

Hi Radhai, You can view the following link. May be it helps. http://social.microsoft.com/Forums/en-US/crm/thread/a64b79b7-19f4-40c0-96bc-81b95766ec6d Thanks

yes me too got tht link in search... but our IT ppl say our SMTP being open will not restrict any services. So im really confused with the issue.. will all remote SMTP will allow all services ?? if not then it would able me to question our ppl... Any one had xperience in remote SMTP?? if im wrong please correct me Thanks !! --------------------------- Radhai Krish | Golden Age is no more far | --------------------------

hi i checked th following link, http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/08d565db-74d1-4930-901f-bafb81efe64f as the said solution i check the service 'SQL server Agent'. but that logged on as 'Local' if im right, i need to change tht 'log on as' value ? so i did changed the option to "This Account DOMAIN\Name password : <> Confirm Pwd : <> " but after doint so i got error in my reportserver Url as ' The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. (rsReportServerDisabled) Get Online Help Bad Data. (Exception from HRESULT: 0x80090005) ' So i changed again to Local.. i am getting status msg as 'Mail Sent to...' But no mail is received?? Can any one plz help me? how can i make run the server agent remotely?? Please Note i have SSRS installed in my local system (xp) where im trying to configure its url for report subscription. its enterprise edition only. Thanks! --------------------------- Radhai Krish | Golden Age is no more far | --------------------------

i am getting status msg as 'Mail Sent to...' But no mail is received?? Can any one plz help me? how can i make run the server agent remotely?? Please Note i have SSRS installed in my local system (xp) where im trying to configure its url for report subscription. its enterprise edition only. Kindly do help me if any one have had xperience in SSRS emailing reports subscription... --------------------------- Radhai Krish | Golden Age is no more far | --------------------------

Hi Radhai, Since the message indicates the subscription run successfully, we could check it via the Report Server Database ExecutionLog2 view. Log on your report server database within SQL Server Management Studio, select your Report Server database and query the ExecutionLog2 view to see if the subscription request is finished. If its status is rsSucess in the log entries, you should go to mail server to check if the report mail is generated and sent. thanks, Jerry

Jerry u r correct ! I did check the execution log, all the status are rsSucess only. Thanks for saying tht point.. Need to ask our IT ppl to check our SMTP server. Would be very grateful if u could say me How & what should i need to check in the mail server. As Our SMTP is remote server not being in our concern. im using gmail as my smtp... will our smtp any way needs configuration?? here is my rsreportserver.config 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\Pickup </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> kindly advice !! Thanks a Ton !!! --------------------------- Radhai Krish | Golden Age is no more far | --------------------------

Hi, Put your question "Would be very grateful if u could say me How & what should i need to check in the mail server. Our SMTP is remote server not being in our concern." at http://social.technet.microsoft.com/Forums/en-US/category/exchangeserver, which is dedicated to Exchange Server. thanks, Jerry

Fine ll do tht ! Could u say me is tht the above given config is correct ? Also plz say in case of using gmail as smtp. should our local smtp too has to be configured ? --------------------------- Radhai Krish | Golden Age is no more far | --------------------------

hi plz anyone reply... i am still struggling with it... I checked and confirmed that our SMTP is working well and not blocking any workflow.. our support guys saying that no logs been there with our smtp stating mail arrivals from my address especially for SSRS. But in the Report manager URL subscription the status is 'Mail sent' & in the execution log2 its 'rssuccess'.. Where might the wrong be ?? please any one advice...--------------------------- Radhai Krish | Golden Age is no more far | --------------------------

kindly give me a clue please help me... --------------------------- Radhai Krish | Golden Age is no more far | --------------------------

kindly give me a clue please...--------------------------- Radhai Krish | Golden Age is no more far | --------------------------

Hi Radhai, "in the Report manager URL subscription the status is 'Mail sent' & in the execution log2 its 'rssuccess'.." and "I checked and confirmed that our SMTP is working well and not blocking any workflow..". But your users still did not recieve the reports mail. This needs more in-depth technologies to handle it, and is out of our abilities. Please contact Microsoft customer services to solve this issue. If it is fixed, please kindly update it here. thanks, Jerry

Oh Sorry if i have bothered.. Fine..i tried each time for tht option only to let know Microsoft directly and was finally lead to this forum... will try to contact customer services and sure will let know the solution... Thanks!--------------------------- Radhai Krish | Golden Age is no more far | --------------------------

hi after setting the Relay in the SMTP properties to allow all computers, the mail started reaching the recipient inside our company. but not to any of the external ids.. As said by our IT guys we dont have exchange server in our company, do any one have any idea in this??? Thanks!--------------------------- Radhai Krish | Golden Age is no more far | --------------------------