Sending SQL Mail
Hi,
I am using SQL Server 2005. I have configured my email on Database Mail. when I am trying to send email using xp_sendmail I am getting problem error as:
Msg 17925, Level 16, State 1, Line 0
xp_startmail: failed with mail error 0x80040111
I am using following sql statement
master.dbo.xp_startmail'myaccount','mypwd'
master
.dbo.xp_sendmail'tomail1@mail.co.in','test'where myaccount and mypwd is my password on my email profile.'tomail1@mail.co.in' is the destination email address..
thanks
[1332 byte] By [
Mohan1] at [2007-12-22]
The configuration should not matter, as this is a problem at authentication level. Look if the mail server needs an authenticated and allowed user. Otherwise the mail will not be sent and an error will be thrown. Try to write an email using telnet to see of that works.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
Since you are using SQL server 2005, did you try
sp_send_dbmail. May be that can avoid your problem.
Hi,
I would first figure out why the mail engine is not working as it was set up. use the telnet commands to try sending an email with the specific account you are using for SQL Server, do something like the following:
telnet servername 25 //Which is the SMTP port<return>
helo<return>
Mail From:YourAddressyou areusing for xp_send_dbmail<return>
rcpt to:Recipient@Some@DOmain.com<return>
Data <return>
(Two returns)
HTH, Jens Suessmeyer-
http://www.sqlserver2005.de
