Setting of Sendmail in Sql Server

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Setting of Sendmail in Sql Server

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-01-25 : 09:15:24

Atul Chowdhory writes "To

Sql Guru

Currently i am using the Sql Server Procedure for some processing .. in which there is one requirement of sending email.
So i have used the xp_sendemail function.. but when ever i start the Mail service through this procedure "xp_startmail" it give following error...

Starting SQL Mail session...
Error: 17903, Severity: 18, State: 1
MAPI login failure..
Error: 17951, Severity: 18, State: 1
Failed to start SQL Mail session..

So could u please tell me what setting i have to do for using the send mail function in mine procedure..

Thanks

with Regards

from

Atul Chowdhory"

chadmat
The Chadinator

1974 Posts

Posted - 2002-01-25 : 11:38:20

There are a lot of reasons that you might be getting these errors, make sure to follow the steps in this article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q263556&id=263556&SD=MSKB

Also, check your default mail client, it has to be outlook, not outlook express.

-Chad

bryan99y
Starting Member

42 Posts

Posted - 2002-01-28 : 15:29:09

Ensure the Mail Client is working with the Mail Server.
Send email from Client to verify.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources