|
Home > Archive > MS SQL Server > December 2005 > SQL server SMTP mail
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL server SMTP mail
|
|
| Srikanth 2005-12-30, 8:23 pm |
| I am configuring SMTP mail on my SQL servers. I added all my pop3 account
infiormation. When i am sending an email using xp_sendmail, xp_send amil was
successfull, I am not getting messages. Then i stopped the mail services and
I opened outlook all these messages are in the out look there are not
trasfered to to my email. any idia , what 's going on, how can i resolve this
issue.
--
SQL serer DBA
| |
| Michael Hotek 2005-12-30, 8:23 pm |
| The e-mail is going to go into the outbox in the mail profile defined on the
SQL Server. They will only be sent if Outlook is open and automatically
sending messages. This was one of the main reason that SQLMail was
eliminated from SQL Server 2005 and replaced with Database Mail which is a
pure SMTP client.
--
Mike
Mentor
Solid Quality Learning
http://www. solidqualitylearning
.com
"Srikanth" < Srikanth@discussions
.microsoft.com> wrote in message
news:2E86C672-22C4-4988-A3B6- 125EDA5E396B@microso
ft.com...
>I am configuring SMTP mail on my SQL servers. I added all my pop3 account
> infiormation. When i am sending an email using xp_sendmail, xp_send amil
> was
> successfull, I am not getting messages. Then i stopped the mail services
> and
> I opened outlook all these messages are in the out look there are not
> trasfered to to my email. any idia , what 's going on, how can i resolve
> this
> issue.
> --
> SQL serer DBA
| |
| John Bell 2005-12-31, 7:23 am |
| Hi
You may want to read
http://support.microsoft.com/kb/263556/
Rather than relying on outlook you can use XPSMTP
http://www.sqldev.net/xp/xpsmtp.htm as an alternative.
John
"Srikanth" < Srikanth@discussions
.microsoft.com> wrote in message
news:2E86C672-22C4-4988-A3B6- 125EDA5E396B@microso
ft.com...
>I am configuring SMTP mail on my SQL servers. I added all my pop3 account
> infiormation. When i am sending an email using xp_sendmail, xp_send amil
> was
> successfull, I am not getting messages. Then i stopped the mail services
> and
> I opened outlook all these messages are in the out look there are not
> trasfered to to my email. any idia , what 's going on, how can i resolve
> this
> issue.
> --
> SQL serer DBA
|
|
|
|
|