Configuring SQL 2005 Database Mail

I am trying to configure Database mail to work with our Exchange server but the only setting that I see is for a SMTP server. I find it hard to believe that this won't work with Exchange. Has anyone got this to work with an Exchange server?

Thanks!
JohnYes it does work with an Exchange Server as long as your exchange server is config'd to support SMTP.

I'm no exchange expert so I can't help you do this but we test Database Mail with Exchange as one of the mail platforms.

-Euan

configuring smtp connection on dts in VS2005

I'm trying to send mail through DTS Send Mail Task in the final release of VS 2005 however i'm getting this error "Mailbox unavailable.The server response was:5.7.1 Unable to relay for <email adress>.

I do not have exchange server installed. The smtp adress is correct. So what could be the problem?

I appreciate your help

Thanks

Network issues

Incorrect address

DNS failure

Authentication failure

etc...

The list of things that it COULD be are endless. Presumably you think that the problem exists somewhere in SSIS. Have you removed SSIS from the equation and see if it works then?

There isn't really enough information in your post to diagnise what the problem may be.

-Jamie

|||Christina,
The error message you are receiving indicates that the mail server you are trying to send mail through does not allow relaying. This is the usual setup for mail servers to cut down on spammers sending email through legitimate mail servers.
I would contact the administrator of the mail server you are trying to attach to and see if he can setup relaying for your SSIS box or email account.
Larry

|||

has anything changed in the configuration of the ssis send mail task? because in the beta version (before i moved to the final release) it was sending normally without any errors.

i can ask the smtp provider to allow relaying but that would be risky as you said.

thanks and happy new year

|||

i checked with the mail server administrator and relaying from the email address i'm using is allowed. so it's not an issue of relaying.

i also tested sending a test email from command prompt using smtp commands and it sent the mail normally. however from sql i still get the relaying error.

any clue?

thanks

|||

problem is solved. i used a different smtp server and unchecked the "use windows authentication" in the smtp connection manager. i thought it wouldn't matter since i didnt have exchange server. but it seems to have counted.

thanks to all

Christina

Configuring Remote SMTP for Reporting Server

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

Configuring Remote SMTP for Reporting Server

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

Configuring Database mail with SMTP authentication

I try to configure database mail on SQL Server 2005 (June CTP)
All the services are running under the same domain account which has been also added to corporate Exchange server. When creating a database mail account on SQL Server, I check the "SMTP server requires authentication" check box and enter the account name and paassword. When trying to apply the changes I get the following error:
"An error occured during decryption (Microsoft SQL Server, Error 15466)"

Is there any workaround on this error?

Thanks.
Artem

Check this thread:

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1905071&SiteID=17

Configuring Database mail with SMTP authentication

I try to configure database mail on SQL Server 2005 (June CTP)
All the services are running under the same domain account which has been also added to corporate Exchange server. When creating a database mail account on SQL Server, I check the "SMTP server requires authentication" check box and enter the account name and paassword. When trying to apply the changes I get the following error:
"An error occured during decryption (Microsoft SQL Server, Error 15466)"

Is there any workaround on this error?

Thanks.
Artem

Check this thread:

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1905071&SiteID=17

Configuring an SMTP server in IIS

This is a multi-part message in MIME format.
--=_NextPart_000_0006_01C5E69B.ABEE7CE0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi,
I am trying Configure an SMTP server in IIS for use with Windows = SharePoint Services in Windows 2003 Server
However, when I go to Control Panel -> Administration Tools -> IIS, = there is no default SMTP server to configure.
The only options when you expand IIS are
1. Application Pools
2. Web Site
3. Web Service Extensions
There is no Default Virtual SMTP Server option.
How do I add this option.
What I am trying to do is Relay all outgoing mail to a certain IP = Address but I cannot do this
if no Default Virtual SMTP Server option appears.
Any ideas
Thanks
Sanjeev
--=_NextPart_000_0006_01C5E69B.ABEE7CE0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hi,

I am trying Configure an SMTP server in = IIS for use with Windows SharePoint Services in Windows 2003 Server
However, when I go to Control Panel = -> Administration Tools -> IIS, there is no default SMTP server to configure.

The only options when you expand IIS are
1. Application Pools
2. Web Site
3. Web Service Extensions

There is no Default Virtual SMTP Server = option.
How do I add this option.

What I am trying to do is Relay = all outgoing mail to a certain IP Address but I cannot do this
if no Default Virtual SMTP Server = option appears.

Any ideas

Thanks
Sanjeev



--=_NextPart_000_0006_01C5E69B.ABEE7CE0--SMTP is not installed by default, you need to install it. Add/Remove
Programs and then Window Components on the left. Application Server, details
then IIS , details
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Sanjeev" <sanjeev@.microsoft.com> wrote in message
news:OLrlqro5FHA.1028@.TK2MSFTNGP11.phx.gbl...
Hi,
I am trying Configure an SMTP server in IIS for use with Windows SharePoint
Services in Windows 2003 Server
However, when I go to Control Panel -> Administration Tools -> IIS, there is
no default SMTP server to configure.
The only options when you expand IIS are
1. Application Pools
2. Web Site
3. Web Service Extensions
There is no Default Virtual SMTP Server option.
How do I add this option.
What I am trying to do is Relay all outgoing mail to a certain IP Address
but I cannot do this
if no Default Virtual SMTP Server option appears.
Any ideas
Thanks
Sanjeev|||Hi Bruce,
I have checked these options and smtp service was already ticked.
I unticked and ticked it again and completed the wizard but still default
smtp virtual server still does not appear in
IIS manager in admistrative tools.
Thanks
Sanjeev
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eEaN%23Xt5FHA.2816@.tk2msftngp13.phx.gbl...
> SMTP is not installed by default, you need to install it. Add/Remove
> Programs and then Window Components on the left. Application Server,
> details then IIS , details
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Sanjeev" <sanjeev@.microsoft.com> wrote in message
> news:OLrlqro5FHA.1028@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I am trying Configure an SMTP server in IIS for use with Windows
> SharePoint Services in Windows 2003 Server
> However, when I go to Control Panel -> Administration Tools -> IIS, there
> is no default SMTP server to configure.
> The only options when you expand IIS are
> 1. Application Pools
> 2. Web Site
> 3. Web Service Extensions
> There is no Default Virtual SMTP Server option.
> How do I add this option.
> What I am trying to do is Relay all outgoing mail to a certain IP Address
> but I cannot do this
> if no Default Virtual SMTP Server option appears.
> Any ideas
> Thanks
> Sanjeev
>

Configuring a Report Server for E-Mail Delivery

Bruce
I am pretty much in the same boat I have setup a test reporting
services instance on a Windows 2003 box. I now want to setup the
WIndows SMTP server and make reporting services send emails to the
SMTP server running on Windows.
Your help would be highly appreciated if you can specify the steps in
setting up Windows 2003 SMTP server and making reporting services talk
to it.
Thanks
KarenI have not setup the SMTP server. I use Reporting Services ability to be a
client and have it send to an existing SMTP server. There should be no
difference with the setup for Reporting Services, it just needs a SMTP
server, regardless of where it is. So what you need to know is how to
install and setup Windows SMTP server. Two different things, Report Services
SMTP client support and SMTP server. One option once you have the SMTP
server working is you can have RS deposite the report in a directory that
then the SMTP server picks up and emails or you can have it send the report
to the SMTP server which then forwards it on its way. For SMTP Server help I
would check out a Windows 2003 newsgroup.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Karen Middleton" <karenmiddleol@.yahoo.com> wrote in message
news:a5fd468a.0501062053.763b670e@.posting.google.com...
> Bruce
> I am pretty much in the same boat I have setup a test reporting
> services instance on a Windows 2003 box. I now want to setup the
> WIndows SMTP server and make reporting services send emails to the
> SMTP server running on Windows.
> Your help would be highly appreciated if you can specify the steps in
> setting up Windows 2003 SMTP server and making reporting services talk
> to it.
> Thanks
> Karen