Microsoft KB Archive/298723

= BUG: SQL Mail may not be fully supported for use with virtual SQL Servers =

Article ID: 298723

Article Last Modified on 3/18/2006

-

APPLIES TO


 * Microsoft SQL Server 2000 Enterprise Edition
 * Microsoft SQL Server 6.5 Enterprise Edition
 * Microsoft SQL Server 7.0 Enterprise Edition
 * Microsoft SQL Server 2000 Developer Edition

-



This article was previously published under Q298723



BUG #: 213525 (SHILOH_BUGS)



SYMPTOMS
SQL Mail may fail to work at all or after a cluster failover has occurred.



CAUSE
Messaging Application Programming Interface (MAPI) is not cluster-aware.



WORKAROUND
To use SQL Mail with SQL Server 2000 failover clustering, consider the following:
 * An instance of SQL Server 2000 must run on the same Microsoft Windows NT/2000 account on all failover cluster nodes in order for SQL Mail to possibly work on failover clusters.
 * Each failover cluster node must have a MAPI profile with an identical name and settings.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 2000.



MORE INFORMATION
SQL Mail is not fully supportable when used on a SQL Server failover cluster due to the MAPI limitation of not being cluster-aware.

For alerting functions, use another monitoring tool such as System Monitor that is running on another computer.

For additional information, refer to the following subjects in SQL Server 2000 Books Online:
 * Configuring Mail Profiles
 * SQL Mail

For additional information, click the article number below to view the article in the Microsoft Knowledge Base:

263556 INF: How to Configure SQL Mail

Keywords: kbtshoot kbbug kbsqlservmail kbpending KB298723

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.