SSRS email Subscription Not Working but local smtp is working

SQL SERVER EDITION- 2008 ENTERPRISE EVALUATION EDITION

Operating System- Window Server 2008 R2

I've Created Local Smtp to use gmailid for Subscription of SSRS Report by Email as we don't have an Exchange Server.


User this link to Create local SMTP

Studied few blogs that related it to agent service running under local system account, on my machine it was running on NT/NetworkService change it to Administrator of local Machine. Did same change for Database Engine of Service of SQL Instance.

FYI- My Machine is not in Domain, so used local administrator for giving rights to service mentioned above.

Below is the Screen Shot of rsreportserver.Config File

ERROR : on Report Manager


Below is report log on after time report was executed.

library!WindowsService_16!2b30!05/20/2015-13:19:05:: i INFO: Schedule 3374e590-8374-4360-b5da-d487eacb0417 executed at 05/20/2015 13:19:05.
schedule!WindowsService_16!2b30!05/20/2015-13:19:05:: Creating Time based subscription notification for subscription: ea7fc6ce-00df-4f6a-9050-e713986307ca
library!WindowsService_16!2b30!05/20/2015-13:19:05:: i INFO: Schedule 3374e590-8374-4360-b5da-d487eacb0417 execution completed at 05/20/2015 13:19:05.
library!WindowsService_16!2b30!05/20/2015-13:19:06:: i INFO: RenderForNewSession('/Subscription')
library!WindowsService_16!2b30!05/20/2015-13:19:06:: i INFO: Initializing EnableIntegratedSecurity to 'True'  as specified in Server system properties.
library!WindowsService_16!2b30!05/20/2015-13:19:06:: i INFO: Initializing SqlStreamingBufferSize to default value of '64640' Bytes because it was not specified in Server system properties.
library!ReportServer_0-24!1f08!05/20/2015-13:19:08:: Call to GetPermissionsAction(/Subscription).
library!ReportServer_0-24!2484!05/20/2015-13:19:08:: Call to GetSystemPropertiesAction().
library!ReportServer_0-24!1f08!05/20/2015-13:19:08:: Call to GetPropertiesAction(/Subscription, PathBased).
library!ReportServer_0-24!1f08!05/20/2015-13:19:08:: Call to GetSystemPermissionsAction().
library!ReportServer_0-24!2484!05/20/2015-13:19:08:: Call to ListSubscriptionsAction(/Subscription, null).
library!ReportServer_0-24!1f08!05/20/2015-13:19:08:: Call to GetPropertiesAction(/Subscription, PathBased).
library!ReportServer_0-24!2484!05/20/2015-13:19:08:: Call to GetSystemPropertiesAction().
library!WindowsService_16!2b30!05/20/2015-13:19:10:: i INFO: Initializing SnapshotCompression to 'SQL'  as specified in Server system properties.
library!WindowsService_16!2b30!05/20/2015-13:19:11:: i INFO: Initializing ChunkSegmentSize to default value of '32320' Bytes because it was not specified in Server system properties.
library!WindowsService_16!2b30!05/20/2015-13:19:11:: i INFO: Initializing ResponseBufferSizeKb to default value of '64' KB because it was not specified in Server system properties.
library!WindowsService_16!2b30!05/20/2015-13:19:11:: Using folder D:\Program Files\Microsoft SQL Server\MSRS10.SQLSVR2008_NEW\Reporting Services\RSTempFiles for temporary files.
library!WindowsService_16!2b30!05/20/2015-13:19:13:: i INFO: Initializing SessionTimeout to '600' second(s) as specified in Server system properties.
library!WindowsService_16!2b30!05/20/2015-13:19:13:: i INFO: Initializing EnableExecutionLogging to 'True'  as specified in Server system properties.
library!WindowsService_16!37e0!05/20/2015-13:19:43:: i INFO: Call to CleanBatch()
library!WindowsService_16!37e0!05/20/2015-13:19:43:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings.
library!WindowsService_16!37e0!05/20/2015-13:19:43:: i INFO: Call to CleanBatch() ends

Please Suggest if there's any requirement or step i'm left with.

PS: Local SMTP is working, i.e. i am able to receive email if i place an email.text file in C:\inetpub\mailroot\pickup

May 20th, 2015 3:58am

 

<SMTPServerPort>587 </SMTPServerPort>

Give Gmail port

https://support.google.com/mail/answer/13273?cbid=wl8yzeug2lob&src=cb&lev=topic

try for checking .

http://www.wikihow.com/Send-Email-Using-Telnet



Free Windows Admin Tool Kit Click here and download it now
May 20th, 2015 4:16am

Hi Dinesh,

No change after configuring port value and email is received if pasting a sample email.txt file in "C:\inetpub\mailroot\pickup"

Email.txt includes below text

From: mygmail.com
To: mygmail.com
Subject: Email test

This is the test body of the email.

May 20th, 2015 5:17am

can check from sql ?
Free Windows Admin Tool Kit Click here and download it now
May 20th, 2015 5:22am

Do you mean by checking ,sending email from  sp_send_dbmail store procedure 

or checking  logs for my susbcription in report Server database.

May 20th, 2015 5:29am

1) Try from MSSQL using sp_send_dbmail 

2) share log also

Free Windows Admin Tool Kit Click here and download it now
May 20th, 2015 6:00am

Able to Send Email from sp_Send_dbmail

Logs from MSDB database of Sent Status

IS there any other log you talking about ??

Another thing i am reading righ now, is it possible ?

May 20th, 2015 6:57am

It was seriously LOL.

I gave NetworkService user full control to mailroot folder residing in  C:\inetpub\ and

Vola email was sent from localsmtp.

I bet if someone has faced this problem and has find any solution like same.

Reason OF Solution - login context/User that is rendering report on ReportServer and creating an email template to throw it in pickup directory residing in **C:\inetpub\mailroot**  should be "**Network Service**"

Question/Doubt Left
Now the confusion left is can we change this user as my service account user i.e. local Administrator was having  full control on  mailroot folder but it was not working till i opted above mentioned solution.

Free Windows Admin Tool Kit Click here and download it now
May 21st, 2015 3:27am

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

Other recent topics Other recent topics