Print - How can I use Lotus Notes for SQL Mail?

A. Full credit for this entry goes to Ted Malone.

You have 2 options for Notes and SQLmail interoperability - without using SMTP, but we'll assume you want to go to Notes directly.

1) Use the standard NOTES client on the server
2) Use Microsoft Outlook and install the Notes Service

For option 1 :-

1) Create a mapping between the MSSQLSERVER and SQLSERVERAGENT NT account(s) and a Notes mailbox
2) Log on to the SQL Server as the MSSQLSERVER account (Note you cannot use LocalSystem)
3) Install the Notes MAPI Service
4) Install the Notes Client (Make sure you install Notes MAPI first, or it WILL NOT WORK!)
5) Install the latest MAPI dlls (MAPI32.DLL and MAPI.DLL in <NT>\SYSTEM32)
6) Launch Notes Client and Configure your Mailbox
7) Take note of the Notes MAPI profile name (Should be the same as your user, but you never know)
8) REBOOT the server (Weird, but you have to do it)
9) Log in as same account from above step 2
10) Launch SQL EM\
11) Configure SQLMail or SQLagentmail as appropriate
12) Log Off

For option 2 the steps are the same except step 3 is not needed and the mapi dll's (step 5) will already be there.

Hello The following is an article I got from SWYNK. It works fine but the only thing you got to watch is that you are logged in with thew same account as you use for your MSSQLServer and SQL Server Agent accounts (hi of course). Make sure as well that it uses a domain account. Lotus Notes and SQL Mail ------------------------ I've seen many questions on how to setup SQL Mail to use Lotus Notes, but have never found the answer. There have been many ideas, but none that seemed to work, at least easily. Working with our Lotus Staff, I've finally found a way that is easy to configure and easy to use. This was done on Windows NT 4.0 sp 5 with SQL Server 7. I think it will work just as well with 6.5, but I haven't tried it yet. Here it goes: 1. Install Microsoft Messaging - Using the Windows NT setup, install Microsoft Messaging on the database server. At this time, do not install any of the mail services, you will do this at later. Install Lotus Notes client - 2. Install the Lotus Notes client software, version 4.6.2 or newer, on the database server. You will need to have a Lotus Notes user created and setup on this system. If you installed the Notes client prior to installing MS Messaging, you will want to re-install Notes after Messaging is installed. There is a way around this, but let's keep it simple. 3. Add the Lotus Notes service to the database server's MS Messaging client and create a MS Messaging client. A/ Edit the Exchange Inbox properties. b/ A window will appear where you select what services you want to install. c/ Select Lotus Notes Mail only. Proceed to the next screen. When prompted for a password, enter the Notes password. d/ Accept defaults to completion. e/ Edit the Exchange Inbox properties again. f/ This screen will have three tabs: Services, Delivery, and Addressing. g/ In the Addressing tab, add the any Address Books you wish to include. 4. Next, configure SQL Mail to use the profile you just setup in MS Messaging that uses the Lotus Notes Mail service. This is just like setting up SQL Mail using Exchange. The fact that the Exchange client is going to transport over Lotus Notes Services is transparent to SQL Server. 5. Use the standard SQL Server supplied xp_sendmail command to generate the email. sample: exec master..Xp_sendmail 'john.doe@somewhere.com',@subject = 'sending mail', @message = 'is cool' Regards Carl Neirynck (MCSE,MCDBA)

I did exactly what it says here and was able to start the SQL mail with Lotus Notes. However, when I try to use xp_sendmail from QA it stay 'processing' forever! until I decided to cancel the instruction. But if I go to Jobs and set to send a mail when the job finish it will send it fine. Any help will be appreciated, Thanks, Ricardo.

How do you create amapping between MSSQLSERVER and SQLSERVERAGENT and Lotus Notes?

Would this be applicable for SQL Server 2000 ? I have have SQL2000 ,and i need to send mail via LOTUS (not configured as SMTP/PO3) .So i think your tips may help. Pleae advice more on this. this is very urgent, Thanks rajiv

Currently we are running SQL Server 2000 (enterprise) and Lotus Notes 6.5. Can I able to use Lotus Notes for SQL Mail. If so should I follow Option 1 How compatible SQL 2000 with Lotus Notes 6.5 If you could reply that would be great vveeraneni@nan.net Thanks, Ven