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.
End of Article
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)
Carl Neirynck September 19, 2000
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.
Ricardo Estevez June 22, 2001
Would this be applicable for SQL Server 2000 ?
Capri Li November 04, 2001
How do you create amapping between MSSQLSERVER and SQLSERVERAGENT and Lotus Notes?
george gopie December 19, 2003
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
gkrishn January 18, 2006 (Article Rating: )
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
vveeraneni@nan.net March 30, 2007 (Article Rating: )
You must be a registered user or online subscriber to comment on this article. Please log on before posting a comment. Are you a new visitor?
Register now
An often irreverent look at some of the week's other news, including some more Windows 7 sales momentum, some Sophos stupidity, Microsoft's cloud computing self-loathing, more whining from the browser makers, Zoho's "Fake Office," and much, much more ...
Let Your Users Reset Their Own Passwords: Free Download Try a 30 day free trial of Desktop Authority Password Self-Service – it provides an easy-to-use, robust system for allowing users to reset their own forgotten passwords or locked accounts.
Get Windows IT Pro & Mark Minasi’s Favorite Power Tools Guide Order Windows IT Pro now and get "More of Mark Minasi's Favorite Power Tools"--a in-depth guide to the most useful Windows commands --FREE with your paid order! Subscribe today, and save 58% off the cover price!
Deep Dive into VMware vSphere, eLearning Series Join John Savill to explore the major functionality capabilities of the vSphere virtualization platform, including identification of the changes from ESX 3.5.
)
)
Register
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)
Carl Neirynck September 19, 2000