I am using the SQL server 2000 along with Microsoft Reporting Services. I need to configure SQLReporting services for sending reports through emails using subscription
services. I don't have any SMTP server located in my local network or on Reporting server. We are using external SMTP server for sending & receiving mails through outlook express. How to configure the RSReportServer.config file for the same?
If we refer documentation available in Reporting Service Books Online, it states that we
can configure using SMTPAuthenticate settings by using "SENDUSERNAME" & "SENDPASSWORD" in rsconfig file. But If We Refer the MSDN online it states SMTPAuthenticate authorization is not supported.
Please help us in matter to solve the problem. We are unable to send mails using reporting service by using the settings stated in the Reporting Service Books Online.
It gives error "The e-mail address of one or more recipients is not valid" due to relaying denied by mail server which requires authentication.
Please solve the following problems.
1. Whether it is possible to use SMTP server outside the network or not?
2. If yes what is the method of configuring SMTP services?
3. How can we send username & password to authenticate the user?
4. Send us sample RSReportServer.config if possible for the same.
Thanking you
I suppose no one wants to answer my question or no one knows the answer ? Well after the research i come to know that the my remote SMTP server do not allow relaying on server. So enabling relaying can solve the problem. But it can create SPAM mail problems.
I d't fine any method to send username & password to smtp server.Any body knows how to send user authorization & password to SMTP server for reporting service mails. ?
|||Hi,
I saw your post today when I was doing a little bit reseach about this problem. Because my server was keep giving me the same reply. I was able to sent e-mail someone in our domain but not the outside world.
Luckly I found the answer. You need to add some authentication details to send an e-mail.
Here is my SMTP e-mail function. I am sure you will spot the missing codes immediately
Public Function sendMail(ByVal strFromEmail As String, ByVal strToEmail As String, ByVal strSubject As String, ByVal strMessage As String) As Boolean
Try
Dim msg As New System.Net.Mail.MailMessage
Dim addressFrom As New System.Net.Mail.MailAddress(strFromEmail)
Dim addressTo As New System.Net.Mail.MailAddress(strToEmail)
msg.From = addressFrom
msg.To.Add(addressTo)
msg.Subject = strSubject
msg.Body = strMessage
Dim smtp As System.Net.Mail.SmtpClient = New System.Net.Mail.SmtpClient
smtp.Host = "MAIL HOST"
smtp.Port = 25
Dim basicAuthenticationInfo As New System.Net.NetworkCredential("USERNAME", "PASSWORD")
smtp.UseDefaultCredentials = False
smtp.Credentials = basicAuthenticationInfo
'smtp.Attachments.Add(New System.Web.Mail.MailAttachment("c:\pic1.jpg"))
smtp.Send(msg)
Catch ex As Exception
MsgBox(ex.Message)
Debug.Print(ex.Message)
End Try
End Function
