Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL Mail/SQL Agent Mail with Lotus Notes

Author  Topic 

gfahrlander
Starting Member

23 Posts

Posted - 2003-05-21 : 13:14:54
Created domain user id for SQL Server and SQL Server agent services.
Services user has administrator auth on server.
Installed Outlook
Installed Notes
Created MAPI profile for services userid
Outlook worked, Notes worked, SQL Server just timed out.
Could send from SQL Server Operator Properties/Notifications Send E-mail button (had to enter notes password to compose Outlook message).

Never got it to work -- had to go with SMTP solution.

Has anyone got SQL Mail and Lotus notes to work?

Will MS and IBM ever get along?

No trees were killed in posting this message. However, a large number of electrons were seriously inconvenienced!

chadmat
The Chadinator

1974 Posts

Posted - 2003-05-21 : 13:19:25
Notes has to be configured as a POP3 internet mail server.

You basically answered the question yourself. You had to enter the password. Since SQLMail runs as a service, there is no one there to enter the password, so it hangs.

-Chad

http://www.clrsoft.com

Software built for the Common Language Runtime.
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2003-05-21 : 13:24:01
And so I guess that's why we don't use it...we get beeped.

I also set up NET SENDS if I need to message and administrator or user if something happens...



Brett

8-)
Go to Top of Page
   

- Advertisement -