SMTP mail issue

Question

Post reply

SMTP mail issue

SQL Galaxy

One Orange Chip

Points: 29472
More actions
August 10, 2009 at 5:00 am

#95752

I done following steps for configure via SMTP mail notification
1. xpsmtp80.dll - download and placed in Bin folder this path C:\Program Files\Microsoft SQL Server\MSSQL$BKUPEXEC\Binn
2. exec sp_addextendedproc 'xp_smtp_sendmail', 'xpsmtp80.dll'
exce the above command in master databse,
3. grant execute on xp_smtp_sendmail to public
Finally exec the below script, written value is 1, so if value 0 is success
declare @rc int
exec @rc = master.dbo.xp_smtp_sendmail
select @rc
Further what should go for configure mail notification and how to troubleshoot?
Thanks

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

your script is missing parameters for the call:

http://www.sqldev.net/xp/xpsmtp.htm#Usage

here's an example on the syntax:

- ************************************************************************

-- more comprehensive example

-- ************************************************************************

declare @rc int

exec @rc = master.dbo.xp_smtp_sendmail

@FROM = N'MyEmail@MyDomain.com',

@FROM_NAME = N'Joe Mailman',

@TO = N'MyFriend@HisDomain.com',

@cc = N'MyOtherFriend@HisDomain.com',

@BCC = N'MyEmail@MyDomain.com',

@priority = N'HIGH',

@subject = N'Hello SQL Server SMTP Mail',

@message = N'Goodbye MAPI, goodbye Outlook',

@type = N'text/plain',

@attachments= N'c:\attachment1.txt;c:\attachment2.txt',

@server = N'mail.mydomain.com'

select RC = @rc

go

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 2

Thanks for your reply

It was woking fine,

One more question?

How to create smtp mail account not in POP3? we are using only smtp.

I could tried but it was not hope.. the following error display

Emailing report to operator 'sqlmailsend'

[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 18025: [Microsoft][ODBC SQL Server Driver][SQL Server]xp_sendmail: failed with mail error 0x80004005thanks

Here xp_sendmail: i could not get, but smtp using by xp_smtp_sendmail only.

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 3

Thanks for your reply

It was woking fine through QA,

One more question?

How to create smtp mail account not in POP3? we are using only smtp.

I could tried but it was not hope.. the following error display

Emailing report to operator 'sqlmailsend'

[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 18025: [Microsoft][ODBC SQL Server Driver][SQL Server]xp_sendmail: failed with mail error 0x80004005thanks

Here xp_sendmail: i could not get, but smtp using by xp_smtp_sendmail only.

Pl can anyone suggestion me, what exact problem?

thanks.

Lowell SSC Guru Points: 323518 More actions · Answer 4

I googled for the specific error you said you are getting, and couldn't find anything specific;one post said they simply stopped and started their SQL service and agent, adn that fixed their issue., but I think we need more information.

as far as "How to create smtp mail account not in POP3? we are using only smtp."

I'm thinking you are not really familiar with mail servers.

SMTP and POP3 are two protocols that every mail server supports.

SMTP is used to send mail TO the server.

POP3 is used to get mail FROM the server.

If you don't want anyone to be able to pickup email from your server, you would disable that part of the service, or block the port , or something like that to prevent access....but all those things are outside of SQL Server.

the dll you are using is just a way for SQL Server to be able to use the SMTP services on a mail server. The DLL does not support getting mail FROM the mail server.

maybe you should explain exactly what you mean...there might be a language or translation error here.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 5

Thank you for reply.. Now i got clear idea about mail server.

I had created profile through control panel->

creatting email account as below.

1. User Info

user name - ananda

Email-address - ananda.murugesan@ril.com

2. server Info

1. Incoming mail server pop3 - here i mention local server name

2. Outgoing mail server(smtp) - here smtp ip address

3 Logon info

username - ananda.murugesan

pw - strong pw

Finally i tested with test accounts - here one task failed

task name is Log onto incoming mail server(pop3) - failed and rest all task status completed.

I got test mail from server

This is an e-mail message sent automatically by Microsoft Office Outlook's Account Manager while testing the settings for your POP3 account.