xp_sendmail does not send the mail

Hot Topic

MSRS + Fit to Page
Performance of aggregation functions
Modify the expression to be valid
Database.EnumObjectPermissions throws InvalidCastException
Query the Full-Text Words List?
Possible bug with excel export
Is there such a thing as Data Driven Report Cache?
Replication failed after restore
unable to log in [MSDE2000]
Is SQL Server 2005 Express Edition with Advanced Services FREE ????

SQL Server

Retrieving DefaultConstraint property of a Table column is too slow
DataSet Filter
Database Mail Fails For SQL Server Agent Jobs
convert int to money without decimal and cents
Attribute Relationships
Reporting Services Error After Formatting Report
Convert a sql express to mysql
Merge Replication and Snapshot Isolation
Adding datetime fields
trigger calls stored procedure- sometimes?

xp_sendmail does not send the mail

Hi,

I have a Microsoft 2003 Server, with SQL Server Standard Edition 8.00.760(SP3) installed.

I am using Microsoft Outlook 2002 (10.2627.2625) like my default mail and I have defined a Outlook profile "AutoSend" to use with SQL Mail with a email account POP3 configured.

In the Enterprise Manager, I assigned and tested this profile in the SQL Mail settings. It was fine.

In Fact, when I send a mail with xp_sendmail to my email account, it execute and display the messages: Mail sent.

But, the mail never was sent, it was in the outbox.

How Can I configure it to send mail

Note:

I don't have a Exchange Mail Server. I dont have an Active Directory. The user is local user for the server.




Answer this question

xp_sendmail does not send the mail

  • Super Iain

    Actually you can't use either the SMTP or POP3 by themselves, SQLMail requires extended mapi as an api for profile management and other stuff, the only (supported way) of getting extended MAPI is by installing outlook. However in outlook Xp and later the SMTP spooler(which is what is used when you send smtp mail as opposed to exchange mail) was moved into outlook.exe as opposed to being part of a .dll that could be launched by sqlmail, hence sometimes there is a problem where smtp mail does not get spooled by mapi unless outlook.exe is running under the right perms etc.

  • Tony_

    You have config'd pop3 for the account, have you also config'd SMTP for send If so try starting outlook on the machine and then sending mail from SQL Server

  • manny hall

    if i'm not mistaken Windows 2k3 has its own mail server

    maybe you should exploit this feature.

    sql server 2000 requires a MAPI compliant mail account

     



  • justStarting

    Randall,

    Did you ever get this one solved I have pretty much the same setup and am experiencing the same problem. This is working correctly in my test environment but not in production. The two appear to be identical but it's still failing on the one. Any other suggestions

    Thanks,

    Matt

  • mancroft

  • xp_sendmail does not send the mail
Answer this question