June 7, 2004 at 1:10 pm
Hi
First of all I hope that Yucon has a better system !
Our SQL Mail profile should be ok. But when we want to send :
Hi
Have a
EXEC master..xp_startmail
EXEC master..xp_sendmail
@recipients = 'jv@elecenter.be',
@message = 'test',
@subject = 'Order van een blocked dealer'
EXEC master..xp_stopmail
it doesn't work. Anybody has any idea ???
Kind regards
El Jefe
JV
June 7, 2004 at 1:48 pm
What is the error that you receive?
June 8, 2004 at 12:14 am
It simply doesn't work. The query analyzer is running for about 15 minutes. Then I kill the job.
Kind regards
Jef
JV
June 8, 2004 at 7:37 am
Don't bother with the xp_startmail, xp_sendmail will also start the mail session.
Try logging on to the server using the sql service account, then go into outlook, check the profile is ok, and send a test email to make sure that everything is working.
June 8, 2004 at 7:43 am
The crucial things are that the sql server service and the sql agent service be running under a domain service account. Your SQL Server must have connectivity to your Exchange server. Your SQL Server must have the Outlook client installed and whoever installs it should be logged on the server as the domain service account that is running SQL. Last, the Outlook profile must be created for that service account.
These articles are pretty good: http://support.microsoft.com/default.aspx?scid=kb;EN-US;263556, http://support.microsoft.com/default.aspx?scid=kb;EN-US;311231, http://support.microsoft.com/default.aspx?scid=kb;en-us;315886. Good luck!
June 8, 2004 at 7:52 am
Log in to Outlook using the id u've given to SQL Server agent. and try sending mails manually. If you can't, you have a problem with oulook itself. else you don't have a problem of oulook, need to check mapi setting.
June 8, 2004 at 8:16 am
I think the troubleshooting steps already given will help you isolate the problem.
As a side note, SQL 2005 (Yukon) will have an SMTP based mail solution which will eliminate the need for Outlook on your SQL Server and the associated problems of MAPI running in the SQL address space.
Regards,
Steve
Meddle not in the affairs of dragons, for you are crunchy and taste good with ketchup.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply