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-05-24 : 09:45:07
|
| Jamie writes "I am the DBA at our company. We are running a total of about 10 SQL Servers (SQL2K,SP2, all on Win2KAdvSrv,SP2). Only four of those are production servers.Lots of people in the company are pushing for high-availability. I would like to implement Active/Active clustering (and use the "other" node for data warehousing). We have done Active/Passive once before, but then "un-clustered" it because the SQL Mail didn't work. We rely very heavily on SQL Mail and SQL Agent Mail for various alerts, jobs, queries, etc. Some of these are tied into our ERP. When I called MS about it (and checked MSDN), the answer was that MS only partially supports SQL Mail in clustered environment, and doesn't gaurantee it's functionallity. This is apparantely because MAPI is not cluster aware.So, I found an article on your site that shows how to use CDO instead of MAPI. This is great for SQLMail. But what about SQL Agent Mail? Am I just screwed? Can I have a clustered SQL 2000 configuration and still use SQL Agents and alerts to send emails?thanx for your help!jamie" |
|
|
Kevin Snow
Posting Yak Master
149 Posts |
Posted - 2002-05-24 : 11:45:19
|
| It's my understanding that SQL Agent mail uses the MAPI session in the same way SQL MAIL does, so the same restrictions should apply.I've implemented the CDO mail method in place of SQL Mail for All reporting, and no longer use the EMAIL notification options found in SQL Agent (They were locking up anyway).Documentation suggests SQL AGENT Mail can be used on Failover clustering (ACTIVE/PASSIVE), but is strangely silent on ACTIVE/ACTIVE configurations. There are options (having different domain accounts for each node?), but my guess is you're going to have more fun than you bargain for if you try to depend on SQL AGENT MAIL alerts on the Cluster.http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_6auf.asp |
 |
|
|
|
|
|
|
|
SQL 2000 Cluster and SQLMail/SQLAgentMail