SSRS report mail subsription is failing.

Hi All,

I have one SSRS report which is deployed in my local report server. I need to activate email subscription for the same. I have given my outlook email address and SMTP server which is copied from outlook settings to Report configuration manager. Then I have created a mail account and profile in sql server. I made the profile as public and default one. I have chosen basic authentication and provided my windows account and password for SMTP authentication. Port number is 25 which was given there as default. SSL was not ticked. Then I have tried with the below sp.

EXEC msdb.dbo.sp_send_dbmail

@recipients='julie.sam@test.com'

 ,@subject='test'

,@body='test'

Everything worked fine. I have got the mail also. Then I tried to create a mail subscription for the deployed report on my report server. I have scheduled it also. But I'm getting error message. Then searched in net and read somewhere that we are supposed to use windows authentication for SMTP. Then I changed the mail account to use windows authentication for SMTP. Even then also I'm getting the same error given below.

Failure sending mail: The SMTP server requires a secure connection or the
client was not authenticated. The server response was: 5.7.1 Client was not
authenticatedMail will not be resent.

I have noticed another issue.

Because of the above error, I have chosen to use the secure connection (SSL) in the mail account. Also, SMTP authentication is Basic Authentication. I am not able to send email from database itself after checking the secure connection option. I was able to send mail from database(by using the [proc dbo.sp_send_dbmail) when unchecking Secure connection option.  

I'm getting the below error when running this query

SELECT

*FROMmsdb.dbo.sysmail_event_logorderbylog_datedesc

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 6 (2015-04-22T17:45:22). Exception Message: Cannot send mails to mail server. (The remote certificate is invalid according to the validation procedure.).
)

Please suggest

Regards,

Julie



April 22nd, 2015 10:47am

See if this helps

https://saravananarumugam.wordpress.com/2012/04/30/the-smtp-server-requires-a-secure-connection-or-the-client-was-not-authenticated-the-server-response-was-5-7-1-client-was-not-authenticated/

Also check SSRS config

https://msdn.microsoft.com/en-us/library/ms345234.aspx

If still it doesnt work see if you can turn on anonymous authentication in SMTP server

Free Windows Admin Tool Kit Click here and download it now
April 22nd, 2015 11:04am

Hi Visakh,

Thanks for the response. It does not work for me..

April 22nd, 2015 12:16pm

Hi Visakh,

Thanks for the response. It does not work for me..

WHat about enabling anonymous login in SMTP?
Free Windows Admin Tool Kit Click here and download it now
April 22nd, 2015 12:21pm

Hi Visakh,

Thanks for the response. It does not work for me..

WHat about enabling anonymous logi
April 22nd, 2015 12:25pm
Make sure the email server (Exchange?) is configured to allow email relay from the report server.
Free Windows Admin Tool Kit Click here and download it now
April 22nd, 2015 1:22pm
Make sure the email server (Exchange?) is configured to allow email relay from the report server.

Hi Ben,

How can I ensure that?


April 22nd, 2015 2:07pm

Make sure the email server (Exchange?) is configured to allow email relay from the report server.

Hi Ben,

How can I ensure that?



From the Exchange server system manager go into the SMPT virtual server (under administrative groups)... find the SMTP server, right click and select properties.  Then under the Access tab there should be a 'relaying' button.  Check the setting and make sure the IP address of the report server is granted relay permission.
Free Windows Admin Tool Kit Click here and download it now
April 22nd, 2015 2:24pm

Make sure the email server (Exchange?) is configured to allow email relay from the report server.

Hi Ben,

How can I ensure that?



From the Exchange server system manager go into the SMPT virtual server (under administrative groups)... find the SMTP server, right click and select properties.  Then under the Access tab there should be a 'relaying' button.  Check the setting and make sure the IP address of the report server is granted relay permission.

Hi Ben,

I am using Outlook 2013. I could not find Exchange server in my system.

April 22nd, 2015 2:35pm
You are sending email to an SMTP server.  That server has to be setup to allow email relay from your reporting services server.  Where is the SMTP server?
Free Windows Admin Tool Kit Click here and download it now
April 22nd, 2015 2:52pm

HI All,

I could find the real issue here. I have given the exchange server name which I got from my outlook account to set up mail account and also in report configuration. But, the SMTP server name was different from this. I got the right SMTP server name from a friend. Now, the issue is resolved. But, still I am not understanding how come the SMTP server name is different from exchange server name..? are they different..?I could not find this SMTP server name in the account settings of my outlook account also.

April 23rd, 2015 7:01am

Hi Julie,

I had face thsi type of problem.

First check you can able to ping telnet SMTP server with 25 

once done then try to send email from CMD which will you using following link.

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

Any query Let me know.


Free Windows Admin Tool Kit Click here and download it now
May 5th, 2015 3:33am

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

Other recent topics Other recent topics