October 12, 2006 at 6:19 am
My company is using Lotus Notes instead of Microsoft exchange. We use SQL Server 2000 and window NT 2003. The engineer never installed microsoft exchange or ms messaging on that server.
I read a lot of articles about using Notes as SQL Mail but every article assumed the server had messaging or exchange. Right now I have to use xp_smtp_sendmail to send out email. It is fine until except when I create a job, I cannot use notification tab to send out email when the step fails. Instead when the step fails, I have to go to a step to use xp_smtp_sendmail to send out email.
I installed Lotus Notes client on the server that hosts the SQL Server so it created Notes MAPI client. If anyone knows how to set up Lotus Notes as SQL Mail without exchange and messaging, please let me know and I really appreciate it.
Thanks.
October 12, 2006 at 7:13 am
This article states "Microsoft does not support using SQL Mail to communicate with mail servers such as Lotus Notes, Lotus cc:Mail, or Novell GroupWise unless they are treated as POP3 servers." http://support.microsoft.com/kb/263556
See A6 here as well: http://support.microsoft.com/kb/311231
I am not experienced with Lotus Notes but have you tried configuring Outlook to connect to Notes using a POP3 account, not sur eif this is possible? Then you can just select the Outlook MAPI profile as usual.
ll
October 12, 2006 at 7:16 am
This should do the trick http://www.databasejournal.com/features/mssql/article.php/10894_3345091_2
October 13, 2006 at 8:17 am
We have the same environment at my company, using Lotus Notes. As previously mentioned, you can install the Outlook client on the server and configure a POP3 server, and then use that profile for SQL mail.
One problem I haven't been able to figure out yet is that on occasion the Outlook client will not send the e-mails but will queue them up. They don't get sent out until the server is rebooted; then I get all of them at the same time!
Another reason to upgrade to SQL Server 2005!
October 13, 2006 at 10:55 am
Michael,
Just curious, what does SQL Server 2005 do to fix this problem?
Thanks
October 13, 2006 at 10:59 am
SQL Server 2005 doesn't require an Outlook client; you can just specify an SMTP server to use for DBA mail.
October 13, 2006 at 12:46 pm
Michael,
I created the Lotus Notes profiile and used it in SQL Mail. When I tested it using xp_sendmail, it said 'Mail Sent' but I did not receive any email. So I rebooted the server just liked you said, still I got nothing.
I used window server 2003, outlook 2003 and Lotus notes 6.5.
When I created the profile, in the email window, I put down type = MAPI (Default). The data file I just copied the outlook data file and put it somewhere and named it LotusNotes.pst
Did I do anything wrong here ?
October 13, 2006 at 1:17 pm
Loner,
I had found this KB article about setting up SQL mail with an Internet mail server. If you look at the 'More Information' paragraph, it states that you shouldn't use Outlook 2002 for this purpose because it requires you to start the Outlook client on the server to send mail. I had run in to this problem, so we ended up installing the Outlook 2000 client on the server as the article suggests and it worked. It has something to do with the MAPI spooler running in-process in Outlook 2002 but out-of-process in Outlook 2000. Try logging on to the server with the account the Outlook 2003 profile is set to and start the mail client and see if it sends the e-mail.
I suspect this still may be an issue with Outlook 2003.
October 13, 2006 at 1:18 pm
Oops, would help if I posted the link to the article.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply