Confused Sending Order Confirmation

So, I've gone through the BOL walkthrough and all looks great however, I am confused about how to extend my application to send an order confirmation that contains an order header and order detail. I also have Shyam Pather's book but haven't seen this discussed yet. Does it make sense to do two inserts in my subscription? Something like "insert into orderedAlertHeader" and "insert into orderAlertDetail"? Can I create more than one table for the same subscription?

I think I've been looking at this for too long.

TIA

Ian

For those who are curious I think I've figured out a way to accomplish what I needed. I ended up creating an XML column on my alert table that I can load my detail into. My formatter then can do whatever I need it to.

I'll give an example if someone is interested.

Configuring SQLMAIL

Hi
I wanted to send an email through sql server 2000.Before sending i need to
configure a profilename in Sqlmail from enterprise mananger.
And i took profile name from controlpanel>mail
While entering MAPI profile name and click on test button i get the below
error
xp_test_mapi_profile:failed with mail error 0x8004011
I have below environment on my system
OS : windows xp with updated service pack
OutLook 2000 configured with exchange server
can u help me out from this problem or can u tell step by step process of
configuring
Hi
Login with the SQL Server Service Domain Account.
Setup the mail profile.
Logout
Login again and then select the profile you created earlier under the
Support Service > SQL Mail in EM. If it is not in the dropdown, the profile
is not correct.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"TreeView Custom" wrote:

> Hi
> I wanted to send an email through sql server 2000.Before sending i need to
> configure a profilename in Sqlmail from enterprise mananger.
> And i took profile name from controlpanel>mail
>
> While entering MAPI profile name and click on test button i get the below
> error
> xp_test_mapi_profile:failed with mail error 0x8004011
> I have below environment on my system
> OS : windows xp with updated service pack
> OutLook 2000 configured with exchange server
>
> can u help me out from this problem or can u tell step by step process of
> configuring
>
|||Hi,
I think information on this link will help, especially on the step by step:
http://msdn.microsoft.com/library/de...rverE-mail.asp
Thanks,
RdR
"TreeView Custom" <TreeViewCustom@.discussions.microsoft.com> wrote in
message news:9CF6600D-741C-4736-AC14-1955499FE8DE@.microsoft.com...
> Hi
> I wanted to send an email through sql server 2000.Before sending i need to
> configure a profilename in Sqlmail from enterprise mananger.
> And i took profile name from controlpanel>mail
>
> While entering MAPI profile name and click on test button i get the below
> error
> xp_test_mapi_profile:failed with mail error 0x8004011
> I have below environment on my system
> OS : windows xp with updated service pack
> OutLook 2000 configured with exchange server
>
> can u help me out from this problem or can u tell step by step process of
> configuring
>

Configuring SQLMAIL

Hi
I wanted to send an email through sql server 2000.Before sending i need to
configure a profilename in Sqlmail from enterprise mananger.
And i took profile name from controlpanel>mail
While entering MAPI profile name and click on test button i get the below
error
xp_test_mapi_profile:failed with mail error 0x8004011
I have below environment on my system
---
OS : Windows XP with updated service pack
OutLook 2000 configured with exchange server
can u help me out from this problem or can u tell step by step process of
configuringHi
Login with the SQL Server Service Domain Account.
Setup the mail profile.
Logout
Login again and then select the profile you created earlier under the
Support Service > SQL Mail in EM. If it is not in the dropdown, the profile
is not correct.
Regards
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"TreeView Custom" wrote:

> Hi
> I wanted to send an email through sql server 2000.Before sending i need to
> configure a profilename in Sqlmail from enterprise mananger.
> And i took profile name from controlpanel>mail
>
> While entering MAPI profile name and click on test button i get the below
> error
> xp_test_mapi_profile:failed with mail error 0x8004011
> I have below environment on my system
> ---
> OS : Windows XP with updated service pack
> OutLook 2000 configured with exchange server
>
> can u help me out from this problem or can u tell step by step process of
> configuring
>|||Hi,
I think information on this link will help, especially on the step by step:
ServerE-mail.asp" target="_blank">http://msdn.microsoft.com/library/d...erverE-mail.asp
Thanks,
RdR
"TreeView Custom" <TreeViewCustom@.discussions.microsoft.com> wrote in
message news:9CF6600D-741C-4736-AC14-1955499FE8DE@.microsoft.com...
> Hi
> I wanted to send an email through sql server 2000.Before sending i need to
> configure a profilename in Sqlmail from enterprise mananger.
> And i took profile name from controlpanel>mail
>
> While entering MAPI profile name and click on test button i get the below
> error
> xp_test_mapi_profile:failed with mail error 0x8004011
> I have below environment on my system
> ---
> OS : Windows XP with updated service pack
> OutLook 2000 configured with exchange server
>
> can u help me out from this problem or can u tell step by step process of
> configuring
>

Configuring SQLMAIL

Hi
I wanted to send an email through sql server 2000.Before sending i need to
configure a profilename in Sqlmail from enterprise mananger.
And i took profile name from controlpanel>mail
While entering MAPI profile name and click on test button i get the below
error
xp_test_mapi_profile:failed with mail error 0x8004011
I have below environment on my system
---
OS : windows xp with updated service pack
OutLook 2000 configured with exchange server
can u help me out from this problem or can u tell step by step process of
configuringHi
Login with the SQL Server Service Domain Account.
Setup the mail profile.
Logout
Login again and then select the profile you created earlier under the
Support Service > SQL Mail in EM. If it is not in the dropdown, the profile
is not correct.
Regards
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"TreeView Custom" wrote:
> Hi
> I wanted to send an email through sql server 2000.Before sending i need to
> configure a profilename in Sqlmail from enterprise mananger.
> And i took profile name from controlpanel>mail
>
> While entering MAPI profile name and click on test button i get the below
> error
> xp_test_mapi_profile:failed with mail error 0x8004011
> I have below environment on my system
> ---
> OS : windows xp with updated service pack
> OutLook 2000 configured with exchange server
>
> can u help me out from this problem or can u tell step by step process of
> configuring
>|||Hi,
I think information on this link will help, especially on the step by step:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnovba01/html/SQLServerE-mail.asp
Thanks,
RdR
"TreeView Custom" <TreeViewCustom@.discussions.microsoft.com> wrote in
message news:9CF6600D-741C-4736-AC14-1955499FE8DE@.microsoft.com...
> Hi
> I wanted to send an email through sql server 2000.Before sending i need to
> configure a profilename in Sqlmail from enterprise mananger.
> And i took profile name from controlpanel>mail
>
> While entering MAPI profile name and click on test button i get the below
> error
> xp_test_mapi_profile:failed with mail error 0x8004011
> I have below environment on my system
> ---
> OS : windows xp with updated service pack
> OutLook 2000 configured with exchange server
>
> can u help me out from this problem or can u tell step by step process of
> configuring
>

Configuring SQLAgent for sending email

Hi All,

I need some help in configure our SQL 2K & 2K5 servers to send notification on job failers. Have created operators on SQL 2k but when i try to do a test mail it fails saying mai session is not running. I go to properties of the Sql agent to turn on mail session but it is grayed out. Can someone please direct me to the steps I need to take when setting up sql server with email capability. Do I have to install office (outlook on the sql server box) in order for emailing to work?

Thanks in advance for your help.

Nats

On SQL 2000 servers, you will need a MAPI client installed (e.g., Outlook).

However, I recommend checking out the usage of xp_smtp_sendmail -an alternative to installing Outlook and all of its issues.

Mail –Sending
SQL 2000 - http://www.sqldev.net/xp/xpsmtp.htm
http://www.aspfaq.com/show.asp?id=2403

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