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 - 2007-02-08 : 09:45:17
|
| Michael writes "Our company does not allow microsoft office to be installed on our server. I have been trying to get Agent mail (Alerts) to work using Outlook Express. (I had it working using Microsoft Outlook 2003, but they removed it.)I need to know a correct install and setup to make Outlook Express work. (We also are not allowed to have non-expiring password accounts, so I have it setup using my network account). I don't know if I will have to change its password every 30 days as I have to do for Sql Server, and Agent services.We have SQL 2000 Standard Svc Pack 3 on Windows 2003 server Standard edition version 5.2.3790 USING a AMD 64 processor.Our email client is OUTLOOK EXPRESS 6I posted this on the Sql Server 2000 Admin forum, but got no responses." |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-02-08 : 11:33:39
|
| You have to use and extended MAPI client for SQLMail and SQLAgent Mail to work with 32bit SQL 2000. The only extended MAPI client is Outlook (not Outlook express)So, the short answer is that you cannot make this work without using the full Outlook client.Also, there is really no replacement for SQL Agent Mail in SQL Server 2000. So, tools like xp_smtp_sendmail are not direct drop-in replacements for it. Failed job email notifications won't work with anything other than SQL Agent Mail.However, there are some ways to get some of this functionality back, although it requires more logic in the way you set up jobs. Read the following links and see if they help with the problem you are trying to solve.http://www.sqldev.net/xp/xpsmtp.htmhttp://www.dbmaint.com/SmtpAlerter.aspAlso, here is the microsoft KB article discussing SQLMail and SQLAgent Mail and the OUtlook only requirement: http://support.microsoft.com/kb/311231-ec |
 |
|
|
mrock
Starting Member
23 Posts |
Posted - 2007-02-14 : 09:11:48
|
| Thanks,How about 64 bit Sql Server 2000?I am on a 64 bit server. How do I tell if they loaded the 64 bit version?Mike |
|
|
|
|
|
|
Setting up Agent alerts to use Outlook Express