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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-09-25 : 09:32:11
|
| Matthew writes "I was wondering if anybody had gotten anywhere with installing Microsoft Outlook 2002 on a SQL 2000 server. I just cannot get it to work !According to Microsoft Outlook 2002 has to be left open all the time for it to process mails because of a change in the MAPI system when using Internet mail (POP3). However this then means the .pst files etc are always open, so sqlmail fails. If Outlook is shutdown all mails are queued, open Outlook and it sends them okay...well sometimes anyway.Can anybody help with this, I really would like to use SQL Mail and the SQL Server Agent to send maintenance mails, etc.Thanks for your help and for reading this far !!Matthew" |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-09-25 : 17:48:45
|
Use outlook 2000  This is a serious answer, SQLMail is twichy enough at best so why introduce separate complications. However, you could try setting up separate profiles for SQLMail and SQLAgent Mail, also here's a couple of usefull KB articles [url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q313969[/url][url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q321183[/url][url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q315886[/url][url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q263556[/url][url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q311231[/url][url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q281293[/url]HTHJasper Smith |
 |
|
|
|
|
|
SQL Mail & Outlook 2002