July 17, 2006 at 8:46 am
In my current environment I am running SQL Server 2000 on win2k3 cluster. And we use Lotus Notes as our email messaging system. Since I cannot install outlook client on my server is there a way to receive performance/ drive space related alerts from SQL Server? I believe SMTP can be used.. does anyone know how would that work?
thanks
shahab
July 17, 2006 at 8:50 am
You can install Notes client and have it be used for the SQL Mail. Notes client is MAPI compliant, which is what SQL Mail requires (not an Outlook client).
Mark
July 17, 2006 at 9:14 am
whats the difference between using SMTP or a MAPI compliant email client?
July 17, 2006 at 9:26 am
seems like for me to be able to get SQL Server alerts I would need a MAPI client. I dont think this can be done using SMTP.. or can it be?
July 17, 2006 at 9:31 am
SQL Mail service in SQL Server does not work with SMTP mail servers directly, it works with a MAPI email client application. I'm sure it's just a design decision at that time (late 90's). A MAPI client can send SMTP mail, or Exchange, or Notes, or Groupwise, etc.
In SQL Server 2005, Database Mail is using smtp mail, instead of MAPI.
Mark
July 17, 2006 at 11:05 am
Mark,
Could you post a reference or instructions on how to setup SQL Mail with Notes client?
Regards,Yelena Varsha
July 17, 2006 at 11:47 am
I don't have or remember what I used several years ago, but I found these by doing a quick google:
WindowsITPro: How Can I Use Lotus Notes for SQL Mail?
ITToolbox: Setting up SQL Mail with Lotus Notes Email System
Again, SQL Server is just performing MAPI calls. As long as you have a MAPI client (Outlook, Windows Messenging, Lotus Notes, Groupwise, or write your own), SQL Mail will work.
Mark
July 17, 2006 at 12:36 pm
Thanks Mark!
Regards,Yelena Varsha
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply