Problem with subscriptions.
Hi, My requirement is to send a report through email for which i tried making a subscription and schedule it. But somehow thats not working. When i want to see the 'last run' status of the subscription, i'm not able to view it. That tab remains blank and the status shows ' new subscription'. Not able to find out where the problem lies. One more thing is i wanted to try out the same thing through data driven subscription but i'm not able to see the 'new data driven subscription' tab in tne subscriptions page of the report. Please tell me how can i solve this problem. Thanks, Deepti
August 8th, 2008 5:52am

Hi Deepti, If the schedule for the subscription doesn't work, make sure SQL Server Agent is running. Data subscription is only available for SQL Reporting Services Enterprise editions. If you use any other editions, the data subscription feature doesn't support. If there are any more questions, please let me know.Thanks.
Free Windows Admin Tool Kit Click here and download it now
August 12th, 2008 4:08am

Hi Xiao-Min Tan, I checked out the version of my remotereporting services and it turned out to be a standard edition. So i think because of this i'm not able to run my subscriptions as emailing is not supported by standard edition. But on my local server i have enterprise edition installed and i'm trying to email my report to my id but i get the following error in my subscriptions page: Done: 1 processed of 1 total; 1 errors Please tell me what can i do for this error? Thanks, Deepti
August 12th, 2008 4:26am

Make sure that SQL Server Agent is running on your machine. and try creating a job and schedule that directly on your SQL Service. Check whether it is working or not.
Free Windows Admin Tool Kit Click here and download it now
August 12th, 2008 9:06am

Are you seeing any errors in the report server log file corresponding to this.
August 12th, 2008 4:50pm

Hi, This time the log file was generated and i get the following error in that: Failure sending mail: The transport failed to connect to the server. And one more thing i would like to add is that my SMTP server was actually not allowing me to send mails so i'm using the gmail SMTP server here i.e. smtp.gmail.com and trying to send the mail to my gmail id. Thanks, Deepti
Free Windows Admin Tool Kit Click here and download it now
August 13th, 2008 3:07am

Hey i did that and its running successfully but i dont see any mail.
August 13th, 2008 3:20am

Can you let me know your configuration. Can you post it here
Free Windows Admin Tool Kit Click here and download it now
August 13th, 2008 4:26am

u mean my rsserver config file?
August 13th, 2008 4:47am

No Configuration for your subsciption Post your mail settings here.
Free Windows Admin Tool Kit Click here and download it now
August 13th, 2008 4:49am

i have made a data driven subscription for emailing the report to me. my smtp server is smtp.gmail.com and my trying to mail my report to my gmail id. Following is the configuration: <Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider"><MaxRetries>3</MaxRetries><SecondsBeforeRetry>900</SecondsBeforeRetry><Configuration><RSEmailDPConfiguration><SMTPServer>smtp.gmail.com</SMTPServer><SMTPServerPort></SMTPServerPort><SMTPAccountName></SMTPAccountName><SMTPConnectionTimeout></SMTPConnectionTimeout><SMTPServerPickupDirectory>\\blr00005\emailedreports</SMTPServerPickupDirectory><SMTPUseSSL></SMTPUseSSL><SendUsing>2</SendUsing><SMTPAuthenticate></SMTPAuthenticate><From>dity.84@gmail.com</From><EmbeddedRenderFormats><RenderingExtension>MHTML</RenderingExtension></EmbeddedRenderFormats><PrivilegedUserRenderFormats></PrivilegedUserRenderFormats><ExcludedRenderFormats><RenderingExtension>HTMLOWC</RenderingExtension><RenderingExtension>NULL</RenderingExtension><RenderingExtension>RGDI</RenderingExtension></ExcludedRenderFormats><SendEmailToUserAlias>false</SendEmailToUserAlias><DefaultHostName></DefaultHostName><PermittedHosts></PermittedHosts></RSEmailDPConfiguration> Thanks, Deepti
August 13th, 2008 4:53am

Deepti, Change some of Settings like this and I am sure it is an issue with authentication to your smtp. Are you forwarding your gmail Username and password for authentication when you are trying to send an email. It is better to try with your local SMTP. Try to install SMTP server on the same machine where you are trying to send subscriptions for a trail. It will helps <Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider"> <MaxRetries>3</MaxRetries> <SecondsBeforeRetry>900</SecondsBeforeRetry> <Configuration> <RSEmailDPConfiguration> <SMTPServer>smtp.gmail.com</SMTPServer> <SMTPServerPort>587</SMTPServerPort> <SMTPAccountName>"your mail ID"</SMTPAccountName> <SMTPConnectionTimeout></SMTPConnectionTimeout> <SMTPServerPickupDirectory>\\blr00005\emailedreports</SMTPServerPickupDirectory> <SMTPUseSSL>True</SMTPUseSSL> <SendUsing>2</SendUsing> <SMTPAuthenticate>2</SMTPAuthenticate> <From>dity.84@gmail.com</From> <EmbeddedRenderFormats> <RenderingExtension>MHTML</RenderingExtension> </EmbeddedRenderFormats> <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats> <ExcludedRenderFormats> <RenderingExtension>HTMLOWC</RenderingExtension> <RenderingExtension>NULL</RenderingExtension> <RenderingExtension>RGDI</RenderingExtension> </ExcludedRenderFormats> <SendEmailToUserAlias>false</SendEmailToUserAlias> <DefaultHostName>gmail.com</DefaultHostName> <PermittedHosts></PermittedHosts> </RSEmailDPConfiguration>
Free Windows Admin Tool Kit Click here and download it now
August 13th, 2008 5:26am

sure. i'll try above mentioned settings and will keep u updated.
August 13th, 2008 5:32am

hey i tried these settings but still was not able to. I even tried with POP3 option in gmail but that also doesn't seem to work.
Free Windows Admin Tool Kit Click here and download it now
August 13th, 2008 7:37am

Deepti, I can Say Strongly that you have an authentication issue. I am unable to understand how you can login to your GMAIL ID without giving Password. That is why I am telling you to try with your local SMTP else You have an Option like sender Address in SMTP Configuration, there you can specify your Email Address and password.
August 13th, 2008 7:41am

Hi, can you clarify what your requirement here is. Do you want to use gmail smtp server or do you want to deliver to gmail account. If your requirement is to deliver to gmail account, the easiest way to do it is to configure your RS to drop e-mail to a local pick up directoryand run a local SMTP server to deliver to the gmail account. If your requirement is to use gmail smtp server: Reporting services doesnt support basic authentication to connect to SMTP servers, it supports only NTLM or Basic. What this means is, we do not support specifying a user id/password in the config directory to talk to a external SMTP server that requires authentication (I think gmail is such SMTP server). That might be the reason you are seeing errors with it. For this scenario, you need to configure a relay SMTP server in order to use e-mail subscriptions. Thanks
Free Windows Admin Tool Kit Click here and download it now
August 13th, 2008 7:03pm

Hi, My requirement is to send mail to my official id but my smtp server is not allowing it. Thats why i'm trying to use gmail id. We have to send the reports daily to the client via email so i'm just trying that. Have never explored emailing part of reporting services. But even gmail is not working. Can u guide me on this? Thanks, Deepti
August 14th, 2008 4:00am

Hi Deepti, You cannot access outside SMTP without authentication. So you cannot access GMail without Authentication and you cannot use your authentication details in reportserver config so try with your local SMTP without any authentication
Free Windows Admin Tool Kit Click here and download it now
August 14th, 2008 4:05am

Hi, This problem is solved on my remote report server. Now i'm able to run my subscriptions. The main problem was with the sql server agent. It was running under the local system because of which my subscriptions were not running on my remote report server. And when i made my sql server agent run under the domain account. it started working. Thanks to you all for helping me out. Thanks, Deepti
August 21st, 2008 2:33am

Hello Deepti, I am emailing you because I have a similar issue to yours and was hoping you could help me out. 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
Free Windows Admin Tool Kit Click here and download it now
September 1st, 2010 4:49pm

Did you get any solution to send an email using gmail without using SMTP relay server? Thanks!
May 23rd, 2012 10:26am

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

Other recent topics Other recent topics