February 15, 2007 at 3:28 am
We have a SQl server 2000 Cluster having nodes A and B. When we are trying to do the failover from the primary node A to secondary node B it is not happening.
On looking at the event viewer found this message
"Application popup: Microsoft Outlook : Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client."
Also the Sql server Agent error log has the messages
"[LOG] Failed to send any kind of notification to the fail-safe operator ('SQL Admin') for alert 'Sev. 19 Errors'. Check the SQLServerAgent registry entries "
"[265] Unable to resolve email recipient name 'USNATMBSQLAdmin' (reason: The MAPI Call failed) "
I think the problem lies in the fact that sqlmail is not setup properly on both nodes. SQLAgent doesn't seem to want to come up when it is failed over to the secondary node. If anyone has any ideas on how to fix this please let me know.
February 15, 2007 at 6:46 am
- keep in mind OUTLOOK is not cluster aware.
- if you ensist on using outlook, you'll have to perform a second exact ! installation at the node where you didn't yet implement it !
- If possible work with smtpmail (http://www.sqldev.net)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 16, 2007 at 4:11 am
Outlook is installed on both the nodes. I'm getting this error.What does this means
"[265] Unable to resolve email recipient name 'USNATMBSQLAdmin' (reason: The MAPI Call failed)
February 16, 2007 at 4:37 am
- did you provide the same mail-profile (exact !) at the nodes ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 16, 2007 at 5:54 am
my experience is that a mail client won't stop a failover. I assume you're using cluster admin to achieve this?
As posted above you need to set the outlook client on each node independent of each other.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
February 16, 2007 at 6:34 am
yes using the same profile on both the nodes
yes have set the outlook separately on both the nodes independent of each other.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply