Error sending email in ssrs 2012 subscription on local machine

Question

Error sending email in ssrs 2012 subscription on local machine

sej2008

SSCarpal Tunnel

Points: 4495
More actions
March 19, 2016 at 2:16 am

#325729

Hello Everyone,
I am working on SSRS 2012 on windows server 2008 R2 ENT edition.
I created and deployed report on my local machine and is running fine.
When I work with subscription it gives me error:
Failure sending mail: Failure sending mail.Mail will not be resent.
Althogh I have configured SMTP feature and also configured SMTP virtual server in IIS6 manager.
Steps that I have followed are as below:
Open IIS Manager
Right Click “IIS SMTP Virtual server”
Select “Properties”
Select the “Access” Tab
Click “Relay”
Make sure “All except the list below” is selected
You can add servers to this list that you want to block from sending mail to this server if you press “Add”
Click “OK”
Select the “Delivery” Tab
Click “Outbound Security”
Select “Basic Authentication”
Enter your Gmail account (i.e.srm2008@gmail.com)
Enter your Gmail password
Select “TLS encryption”
Click “OK”
Click “Outbound connections” and set TCP port to “587″
Click “OK”
Click “Advanced” and enter the Full-qualified domain name – this should be what you want this SMTP server to be called. If your server name is “SMTP” and your domain is “YOURDOMAIN.COM” then the entry should be “smtp.yourdomain.com”
here I have used my workgroup machine name and domain as smtp.gmail.com as I am not working in domain just a test server where sql database and reportserver is installed.[/b]
Enter “smtp.gmail.com” as the “Smart host”
Press “OK”
this below step i have not followed as I am using SSDT on same local machine where i deploy my report i.e http://localhost/reportserver.%5Bi%5D%5B/i%5D%5B/u%5D
Now configure the outbound email server in your application to use “gmail.yourdomain.com” and it should relay the email through Gmail.
Click on “OK” twice to complete the setup of the SMTP server.
---Further steps that I have followed is:
1)To configure Reporting Services to use virtual SMTP server. I used the Reporting Services Configuration Manager utility.
2)Type in the email address that will be shown as the sender when SSRS sends emails. (This may be over written by the remote SMTP server so check to see if this is the case. In this example the Google SMTP server will replace any address that you enter here with the email address of the account used to authenticate to it and send emails with.). In the “SMTP Server” textbox type the IP address that you selected for the virtual SMTP server.
here I have used my gmail account and smtp server i have given my machine IP address like 192.168.0.8[/b]
Further I have followed all the steps to set subscription for report by changing the datasource credential that needs to be stored in reportserver database and I am working as Administrator.
I created shared schedule also and checked SQL agent is running fine.
Later I changed the rsreportserver.config file also but still get error.
My file looks like below code:
<RSEmailDPConfiguration>
<SMTPServer>192.168.0.8</SMTPServer>
<SMTPServerPort>587
</SMTPServerPort>
<SMTPAccountName>
</SMTPAccountName>
<SMTPConnectionTimeout>
</SMTPConnectionTimeout>
<SMTPServerPickupDirectory>
c:\MyReportFolder
</SMTPServerPickupDirectory>
<SMTPUseSSL>
</SMTPUseSSL>
<SendUsing>1</SendUsing>
<SMTPAuthenticate>
</SMTPAuthenticate>
<From>sejalrm2014@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>
</DefaultHostName>
<PermittedHosts>
</PermittedHosts>
</RSEmailDPConfiguration>
In the above code IF I <SendUsing>2</SendUsing> ,<SMTPServerPort>25
</SMTPServerPort> and <SMTPServerPickupDirectory></SMTPServerPickupDirectory>then It shows subscription status as "Mail send to srm2008@gmail.com" but it does show any report emails in my inbox.
if anyone can guide me with this issue.What further needs to be done.
Thanks in advance

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

<SMTPServer>192.168.0.8</SMTPServer> is incorrect. YOUR local machine is not the SMTP server, you are not running an SMTP service.

you want smtp.googlemail.com in that value, which is the address for gmail.

setting up dbmail requires the same parameters, and i've got a handy screenshot of that.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

sej2008 SSCarpal Tunnel Points: 4495 More actions · Answer 2

thank you,I will try out your solution given by you.but one question when I have configured smtp feature from server manager in my os that is windows server 2008 R2,so I have my smtp service running on my local machine

so as per what I understand my local machine is also SMTP server,isn't it correct?

Lowell SSC Guru Points: 323518 More actions · Answer 3

sej2008 (3/21/2016)
thank you,I will try out your solution given by you.but one question when I have configured smtp feature from server manager in my os that is windows server 2008 R2,so I have my smtp service running on my local machine
so as per what I understand my local machine is also SMTP server,isn't it correct?

I'm not an expert on SMTP, but i've got a very good feel for it.

an SMTP service requires a lot of setup, ownership of a domain name, DNS record management, and the creation c-names like mail.sej2008.com or mail.lowell.com, configuration of mailboxes, and so much more;

nothing in your post says you've done that, making me think your SMTP service is an empty setup, that would not forward mail to the proper servers.

typically you go to the network guys,and they already have an exchange/office365 or some other solution already set up;

I hosted my own personal email for a while, and had two services for POP3 and SMTP running on a box; there's a good amount of setup involved.

the level of setup and detail to run your own SMTP server is what i don't see so far, and since you were going to use google mail: someone else has set it up, so you talk to THAT server, and not some intermediate server, it's pretty safe to say even if you had local SMTP, you were not setting up to use it.

if it were your local SMTP, you would be using a mailbox for your own hosted domain,and the server might forward email to outside domains, if the mail passed username and password to support AUTH, or was on a whitelist to forward mail.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!