I’ve been tasked to look into making a MS SQL server send mail through our Domino server and on to a variety of recipients.
Has anybody actually made this combination work? If so, how?
I’ll await your reply.
Subject: SMTP Mail
Can SQL Server send messages in SMTP format? Is your Domino server set up to accept messages from the Internet? If so, then address the SQL Server messages just like you would if you were addressing them from the Internet. If you want the messages to go to several recipients, use multiple addressees. Or address the messages to a Group in the Domino Directory to which you’ve assigned an Internet address.
Subject: SQL server and Domino email
The SQL Server can’t send SMTP Emails directly.I have installed Outlook on the SQL Server machine (but only because I couldn’t get it to work without Outlook) and configured Outlook, so that it uses our Domino Server as SMTP mail-out server.
Then I have configured the SQL Server Agent to use the MAPI Profile created by Outlook, but I have to configure it using the SQL Enterprise Manager on the SQL Server machine, remote it doesn’t work out, because on my machine I don’t have Outlook, so I couldn’t set the MAPI settings in the Enterprise Manager.
Now the SQL Server is able to send me mails if jobs fail etc.
In this simple workaround, you can only sent mail, the SQL Server can’t receive mails, but I don’t need it.
Maybe using Domino Access for Microsoft Outlook would make it easier, but it works for me, so I don’t touch it.
Andreas Hoster
Subject: RE: SQL server and Domino email
Thanks Andreas.
I guess that you meant to say that you couldn’t get it to work with the Notes client.
Is there anything special to copnfigure with Enterprise SQL manager or SQL Server Agent?
(I’m not a SQL person).
Subject: RE: SQL server and Domino email
A little bit late, but to much work and easter holiday …
Yes, you guess correct, I didn’t get it working with Notes.
In the SQL Server Agent Properties, you have to select the right MAPI profile, thats all.
Andreas Hoster