March 30, 2007 at 3:16 pm
I have created an OUTLOOK Profile on SQL Server box and configured to use that profile for SQL Mail. I can use xp_sendmail to send the mail and get a confirmation message "Mail Sent". However this message never get delivered to the recepient mail box.
I can use the outlook to send mail to the same recepient and the mail is delivered immedaitely. What am I missing here. Bellow is the summary of my SQL Mail configuration.
Starting SQL Mail test
user is logged into SQL Server as sa
Default mail client is Microsoft Outlook
----
8.00
SQL Server is running under account sqlsvc@unext.com
Testing MAPI profile : sqlsvc
Testing MAPI profile : sqlsvc succeeded
SQL Mail session started.
Start mail using MAPI profile : sqlsvc
succeeded
Stopped SQL Mail session.
Stop mail using MAPI profile : sqlsvc
succeeded
Finished SQL Mail test
April 2, 2007 at 1:51 am
Reverse your test, always leave the SQLMail Started, your test is leaving it Stopped.
This is the main problem with SQLMail, the connection between SQLMail and Exchange is persistant, restarting the Exchange services or server is enough to break SQL Mail's connection. The SQLMail Stop and Start is required to recover from this state.
When used in a Job, SQL Mail connectivity failures will hang the Job until a human decides to Cancel the Job processing.
Andy
April 2, 2007 at 8:14 am
Also make sure you are using Outlook 2000 and not 2002, 2003, or XP. The newer versions don't create a MAPI profile that can be started without an interactive login. A quick search on support.microsoft.com will give you the details.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply