Sql Mail and Lotus Notes

Question

Post reply

Sql Mail and Lotus Notes

JM-92548

Ten Centuries

Points: 1108
More actions
November 29, 2005 at 12:51 pm

#90937

Can we use Sql Mail with Lotus Notes?
In the server properties I cant get the sql mail to choose a profile to use.
But the documentation says it can use any SMPT or POP3 system

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

David A. Long SSCrazy Eights Points: 8421 More actions · Answer 1

You can find more:

http://support.microsoft.com/default.aspx?scid=kb;en-us;870675

http://support.microsoft.com/default.aspx?scid=kb;en-us;311231

http://support.microsoft.com/default.aspx?scid=kb;en-us;281293

http://support.microsoft.com/default.aspx?scid=kb;en-us;315886

http://support.microsoft.com/default.aspx?scid=kb;en-us;321183

And finally how to bypass SQL Mail:

http://support.microsoft.com/default.aspx?scid=kb;en-us;312839

Andy

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 2

I do not have the specifics but it is possible (and probably very painful) to get it to work with LotusNotes. I think you'll still need Outlook but you'll also need MSMQ as well. I do not recal the link or whitepaper but I remember reading it.

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Dorothy Boesel Ten Centuries Points: 1024 More actions · Answer 3

It is painful. You have to put Outlook on the server, configure an SMTP account, make sure that the mail is configured to go out only. You should then see the mail profile in SQLMail. If this doesn't work, email me at dboesel@yahoo.com and I will send you my documentation on this procedure. I had to do this a lot at my previous job.

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 4

Could you share this documentation with the community ?

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

JM-92548 Ten Centuries Points: 1108 More actions · Answer 5

it would be great if you can send me this documentation.

joseph.madrinkian@activant.com

Or even share it with the community.

mhempenstall SSC Veteran Points: 276 More actions · Answer 6

You do need Outlook installed on the server which alot of people don't like.

You also need to remember to start the SQL services using a valid windows account and not "local account". You should then log onto the server as that windows user to set up the mail profile otherwise the mail profile will not appear in Enterprise Manager.