Not yet, but when I do, I expect to have as much fun getting it to work as I did with NT4/SQL7.
John, one thing to consider if you really need sql mail support and you don't want to trust the server to handle everything is to set up identical mapi profiles on both nodes and then set up a stored procedure that does the xp_startmail, all your reads and sends and then an xp_stopmail. It's more cumbersome, but it avoids some of the pitfalls getting SQL Mail to start and run automatically. Ken -----Original Message----- From: John Strongosky [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 28, 2003 5:02 PM To: NT 2000 Discussions Subject: RE: SQLMail Clustering. yuck, yuck yuck,,,,,martin..................thanks ken....so you have it running in a SQL2000 environment? -----Original Message----- From: Martin Blackstone [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 28, 2003 1:58 PM To: NT 2000 Discussions Subject: RE: SQLMail Clustering. After this weekend, I think we all know that SQL doesn't need service packing ever.... -----Original Message----- From: Ken Coughlin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 28, 2003 1:58 PM To: NT 2000 Discussions Subject: RE: SQLMail Clustering. It can be quirky under NT4/SQL7. The majority of the problems I've come across have to do with the SQL Mail config after you've applied a service pack. Once you have it running, it tends to be solid until you apply the next sp. Good Luck, Ken -----Original Message----- From: John Strongosky [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 28, 2003 4:51 PM To: NT 2000 Discussions Subject: SQLMail Clustering. I've got a SQL Server 2000 in a active/passive node and single instance configuration and according to the below "q" article it is not fully supported. I've successfully configured SQL Mail on our development SQL Server and all seems to work fine. Has any one tried to successfully use the workaround that Microsoft's suggest in the article below? SQL Mail and Failover Clustering Using SQL Mail with a SQL Server 2000 virtual server is not completely supported because the underlying MAPI protocol that is used is not cluster-aware. For more information, see the Knowledge Base article "Q263556 - How to Configure SQL Mail" at http://support.microsoft.com/support/kb/articles/q263/5/56.asp ___ \\ - - // (--@-@--) +-----------------oOOo-(_)-oOOo------------------+ | \\_////|\\\\_// | |John M. Strongosky, |San Diego Community College |District Email Administrator |Phone: 619.388.6725 |"8bits down a wire, spoken words fly away, |while written word's stay on" +--------------------------Oooo------------------+ oooO ( ) ( ) ) / \ ( (_/ \_) Remember 9/11, In an Atom Bomb, Chemical, and Biological Detonation we are all Downwinder's... ------ You are subscribed as [EMAIL PROTECTED] Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe send a blank email to %%email.unsub%% ------ You are subscribed as [EMAIL PROTECTED] Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe send a blank email to %%email.unsub%% ------ You are subscribed as [EMAIL PROTECTED] Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe send a blank email to %%email.unsub%% ------ You are subscribed as [EMAIL PROTECTED] Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe send a blank email to %%email.unsub%% ------ You are subscribed as [email protected] Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe send a blank email to [EMAIL PROTECTED]
